When I start implement data guard, I find out some helpful hits from Oracle document. In Data Guard monitoring, primary database management actions and where to find information related to these actions.
Database action
|
Primary Database
|
Standby Database
|
Enable or disable a redo thread
|
Alert log
V$THREAD
|
Alert log
|
Display database role, protection
mode, protection level, switchover
status, fast-start failover information,
and so forth
|
V$DATABASE
|
V$DATABASE
|
Add or drop a redo log file group
|
Alert log
V$LOG
STATUS column of V$LOGFILE
|
Alert log
|
CREATE CONTROLFILE
|
Alert log
|
Alert log
|
Monitor Redo Apply
|
Alert log
V$ARCHIVE_DEST_STATUS
|
Alert log
V$ARCHIVED_LOG
V$LOG_HISTORY
V$MANAGED_STANDBY
|
Change tablespace status
|
V$RECOVER_FILE
DBA_TABLESPACES
Alert log
|
V$RECOVER_FILE
DBA_TABLESPACES
|
Add or drop a datafile or tablespace
|
DBA_DATA_FILES
Alert log
|
V$DATAFILE
Alert log
|
Rename a datafile
|
V$DATAFILE
Alert log
|
V$DATAFILE
Alert log
|
Unlogged or unrecoverable
operations
|
V$DATAFILE
V$DATABASE
|
Alert log
|
Monitor redo transport
|
V$ARCHIVE_DEST_STATUS
V$ARCHIVED_LOG
V$ARCHIVE_DEST
Alert log
|
V$ARCHIVED_LOG
Alert log
|
Issue OPEN RESETLOGS or CLEAR
UNARCHIVED LOGFILES statements
|
Alert log
|
Alert log
|
Change initialization parameter
|
Alert log
|
Alert log
|
No comments:
Post a Comment