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 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