RMAN-05507: standby controlfile checkpoint

最新推荐文章于 2023-01-09 21:09:54 发布

转载最新推荐文章于 2023-01-09 21:09:54 发布 · 228 阅读

标签

#数据库

本文介绍了解决Oracle RAC环境下RMAN-05507错误的具体步骤，该错误通常出现在尝试创建Standby数据库时，由于控制文件中的检查点比数据文件中的检查点更新而导致。文章详细记录了作者遇到的问题及尝试的各种解决方案。

环境:oracle 9.2.0.6,源数据库为两节点RAC，在另一个节点做STANDBY时报RMAN-05507: standby controlfile checkpoint
的错误，这是因为控制文件中记录的检查点比数据文件记录的检查点新，一般采取手工做几次归档即可解决，但在这里发现
做了几次归档， CHECKPOINT_CHANGE#一直不会改变，过程如下
sql statement: alter database mount standby database
released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/22/2016 14:58:56
RMAN-05507: standby controlfile checkpoint (9726747421688) is more recent than duplication point in time (9726747421566)

RMAN>

SQL> col CHECKPOINT_CHANGE# format '9999999999999'
SQL> select CHECKPOINT_CHANGE#
from v$database;

CHECKPOINT_CHANGE#
------------------
9726747421566

SQL>

查了资料需要进行归档操作，但仍然不会改变

SQL> alter system archive log current;

System altered.

检查归档参数
SQL> connect / as sysdba
Connected.
SQL> show parameter archi

NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
archive_lag_target integer
0
log_archive_dest string

log_archive_dest_1 string
LOCATION=/opt/oracle/oradata/i
town/archive01
log_archive_dest_10 string

NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
log_archive_dest_2 string
LOCATION=/opt/oracle/oradata/i
town/archive02
log_archive_dest_3 string
SERVICE=STANDBY optional
log_archive_dest_4 string

log_archive_dest_5 string

NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
log_archive_dest_6 string

log_archive_dest_7 string

log_archive_dest_8 string

log_archive_dest_9 string

log_archive_dest_state_1 string

NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
enable
log_archive_dest_state_10 string
enable
log_archive_dest_state_2 string
enable
log_archive_dest_state_3 string
DEFER
log_archive_dest_state_4 string
enable

NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
log_archive_dest_state_5 string
enable
log_archive_dest_state_6 string
enable
log_archive_dest_state_7 string
enable
log_archive_dest_state_8 string
enable
log_archive_dest_state_9 string

NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
enable
log_archive_duplex_dest string

log_archive_format string
%t_%s.dbf
log_archive_max_processes integer
2
log_archive_min_succeed_dest integer
1

NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
log_archive_start boolean
TRUE
log_archive_trace integer
0
remote_archive_enable string
true
standby_archive_dest string
?/dbs/arch
SQL>
SQL>
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_3=ENABLE SCOPE=BOTH;

System altered.

SQL> alter system archive log current;

System altered.

SQL> exit

SQL> col CONTROLFILE_CHANGE# format '999999999999999999'
SQL> select CONTROLFILE_CHANGE#
2 from v$database;

CONTROLFILE_CHANGE#
-------------------
9726747437615

SQL> col CHECKPOINT_CHANGE# format '9999999999999'
SQL> select CHECKPOINT_CHANGE#
2 from v$database;

CHECKPOINT_CHANGE#
------------------
9726747434636

SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26870952/viewspace-2128985/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26870952/viewspace-2128985/