Using STANDBY_ARCHIVE_DEST parameterdefault value as /data/oracle/oradgdata/standby_archive
Wed May 13 20:54:42 2015
Incremental restore complete of datafile 4/home/oradata/powerdes/users01.dbf
checkpoint is 11134253054
last deallocation scn is 10905979642
Wed May 13 20:54:53 2015
Incremental restore complete of datafile 8/home/oradata/powerdes/help01.dbf
checkpoint is 11134253054
last deallocation scn is 9881798870
Wed May 13 20:55:08 2015
Incremental restore complete of datafile 9/home/oradata/powerdes/adobelc01.dbf
checkpoint is 11134253054
Wed May 13 20:55:21 2015
Incremental restore complete of datafile 10/home/oradata/powerdes/sms01.dbf
checkpoint is 11134253054
Wed May 13 20:55:34 2015
Incremental restore complete of datafile 11/home/oradata/powerdes/plcrm01.dbf
checkpoint is 11134253054
Incremental restore complete of datafile 7/home/oradata/powerdes/pl01.dbf
checkpoint is 11134253054
last deallocation scn is 10905470965
Wed May 13 20:56:24 2015
db_recovery_file_dest_size of 15360 MB is0.00% used. This is a
user-specified limit on the amount of spacethat will be used by this
database for recovery-related files, anddoes not reflect the amount of
space available in the underlyingfilesystem or ASM diskgroup.
Wed May 13 20:56:26 2015
Incremental restore complete of datafile 2/home/oradata/powerdes/sysaux01.dbf
checkpoint is 11134253054
last deallocation scn is 10906515871
Wed May 13 20:56:43 2015
Incremental restore complete of datafile 1/home/oradata/powerdes/system01.dbf
checkpoint is 11134253054
last deallocation scn is 10825889348
Incremental restore complete of datafile 6/home/oradata/powerdes/plas01.dbf
checkpoint is 11134253054
last deallocation scn is 10905977986
Incremental restore complete of datafile 3/home/oradata/powerdes/undotbs01.dbf
checkpoint is 11134253054
last deallocation scn is 10908635608
Wed May 13 20:59:58 2015
Incremental restore complete of datafile 5/home/oradata/powerdes/powerdesk01.dbf
checkpoint is 11134253054
last deallocation scn is 10906663694
12，备库上重新启动应用日志
ALTER DATABASE recover managed standby DATABASE disconnect FROM SESSION;
SQL>ALTER DATABASE recover managed standby DATABASE disconnect FROM SESSION;
Databasealtered.
SQL>
后台alert日志输出为：
ALTER DATABASE recover managed standby DATABASE disconnect FROM SESSION
Attemptto start background Managed Standby Recovery process (powerdes)
WedMay 13 21:04:41 2015
MRP0started with pid=19, OS id=23729
MRP0:Background Managed Standby Recovery process started (powerdes)
started logmerger process
WedMay 13 21:04:46 2015
ManagedStandby Recovery not using Real Time Apply
ParallelMedia Recovery started with 16 slaves
Waitingfor all non-current ORLs to be archived...
Allnon-current ORLs have been archived.
MediaRecovery Waiting for thread 1 sequence 32510
Completed:ALTER DATABASE recover managed standby DATABASE disconnect FROM SESSION
13，主库操作往备库传输归档日志
命令为：
ALTER system SET log_archive_dest_state_2 ='enable';
去备库后台alert日志信息为：
Standby controlfile consistent with primary
SRL log 4 needs clearing because log hasnot been created
Errors in file/oracle/app/oracle/diag/rdbms/pddgunq/powerdes/trace/powerdes_rfs_23767.trc:
ORA-00367: checksum error in log fileheader
ORA-00315: log 4 of thread 0, wrong thread# 1 in header
ORA-00312: online log 4 thread 0:'/home/oradata/powerdes/redo_dg_01.log'
SRL log 5 needs clearing because log hasnot been created
Errors in file/oracle/app/oracle/diag/rdbms/pddgunq/powerdes/trace/powerdes_rfs_23767.trc:
ORA-00367: checksum error in log fileheader
ORA-00315: log 5 of thread 0, wrong thread# 1 in header
ORA-00312: online log 5 thread 0:'/home/oradata/powerdes/redo_dg_02.log'
SRL log 6 needs clearing because log hasnot been created
Errors in file/oracle/app/oracle/diag/rdbms/pddgunq/powerdes/trace/powerdes_rfs_23767.trc:
ORA-00367: checksum error in log fileheader
ORA-00315: log 6 of thread 0, wrong thread# 1 in header
ORA-00312: online log 6 thread 0:'/home/oradata/powerdes/redo_dg_03.log'
SRL log 5 needs clearing because log hasnot been created
Errors in file/oracle/app/oracle/diag/rdbms/pddgunq/powerdes/trace/powerdes_rfs_23767.trc:
ORA-00367: checksum error in log fileheader
ORA-00315: log 5 of thread 0, wrong thread# 1 in header
ORA-00312: online log 5 thread 0:'/home/oradata/powerdes/redo_dg_02.log'
SRL log 6 needs clearing because log hasnot been created
Errors in file/oracle/app/oracle/diag/rdbms/pddgunq/powerdes/trace/powerdes_rfs_23767.trc:
ORA-00367: checksum error in log fileheader
ORA-00315: log 6 of thread 0, wrong thread# 1 in header
ORA-00312: online log 6 thread 0: '/home/oradata/powerdes/redo_dg_03.log'
SRL log 6 needs clearing because log hasnot been created
Errors in file/oracle/app/oracle/diag/rdbms/pddgunq/powerdes/trace/powerdes_rfs_23767.trc:
ORA-00367: checksum error in log fileheader
ORA-00315: log 6 of thread 0, wrong thread# 1 in header
ORA-00312: online log 6 thread 0:'/home/oradata/powerdes/redo_dg_03.log'
RFS[1]: No standby redo logfiles of filesize 52428800 AND block size 512 exist
Clearing online log 6 of thread 0 sequencenumber 0
Errors in file/oracle/app/oracle/diag/rdbms/pddgunq/powerdes/trace/powerdes_rfs_23767.trc:
ORA-00367: checksum error in log fileheader
ORA-00315: log 6 of thread 0, wrong thread# 1 in header
ORA-00312: online log 6 thread 0:'/home/oradata/powerdes/redo_dg_03.log'
Wed May 13 21:06:47 2015
Clearing online log 4 of thread 0 sequencenumber 0
Errors in file/oracle/app/oracle/diag/rdbms/pddgunq/powerdes/trace/powerdes_arc4_23630.trc:
ORA-00367: checksum error in log fileheader
ORA-00315: log 4 of thread 0, wrong thread# 1 in header
ORA-00312: online log 4 thread 0:'/home/oradata/powerdes/redo_dg_01.log'
Clearing online log 5 of thread 0 sequencenumber 0
Errors in file/oracle/app/oracle/diag/rdbms/pddgunq/powerdes/trace/powerdes_arc4_23630.trc:
ORA-00367: checksum error in log fileheader
ORA-00315: log 5 of thread 0, wrong thread# 1 in header
ORA-00312: online log 5 thread 0:'/home/oradata/powerdes/redo_dg_02.log'
RFS[1]: Selected log 4 for thread 1sequence 32511 dbid -903205653 branch 821708334
Wed May 13 21:06:51 2015
RFS[2]: Assigned to RFS process 23775
RFS[2]: Identified database type as'physical standby': Client is ARCH pid 20139
RFS[2]: Selected log 5 for thread 1sequence 32510 dbid -903205653 branch 821708334
Wed May 13 21:06:52 2015
RFS[3]: Assigned to RFS process 23777
RFS[3]: Identified database type as'physical standby': Client is ARCH pid 20131
Wed May 13 21:06:52 2015
Archived Log entry 1 added for thread 1sequence 32510 ID 0xca2ab4eb dest 3:
Wed May 13 21:06:52 2015
Media Recovery Log/data/oracle/oradgdata/standby_archive/1_32510_821708334.dbf
Wed May 13 21:06:54 2015
Archived Log entry 2 added for thread 1sequence 32511 ID 0xca2ab4eb dest 3:
Changing standby controlfile to MAXIMUMAVAILABILITY level
RFS[1]: Selected log 4 for thread 1sequence 32512 dbid -903205653 branch 821708334
Wed May 13 21:07:07 2015
Media Recovery Log/data/oracle/oradgdata/standby_archive/1_32511_821708334.dbf
Media Recovery Waiting for thread 1sequence 32512 (in transit)
14，去主库备库查看归档日志情况，是否保持一致
主库：