Friday, April 12, 2013

Data Guard monitoring, primary and Standby databases management actions

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