https://blog.csdn.net/cuilingqiao0657/article/details/100492566
http://blog.itpub.net/7728585/viewspace-2138061/
方法一:
正确方法 操作步骤 :
standby中执行 backup database -> backup controlfile -> backup archivelog
新恢复DB中执行 restore controlfile -> restore database ->catalog start with 'archivelog' -> recover database -> open
(read only)
方法二:
dataguard主库和物理备库主要是controlfile文件有区别,用restore可以查看含有primary,standby关键字
利用物理备库rman备份文件恢复过程:
startup nomount;
restore primary controlfile from '.............';
sql 'alter database mount';
restore database;
recover database;
alter database open resetlogs;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/31397003/viewspace-2907489/ ,如需转载,请注明出处,否则将追究法律责任。