环境: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>