« ORACLE 9iR2 软件下载地址收藏 | Blog首页 | Oracle进程：LMS 进程与Oracle RAC »

duplicate standby 与 RMAN-05507 错误

在Oracle9i中使用RMAN进行DataGuard数据库的创建过程中，可能会遇到如下错误：

RMAN> duplicate target database for standby dorecover;

RMAN-03002: failure of Duplicate Db command at 11/16/2007 10:23:12
RMAN-05507: standby controlfile checkpoint (23456133) is more recent than duplication point in time (23412363)

这个错误是说控制文件教新，也就是说相较数据文件而言，控制文件是新的，这是由于控制文件的持续更新的原因。
所以在执行Duplicate之前，我们需要在源数据库执行一次LOG ARCHIVE动作，增加一下检查点。

SQL> alter system archive log current;

System altered.

Oracle文档对这个错误的解释如下：

RMAN-05507: standby controlfile checkpoint (string) is more recent than duplication point in time (string)
Cause: A DUPLICATE FOR STANDBY command was issued, but the checkpoint of the controlfile is more recent than the last archivelog or the specified point in time.
Action: If an explicit point in time was specified, change it to be at least the controlfile checkpoint; otherwise archive (and backup/copy) the current log.

archive log current正式解决这个问题的方法之一！

-The End-

By eygle on 2008-06-04 10:56 | Comments (2) | Advanced | 1913 |

DataGuard