Linux under oracle11g DG Build (iv): Subsequent validation operations
Environment
Name |
Main Library |
Standby Library |
Host Name |
Bjsrv |
Shsrv |
Software version |
RedHat Enterprise5.5, Oracle 11g 11.2.0.1 |
RedHat Enterprise5.5, Oracle 11g 11.2.0.1 |
Under the main library
$ tail-f /u01/app/oracle/diag/rdbms/bjdb/testdb12/trace/alert_testdb12.log
For DG, be sure to turn on the alarm log.
Under the Reserve library
$ Tail-f/u01/app/oracle/diag/rdbms/shdb/shdb/trace/alert_shdb.log
4. Open the main library, prepare the library, verify the database switch
Boot order: First open the library, then open the main library, open the main library monitoring (lsnrctl start);
Shutdown Order: Close the main library first, and then close the library.
Switch Log Validation Master repository
Main Library Operations
Process ideas:
Main Library switch log (3 times): Main library switch log → form archive log → archive log is sent to the standby library → The repository receives the archive log from the main library → do recover.
sql>altersystem switch logfile;
"Supplemental": The recovery zone is enabled but not used.
Check the alarm log discovery warning under the standby library:
Sql>Show parameter Recovery
The query found that the recovery zone was not created on the standby, so this small error was reported in the alarm log.
[Email protected]:/home/oracle> Mkdir/u01/app/oracle/fast_recovery_area
Re-create the recovery area
reported that the document already exists, it will temporarily ignore the question.
To do recover on the standby library.
sql>recovermanaged standby database disconnect from session;
Start the MRP (Media Recovery process) session
See the process of archiving logs in the main library
Standby Alarm Log information:
Main Library View Log process
Sql>Selectmax (sequence#) from V$archived_log where name was not null;
Check that the main library archive process serial number is in the same repository to accept the archive process sequence number is synchronized, all 17
To switch the main library one more time:
sql>altersystem switch logfile;
Standby to observe the alarm log:
DG built successfully.
Subsequent updates in **************************
Statement:
Original works, from the "Blue Blog" blog, allow the reprint, please be sure to indicate the source (Http://blog.csdn.net/huangyanlong) when reproduced.
The author is entitled to be held liable for copyright related matters.