日期:2014-05-16  浏览次数:20312 次

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;