今天在给客户实施dataguard时，在duplicate standby database时报ORA-05507 ERROR

主库备份脚本如下:

rman target / nocatalog

backup database format '/rman/%U.bak' include current controlfile for standby;

然后在备库，用duplicate命令在线进行复制时报以下错误

rman target sys/abcdefg@orcl nocatalog auxiliary /

duplicate target database for standby nofilenamecheck;

报rman-05507 standby controlfile checkpoint (62423113) is more recent than duplication point in time (62423113)

通过查询metalink

Problem Description
--------------------

You notice that the checkpoint of the standby controlfile is more recent than
the specified RMAN duplication point in time or the last archivelog.

Solution Description
---------------------
If an explicit point in time was specified, you can change it to be
the same as the controlfile checkpoint.

Or, you can archive (and backup/copy)the current log. Switching the online
redolog and backup the archive should get everything in sync.

也就是说控制文件比较新，而数据文件比较旧，这时需要增进检查点，更新数据文件

可以用alter system archive log current命令解决

备份脚本如下：增加alter system archive log current

rman target / nocatalog

backup database format '/rman/%U.bak' include current controlfile for standby;

sql 'alter system archive log current';

Example:
--------
RMAN-05507: standby controlfile checkpoint (29952631) is more recent than
duplication point in time (29952625)

Try using backing up current log in backup script. with the current log switch
and backing up the archivelog.

run {
--use type as appropriate
    allocate channel c1 type 'SBT_TAPE' parms
---use env as appropriate of your location
"ENV=(TDPO_OPTFILE=e:\oracle\wpl\817\database\tdpo.opt)";
    backup database include current controlfile for standby;
    sql "alter system archive log current";
    backup archivelog all;
}

References:
-----------

Additional Search Words
-----------------------
rman-05507 standby controlfile duplicate db

ITPub博客

duplicate standby database 报ORA-05507错误解决方法

最新文章