oracle duplicate rman 06025,dg备库恢复-Oracle

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;