备份服务器坏了,一天没注意,归档把磁盘文件塞满了,alert中报错如下:
Tue Apr 7 08:31:53 2009
Errors in file /oracle/admin/gis/bdump/gis_arc0_430402.trc:
ORA-19502: Message 19502 not found; No message file for product=RDBMS, facility=ORA; arguments: [/oracle/exp/arch/gis/ARC_833_1_6719
53037.log] [1957889] [512]
ORA-27063: Message 27063 not found; No message file for product=RDBMS, facility=ORA
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 1048576
ORA-19502: Message 19502 not found; No message file for product=RDBMS, facility=ORA; arguments: [/oracle/exp/arch/gis/ARC_833_1_6719
53037.log] [1957889] [512]
Tue Apr 7 08:31:53 2009
ARCH: Archival stopped, error occurred. Will continue retrying
Tue Apr 7 08:31:53 2009
ORACLE Instance gis - Archival Error
Tue Apr 7 08:31:53 2009
ORA-16014: Message 16014 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [833]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [1] [/oracle/raw/rlv_z_redo_005]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [1] [/oracle/raw/rlv_z_redo_006]
Tue Apr 7 08:31:53 2009
Errors in file /oracle/admin/gis/bdump/gis_arc1_565694.trc:
ORA-16014: Message 16014 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [833]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [1] [/oracle/raw/rlv_z_redo_005]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [1] [/oracle/raw/rlv_z_redo_006]
Tue Apr 7 08:39:18 2009
ARCH: Archival stopped, error occurred. Will continue retrying
Tue Apr 7 08:39:18 2009
ORACLE Instance gis - Archival Error
Tue Apr 7 08:39:18 2009
ORA-16038: Message 16038 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [833]
ORA-00001: Message 1 not found; No message file for product=RDBMS, facility=ORA
Tue Apr 7 08:39:18 2009
Errors in file /oracle/admin/gis/bdump/gis_arc1_565694.trc:
ORA-16038: Message 16038 not found; No message file for product=RDBMS, facility=ORA; arguments: [3] [833]
ORA-00001: Message 1 not found; No message file for product=RDBMS, facility=ORA
Tue Apr 7 08:40:28 2009
ARC0: Closing local archive destination LOG_ARCHIVE_DEST_1: '/oracle/exp/arch/gis/ARC_833_1_671953037.log' (error 19502)
删掉部分归档文件,
再执行:
SQL> alter system switch logfile;
或
SQL> alter system archive log current;
阅读(1277) | 评论(0) | 转发(0) |