arch 进程出问题 ???
ORA-00312: online log 6 thread 1: '/u01/product/oradata/rma/redo3.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Wed Dec 17 16:35:39 2003
Errors in file /u01/product/admin/rma/udump/ora_2942.trc:
ORA-00313: open failed for members of log group 7 of thread 1
ORA-00312: online log 7 thread 1: '/u01/product/oradata/rma/redo4.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Wed Dec 17 16:35:39 2003
alter database activate standby database
Wed Dec 17 16:35:39 2003
RESETLOGS after incomplete recovery UNTIL CHANGE 875517412
Wed Dec 17 16:35:39 2003
Errors in file /u01/product/admin/rma/udump/ora_2942.trc:
ORA-00313: open failed for members of log group 4 of thread 1
ORA-00312: online log 4 thread 1: '/u01/product/oradata/rma/redo1.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Wed Dec 17 16:35:39 2003
Errors in file /u01/product/admin/rma/udump/ora_2942.trc:
ORA-00313: open failed for members of log group 5 of thread 1
ORA-00312: online log 5 thread 1: '/u01/product/oradata/rma/redo2.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Wed Dec 17 16:35:39 2003
Errors in file /u01/product/admin/rma/udump/ora_2942.trc:
ORA-00313: open failed for members of log group 6 of thread 1
ORA-00312: online log 6 thread 1: '/u01/product/oradata/rma/redo3.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Wed Dec 17 16:35:39 2003
Errors in file /u01/product/admin/rma/udump/ora_2942.trc:
ORA-00313: open failed for members of log group 8 of thread 1
ORA-00312: online log 8 thread 1: '/u01/product/oradata/rma/redo5.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Completed: alter database activate standby database
Wed Dec 17 16:35:45 2003
alter database mount
Wed Dec 17 16:35:49 2003
Successful mount of redo thread 1, with mount id 1249914405.
Wed Dec 17 16:35:49 2003
ARC0: Beginning to archive log# 6 seq# 353
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive log# 6 seq# 353
ARC0: Beginning to archive log# 6 seq# 353
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive log# 6 seq# 353
ARC0: Beginning to archive log# 6 seq# 353
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive log# 6 seq# 353
ARC0: Beginning to archive log# 6 seq# 353
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive log# 6 seq# 353
ARC0: Beginning to archive log# 6 seq# 353
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive log# 6 seq# 353
ARC0: Beginning to archive log# 6 seq# 353
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive log# 6 seq# 353
ARC0: Beginning to archive log# 6 seq# 353
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive log# 6 seq# 353
ARC0: Beginning to archive log# 6 seq# 353
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive log# 6 seq# 353
Sun Dec 21 06:36:51 2003
ARC1: Beginning to archive log# 6 seq# 353
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive log# 6 seq# 353
Sun Dec 21 06:36:51 2003
ARC0: Beginning to archive log# 6 seq# 353
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive log# 6 seq# 353
Sun Dec 21 06:36:51 2003
ARC1: Beginning to archive log# 6 seq# 353
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive log# 6 seq# 353
Sun Dec 21 06:36:52 2003
ARC0: Beginning to archive log# 6 seq# 353
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive log# 6 seq# 353
Sun Dec 21 06:36:52 2003
ARC1: Beginning to archive log# 6 seq# 353
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive log# 6 seq# 353
Sun Dec 21 06:36:52 2003
ARC0: Beginning to archive log# 6 seq# 353
ARC0: Archiving not possible: No primary destinations
以下是我查询的异常cause及解决action , 不过我的ARCHIVE_ LOG_DEST没有问题, 可以归档, 很正常 。
==================================================================
ORA-00257 archiver error. Connect internal only, until freed.
Cause: The archiver process received an error while trying to archive a redo log. If the problem is not resolved soon, the database will stop executing transactions. The most likely cause of this message is the destination device is out of space to store the redo log file.
Action: Check the archiver trace file for a detailed description of the problem. Also, verify that the device specified in the initialization parameter ARCHIVE_ LOG_DEST is set up properly for archiving.