Oracle 11g通过SCN做增量备份修复standby库详细过程(八)

2015-07-16 14:56:46 · 作者: · 浏览: 158
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 1sequenc