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

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

主库备份脚本如下:

rman target / nocatalog

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

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

rman target 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 currentrman 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