1、备库操作
(1)取消日志的应用
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
(2)停库
shut immediate
(3)启动到nomount模式
startup nomount
2、主库操作
(1)创建standby controlfile
alter database create physical standby controlfile as '/tmp/controlfile_standby';
(2)拷贝standby controlfile到DG备库,并覆盖原控制文件
(3)拷贝主库全库备份及归档备份到DG备库
3、备库操作
(1)确认主库的standby controlfile已拷贝并覆盖controlfile,启动到mount模式
(2)进入rman,设置主库备份存放的目录路径为恢复路径并引用备份
catalog start with '/oradata/bak/';
(3)恢复数据库
restore database;
(4)打开数据库
alter database open;
(5)执行日志的应用
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28371090/viewspace-2149281/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28371090/viewspace-2149281/