SAP ABAP Table ORA_S_DG_DATABASE (ORA: Dataguard Database Structure)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework
⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework
Basic Data
Table Category | INTTAB | Structure |
Structure | ORA_S_DG_DATABASE | Table Relationship Diagram |
Short Description | ORA: Dataguard Database Structure |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | INST_ID | ORA_INST_ID | ORA_INST_ID | DEC | 22 | 0 | Oracle monitor: Instance ID | ||
2 | DBID | ORA_DBID | ORA_DEC_22 | DEC | 22 | 0 | Oracle monitoring: database id | ||
3 | NAME | ORA_NAME_9 | CHAR9 | CHAR | 9 | 0 | ORA: Name | ||
4 | CREATED_D | ORA_CREA_DATE_CHAR | CHAR16 | CHAR | 16 | 0 | ORA: Creation Date (CHAR) | ||
5 | CREATED_T | ORA_CREA_TIME_CHAR | CHAR16 | CHAR | 16 | 0 | ORA: Creation Time (CHAR) | ||
6 | RESETLOGS_CHANGE# | ORA_RESETLOGS_CHANGE | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: resetlogs change number | ||
7 | RESETLOGS_TIME_D | ORA_CREA_DATE_CHAR | CHAR16 | CHAR | 16 | 0 | ORA: Creation Date (CHAR) | ||
8 | RESETLOGS_TIME_T | ORA_CREA_TIME_CHAR | CHAR16 | CHAR | 16 | 0 | ORA: Creation Time (CHAR) | ||
9 | PRIOR_RESETLOGS_CHANGE# | ORA_PRIOR_RESETLOGS_CHANGE | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: prior resetlogs change number | ||
10 | PRIOR_RESETLOGS_TIME_D | ORA_CREA_DATE_CHAR | CHAR16 | CHAR | 16 | 0 | ORA: Creation Date (CHAR) | ||
11 | PRIOR_RESETLOGS_TIME_T | ORA_CREA_TIME_CHAR | CHAR16 | CHAR | 16 | 0 | ORA: Creation Time (CHAR) | ||
12 | LOG_MODE | ORA_LOG_MODE | ORA_CHAR_12 | CHAR | 12 | 0 | Oracle monitoring: db log mode | ||
13 | CHECKPOINT_CHANGE# | ORA_CHECKPOINT_CHANGE | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: checkpoint change# | ||
14 | ARCHIVE_CHANGE# | ORA_ARCHIVE_CHANGE | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: archive change number | ||
15 | CONTROLFILE_TYPE | ORA_CONTROLFILE_TYPE | ORA_CHAR_7 | CHAR | 7 | 0 | Oracle monitoring: db controlfile type | ||
16 | CONTROLFILE_CREATED_D | ORA_CREA_DATE_CHAR | CHAR16 | CHAR | 16 | 0 | ORA: Creation Date (CHAR) | ||
17 | CONTROLFILE_CREATED_T | ORA_CREA_TIME_CHAR | CHAR16 | CHAR | 16 | 0 | ORA: Creation Time (CHAR) | ||
18 | CONTROLFILE_SEQUENCE# | ORA_CONTROLFILE_SEQUENCE | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: db controlfile sequence number | ||
19 | CONTROLFILE_CHANGE# | ORA_CONTROLFILE_CHANGE | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: controlfile change number | ||
20 | CONTROLFILE_TIME_D | ORA_CREA_DATE_CHAR | CHAR16 | CHAR | 16 | 0 | ORA: Creation Date (CHAR) | ||
21 | CONTROLFILE_TIME_T | ORA_CREA_TIME_CHAR | CHAR16 | CHAR | 16 | 0 | ORA: Creation Time (CHAR) | ||
22 | OPEN_RESETLOGS | ORA_OPEN_RESETLOGS | ORA_CHAR_11 | CHAR | 11 | 0 | Oracle monitoring: db open reset logs | ||
23 | VERSION_TIME_D | ORA_CREA_DATE_CHAR | CHAR16 | CHAR | 16 | 0 | ORA: Creation Date (CHAR) | ||
24 | VERSION_TIME_T | ORA_CREA_TIME_CHAR | CHAR16 | CHAR | 16 | 0 | ORA: Creation Time (CHAR) | ||
25 | OPEN_MODE | ORA_OPEN_MODE | ORA_CHAR_10 | CHAR | 10 | 0 | Oracle monitoring: db open mode | ||
26 | PROTECTION_MODE | ORA_PROTECTION_MODE | ORA_CHAR_20 | CHAR | 20 | 0 | Oracle monitoring: db protection mode | ||
27 | PROTECTION_LEVEL | ORA_PROTECTION_LEVEL | ORA_CHAR_20 | CHAR | 20 | 0 | Oracle monitoring: db protection level | ||
28 | REMOTE_ARCHIVE | ORA_REMOTE_ARCHIVE | ORA_CHAR_8 | CHAR | 8 | 0 | Oracle monitoring: db remote archive | ||
29 | ACTIVATION# | ORA_ACTIVATION | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: db activation number | ||
30 | DATABASE_ROLE | ORA_DATABASE_ROLE | ORA_CHAR_16 | CHAR | 16 | 0 | Oracle monitoring: database role | ||
31 | ARCHIVELOG_CHANGE# | ORA_ARCHIVELOG_CHANGE | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: db archivelog chg nb | ||
32 | SWITCHOVER_STATUS | ORA_SWITCHOVER_STATUS | ORA_CHAR_18 | CHAR | 18 | 0 | Oracle monitoring: db switchover status | ||
33 | DATAGUARD_BROKE | ORA_DATAGUARD_BROKER | ORA_CHAR_8 | CHAR | 8 | 0 | Oracle monitoring: db dataguard broker | ||
34 | GUARD_STATUS | ORA_GUARD_STATUS | ORA_CHAR_7 | CHAR | 7 | 0 | Oracle monitoring: db guard status | ||
35 | SUPPLEMENTAL_LOG_DATA_MIN | ORA_SUPPLEMENTAL_LOG_DATA_MIN | ORA_CHAR_3 | CHAR | 3 | 0 | Oracle monitoring: db supplemental log data min | ||
36 | SUPPLEMENTAL_LOG_DATA_PK | ORA_SUPPLEMENTAL_LOG_DATA_PK | ORA_CHAR_3 | CHAR | 3 | 0 | Oracle monitoring: db supplemental log data pk | ||
37 | SUPPLEMENTAL_LOG_DATA_UI | ORA_SUPPLEMENTAL_LOG_DATA_UI | ORA_CHAR_3 | CHAR | 3 | 0 | Oracle monitoring: db supplemental log data ui | ||
38 | FORCE_LOGGING | ORA_FORCE_LOGGING | ORA_CHAR_3 | CHAR | 3 | 0 | Oracle monitoring: db force logging |
History
Last changed by/on | SAP | 20070813 |
SAP Release Created in | 710 |