Error 270 for archive log file ORA-00270: error creating archive log Error 1033 received logging on

来源:互联网 发布:java中js不是数字 编辑:程序博客网 时间:2024/05/20 09:08

alert日志报错如下:

Fri Jan 01 01:37:45 2016
LNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
LNS: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Error 270 for archive log file 1 to 'PRODS'
Errors in file /u01/PROD/db/tech_st/11.2.0/admin/PROD_erpdb/diag/rdbms/prod/PROD1/trace/PROD1_nsa2_24863.trc:
ORA-00270: error creating archive log 
Fri Jan 01 01:38:24 2016
ARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
ARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
FAL[server, ARC0]: Error 270 creating remote archivelog file 'PRODS'
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance PROD1 - Archival Error. Archiver continuing.
Fri Jan 01 01:38:26 2016
Error 1033 received logging on to the standby
Error 1033 for archive log file 2 to 'PRODS'
Errors in file /u01/PROD/db/tech_st/11.2.0/admin/PROD_erpdb/diag/rdbms/prod/PROD1/trace/PROD1_nsa2_24863.trc:
ORA-01033: ORACLE initialization or shutdown in progress
Fri Jan 01 01:38:37 2016

问题原因:

*** 2016-01-01 01:38:24.991
OCISessionBegin failed -1
.. Detailed OCI error val is 9945 and errmsg is 'ORA-09945: Unable to initialize the audit trail file
Linux-x86_64 Error: 28: No space left on device
'
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 9945 and errmsg is 'ORA-09945: Unable to initialize the audit trail file
Linux-x86_64 Error: 28: No space left on device
ORA-01017: invalid username/password; logon denied
'


*** 2016-01-01 01:38:26.085
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 9945 and errmsg is 'ORA-09945: Unable to initialize the audit trail file
Linux-x86_64 Error: 28: No space left on device
ORA-01017: invalid username/password; logon denied
'
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1033 and errmsg is 'ORA-01033: ORACLE initialization or shutdown in progress
'
*** 2016-01-01 01:38:26.111 4338 krsh.c
Error 1033 received logging on to the standby
*** 2016-01-01 01:38:26.111 939 krsu.c
Error 1033 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'PRODS'
Error 1033 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'PRODS'
*** 2016-01-01 01:38:26.111 4338 krsh.c
Error 1033 for archive log file 2 to 'PRODS'
*** 2016-01-01 01:38:26.111 2922 krsi.c
krsi_dst_fail: dest:2 err:1033 force:0 blast:1
ORA-01033: ORACLE initialization or shutdown in progress
Destination is specified with ASYNC=20480






0 0