oracle dg异常处理,DG同步异常问题分析处理(归档日志文件损坏)

2018-05-24T13:22:03.656143+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 49049 in header is not log file《==============================

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1490.318.976964987'

ORA-17502: ksfdcre:4 Failed to create file +DGRECOVER

ORA-15041: diskgroup "DGRECOVER" space exhausted<=============磁盘组空间已满，看起来这个损坏的归档日志应该与ASM磁盘组空间满了有关

ORA-17502: ksfdcre:4 Failed to create file +DGRECOVER

ORA-15041: diskgroup "DGRECOVER" space exhausted

2018-05-24T13:22:25.524719+08:00

Error ORA-235 occurred during an un-locked control file transaction. This

error can be ignored. The control file transaction will be retried.

2018-05-24T13:22:27.296438+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 49049 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1490.318.976964987'

2018-05-24T13:22:54.905226+08:00

Error ORA-235 occurred during an un-locked control file transaction. This

error can be ignored. The control file transaction will be retried.

2018-05-24T13:22:56.888381+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 49049 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1490.318.976964987'

2018-05-24T13:23:19.777477+08:00

Error ORA-235 occurred during an un-locked control file transaction. This

error can be ignored. The control file transaction will be retried.

2018-05-24T13:23:24.044757+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 49049 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1490.318.976964987'

2018-05-24T13:24:47.608317+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 8 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1512.285.976966639'

2018-05-24T13:24:48.364578+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 0 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1502.300.976966159'

2018-05-24T13:24:48.658017+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 15 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1499.303.976965985'

2018-05-24T13:24:53.282869+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 192 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1495.308.976965677'

2018-05-24T13:24:53.492761+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 49049 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1490.318.976964987'

2018-05-24T13:25:05.524094+08:00

Archived Log entry 5630 added for T-2.S-1624 ID 0xe5ac04db LAD:1

krse_arc_driver_core: Successful archiving of previously failed ORL

Unable to create archive log file '+DGRECOVER'

2018-05-24T13:25:06.255375+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_arc0_41291.trc:

ORA-19504: failed to create file "+DGRECOVER"

ORA-17502: ksfdcre:4 Failed to create file +DGRECOVER

ORA-15041: diskgroup "DGRECOVER" space exhausted

ARC0: Error 19504 Creating archive log file to '+DGRECOVER'

2018-05-24T13:25:10.697858+08:00

Error ORA-235 occurred during an un-locked control file transaction. This

error can be ignored. The control file transaction will be retried.

2018-05-24T13:25:11.665704+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 8 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1512.285.976966639'

2018-05-24T13:25:13.282221+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 0 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1502.300.976966159'

2018-05-24T13:25:13.426907+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 15 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1499.303.976965985'

2018-05-24T13:25:13.563661+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 192 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1495.308.976965677'

2018-05-24T13:25:14.596499+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 49049 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1490.318.976964987'

2018-05-24T13:25:23.604762+08:00

Error ORA-235 occurred during an un-locked control file transaction. This

error can be ignored. The control file transaction will be retried.

2018-05-24T13:25:24.220078+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 8 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1512.285.976966639'

2018-05-24T13:25:24.586326+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 0 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1502.300.976966159'

2018-05-24T13:25:24.996687+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 15 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1499.303.976965985'

2018-05-24T13:25:25.383332+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 192 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1495.308.976965677'

2018-05-24T13:25:26.017913+08:00

Errors in file /oracle/app/oracle/diag/rdbms/racdb12c/racdb12c2/trace/racdb12c2_tt00_41289.trc:

ORA-00317: file type 49049 in header is not log file

ORA-00334: archived log: '+DGRECOVER/RACDB12C/ARCHIVELOG/2018_05_24/thread_2_seq_1490.318.976964987'