1. Verify all the logs have been recovery .
确认archive log已经成功注册并恢复;
2. Stop DR database
关闭dr数据库;
关闭dr数据库;
3. Start to offline backup (OS Backup)
备份dr系统(包括数据库与整个操作系统);
4. Startup standby database in standby database. Use the following commands:
启动dr系统并打开数据库;
备份dr系统(包括数据库与整个操作系统);
4. Startup standby database in standby database. Use the following commands:
启动dr系统并打开数据库;
Sqlplus /nolog
SQL>Connect /as sysdba
SQL>Startup nomount
SQL>Alter database mount standby database;
SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
SQL> ALTER DATABASE OPEN;
5. Use account sap* to login client 300 to do the some actions .
注意:login/no_automatic_user_sapstar这个参数的设置,1为不允许sap*账号登陆,所以需要先登录client:000,然后将其设置为0才能登陆client 300
如果client:300中sap*锁定,可以删除usr02中记录,但是记得一定要commit,而且要退出sqlplus .我开始没退出,还是一直提示锁定,吓得我。。。。
注意:login/no_automatic_user_sapstar这个参数的设置,1为不允许sap*账号登陆,所以需要先登录client:000,然后将其设置为0才能登陆client 300
如果client:300中sap*锁定,可以删除usr02中记录,但是记得一定要commit,而且要退出sqlplus .我开始没退出,还是一直提示锁定,吓得我。。。。
6. Screenshot some actions and some date file change info.
确认dr恢复之后的可用性;
确认dr恢复之后与prd的同步性;
确认dr恢复之后的可用性;
确认dr恢复之后与prd的同步性;
7. Restore related folders from tape to replace the origin folders on DR
回到dr stand by 状态;
回到dr stand by 状态;
8. Switch to recovery mode and continue to recovery log
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22078283/viewspace-659559/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22078283/viewspace-659559/