Linux under oracle11g DG Build (iv): Maybe verify operation

Linux under oracle11g DG Build (iv): Maybe verify operation

Environment

Name	Main Library	Standby Library
Host Name	Bjsrv	Shsrv
Software version number	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: Open the Library first, then open the main library. Open the main library for monitoring (lsnrctl start);

Shutdown Order: Close the main library first. 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

Create recovery area again

reported that the document already exists, it will temporarily avoid the problem.

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;

The main library archive process serial number is synchronized with the accepted archive process serial number in the repository. are 17

To switch the main library one more time:

sql>altersystem switch logfile;

Standby to observe the alarm log:

DG built successfully.

Maybe update in **************************

Statement:
Original works, from the "Blue Blog" blog, agreed to 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.

Linux under oracle11g DG Build (iv): Maybe verify operation