« ORACLE 9iR2 软件下载地址收藏 | Blog首页 | Oracle进程：LMS 进程与Oracle RAC »
duplicate standby 与 RMAN-05507 错误
作者：eygle |【转载时请以超链接形式标明文章出处和作者信息及本声明】链接：http://www.eygle.com/archives/2008/06/duplicate_standby_rman_05507.html
在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-
历史上的今天...
>> 2009-06-04文章:
------
这篇 【duplicate standby 与 RMAN-05507 错误】来自 eygle.com | CSDN网摘| del.icio.us|Google订阅 | 鲜果订阅 | 抓虾订阅
By eygle on 2008-06-04 10:56 | Comments (2) | Posted to Advanced | Edit |
留言 (2)
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
Posted by: songguozhe at November 28, 2008 11:16 AM
对啊,我也遇到这个问题,不知道怎么解决
Posted by: zm at December 30, 2008 10:02 AM