dg备库恢复
dg备库恢复
执行全备:
RMAN> run{ allocate channel a1 type disk; backup full database include current controlfile for standby plus archivelog ; release channel a1; } rman target sys/oracle@orcl auxiliary / duplicate target database for standby nofilenamecheck dorecover;
在备库上恢复时提示:
Oracle Error: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/s01/oracle/app/oracle/oradata/orcl/system01.dbf' RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 08/16/2013 04:35:46 RMAN-03015: error occurred in stored script Memory Script RMAN-06053: unable to perform media recovery because of missing log RMAN-06025: no backup of archived log for thread 1 with sequence 23 and starting SCN of 1135707 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 22 and starting SCN of 1135400 found to restore
错误大致意思:dbf文件与控制文件的版本号对不上
修改主库备份脚本:
1.backup database plus archivelog; 2.backup current controlfile for standdy;
再恢复,ok!
备库取消redo:
alter database recover managed standby database cancel;
启用:
alter database recover managed standby database using current logfile disconnect from session;
rman恢复:
duplicate target database for standby nofilenamecheck dorecover;