1. Verify all the logs have been recovery .

确认archive log已经成功注册并恢复；

2. Stop DR database
关闭dr数据库；

3. Start to offline backup (OS Backup)
备份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 .我开始没退出，还是一直提示锁定，吓得我。。。。

6.      Screenshot some actions and some date file change info.
    确认dr恢复之后的可用性；
    确认dr恢复之后与prd的同步性；

7. Restore related folders from tape to replace the origin folders on DR
回到dr stand by 状态；

8. Switch to recovery mode and continue to recovery log

ITPub博客

Testing SAP standby database open

最新文章