eygle Eygle.
Advanced 2008-06-04

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 2008-06-04 10:56 评论 (2)
eygle
eygle

前Oracle ACE Director,云和恩墨创始人。技术为骨,历史为脉,人文为魂。

返回首页

2 Comments

oracle 10.2.0.3
dataguard前边配置完成后
到rman这块
在standby start nomount时
rman远程连不上库 这是为何呢
我新建了库open下可以远程连 nomount不行
请问什么原因有可能

RMAN> connect auxiliary sys/oracle@dbstandby

MAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04006: 来自辅助数据库的错误: ORA-12528: TNS: 监听程序: 所有适用例程都无法建立新连接

RMAN> quit

ncdata/home/oracle$sqlplus sys/oracle@dbstandby as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on 星期五 11月 28 11:04:01 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
这个是open下可以连

连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

对啊,我也遇到这个问题,不知道怎么解决