eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

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


历史上的今天...
    >> 2012-06-04文章:
    >> 2009-06-04文章:

无觅

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

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

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


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com