Demo steps:
First, function
1. The 280 Cluster environment is primary, 480 is Standby, one minute archives, Standby is in the management recovery status
2. Business termination is subject to capital access, shares access, entrusted trading
3. Alter Database Recover Managed Standby Database Finish; ALTER DATABASE OPEN Read Only
4. Check the corresponding table with TOAD
5. Restore to manage recovery status: ALTER DATABASE Recover Managed Standby Database Disconnect from Session;
Second, performance
1. Business termination is a placement, returns, delegate, demonstrating the recovery speed of the spare library, record the total operation
2. Tail -f /export/home/racle/app/oracle/admin/ctsdb/bdump/alert_ctsdb.log
1. Stop the remote archive path, the service terminal is a placement, the newspaper return, delegate, record the total operation of the total operation, compare the operating speed in the disaster recovery environment (this final)
Third, the disaster recovery environment switch
1. Switch the Cluster node, demonstrate the Cluster function
/ usr / cluster / bin / scswitch -z -g oracle-rg -h CTSDB2
2. The service end is functional, demonstrating the success of Cluster
3. Switch back to CTSDB1
/ usr / cluster / bin / scswitch -z -g oracle-rg -h CTSDB1
4. Service end function operation
5. Turn off the Cluster, alone a node's Oracle
/ usr / cluster / bin / scswitch -f -g oracle-rg
Mount / global / oradata
CD / EXPORT / HOME / ORACLE / APP / ORACLE / PRODUCT /
9.2.0
/ network / admin
CP listener.ora.sigle listener.ora
Lsnrctl Start
LSNRCTL START LISTENER_DG
SQLPlus "/ as sysdba"
Startup
6. Switch PRIMARY and STANDBY
P:
Alter Database Commit to Switchover To Physical Standby;
Shutdown immediate;
Startup nomount;
Alter Database
Mount
STANDBY
Database;
S:
Alter Database Commit to Switchover to Primary;
Shutdown immediate;
Startup;
P:
Alter Database Recover Managed Standby Database Disconnect from Session;
7. Modify the configuration, test application of the application gateway
8. Renew Primary and StandBy
9. Turn off Primary, turn off the monitor
LSNRCTL Stop
LSNRCTL Stop Listener_DG
SQLPlus "/ as sysdba"
Shutdown immediate
10. Restore listening configuration:
CD / EXPORT / HOME / ORACLE / APP / ORACLE / PRODUCT /
9.2.0
/ network / admin
CP listener.ora.cluster listener.ora
11. Start Cluster
/ usr / cluster / bin / scswitch -z -g oracle-rg
Test application
