通过RMAN备份standby database成功恢复还原

来源:这里教程网 时间:2026-03-03 17:44:56 作者:

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;

相关推荐