Views Relevant to Oracle Data Guard
| LOGICAL | DBA_LOGSTDBY_EVENTS | Contains information about the activity of the logical standby database system. It can be used to determine the cause of failures that occur when SQL Apply is applying redo to logical standby databases. |
| LOGICAL | DBA_LOGSTDBY_LOG | Shows the log files registered for logical standby databases. |
| LOGICAL | DBA_LOGSTDBY_NOT_UNIQUE | Identifies tables that have no primary and no non-null unique indexes. |
| LOGICAL | DBA_LOGSTDBY_PARAMETERS | Contains the list of parameters used by SQL apply. |
| LOGICAL | DBA_LOGSTDBY_PROGRESS | Describes the progress of SQL Apply on the logical standby database. |
| LOGICAL | DBA_LOGSTDBY_SKIP | Lists the tables that will be skipped by SQL Apply. |
| LOGICAL | DBA_LOGSTDBY_SKIP_TRANSACTION | Lists the skip settings chosen. |
| DBA_LOGSTDBY_UNSUPPORTED | Identifies the schemas and tables (and columns in those tables) that contain unsupported datatypes. Use this view when you are preparing to create a logical standby database. | |
| PHYSICAL/LOGICAL | V$ARCHIVE_DEST |
Describes, for the current instance, all of the destinations in the Data Guard configuration, including each destination’s current value, mode, and status. |
| PHYSICAL/LOGICAL | V$ARCHIVE_DEST_STATUS |
Displays runtime and configuration information for the archived redo log destinations. |
| PHYSICAL/LOGICAL | V$ARCHIVE_GAP | Displays information to help you identify a gap in the archived redo log files. |
| PHYSICAL/LOGICAL | V$ARCHIVED_LOG | Displays archive redo log information from the control file, including names of the archived redo log files. |
| PHYSICAL/LOGICAL | V$DATABASE | Provides database information from the control file. |
| PHYSICAL/LOGICAL | V$DATABASE_INCARNATION | Displays information about all database incarnations. Oracle Database creates a new incarnation whenever a database is opened with the RESETLOGS option. Records about the current and the previous incarnation are also contained in the V$DATABASE view. |
| PHYSICAL/LOGICAL | V$DATAFILE | Provides datafile information from the control file. |
| PHYSICAL/LOGICAL | V$DATAGUARD_CONFIG | Lists the unique database names defined with the DB_UNIQUE_NAME and LOG_ARCHIVE_CONFIG initialization parameters. |
| PHYSICAL/LOGICAL | V$DATAGUARD_STATUS | Displays and records events that would typically be triggered by any message to the alert log or server process trace files. |
| PHYSICAL/LOGICAL | V$LOG | Contains log file information from the online redo log files. |
| PHYSICAL/LOGICAL | V$LOGFILE | Contains information about the online redo log files and standby redo log files. |
| PHYSICAL/LOGICAL | V$LOG_HISTORY | Contains log history information from the control file. |
| PHYSICAL | V$MANAGED_STANDBY |
Displays current status information for Oracle database processes related to physical standby databases. |
| PHYSICAL/LOGICAL | V$STANDBY_LOG | Contains log file information from the standby redo log files. |
Leave a Reply
You must be logged in to post a comment.