【ORA-16038】Oracle Rman备份故障处理

某日在检查数据库备份时发现 EMC NetWorker 某数据库备份报错,如下图:

network1

备份状态显示Fail 但完成度是100%

随后查看EMC Networker后台的报告日志

network2

日志内容如下:

已取消输出 24478 字节。  

channel t5: finished piece 1 at 13-JUL-15  piece handle=bak_level_0_HISTORYD_blqbvnoq tag=TAG20150713T214524 comment=API Version 2.0,MMS Version 1.5.0.0  

c[……]阅读全文

Continue reading

【ORA-00312】Redo log文件损坏故障解决

 

故障现象:数据库hung住

查看alert日志:

Fri Jul 10 09:22:20 2015

Errors in file /opt/oracle/admin/orclbj/bdump/orclbj_arc1_1264.trc:

ORA-00354: Message 354 not found; No message file for product=RDBMS, facility=ORA

ORA-00353: Message 353 not found; No message file for product=RDBMS, facility=ORA; arguments: [103705] [8411181136] [07/10/2015 01:13:32]

ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [1] [/opt/oracle/oradata/orclbj/redo03.log]

ARC1: All Archive destinations made inactive due to error 354

Fri Jul 10 09:22:20 2015

ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: ‘/opt/oracle/arch/1_43884_752778831.dbf’ (error 354)

(orclbj)

ARC1: Failed to archive thread 1 sequence 43884 (354)

ARCH: Archival stopped, error occurred. Will continue retrying

Fri Jul 10 09:22:20 2015

ORACLE Instance orclbj – Archival Error

Fri Jul 10 09:22:20 2015

ORA-16038: Message 16038 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [43884]

ORA-00354: Message 354 not found; No message file for product=RDBMS, facility=ORA

ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [1] [/opt/oracle/oradata/orclbj/redo03.log]

Fri Jul 10 09:22:20 2015

Errors in file /opt/oracle/admin/orclbj/bdump/orclbj_arc1_1264.trc:

[……]阅读全文

Continue reading