| Oracle 9.2.0 -Archive log error even after multiplexing !!! [message #58624] |
Mon, 22 September 2003 11:47  |
Roy
Messages: 30
Registered: May 2002
|
Member |
|
|
Hi,
Recently one of our filers crashed and few databases went down. The weird thing is that, some of our Oracle databases are on Oracle 9i and the archive logs are written to multiple locations. In spite of that, when the filer went down (even though one of those locations were not available) it started given the following error during our exports on sunday. Why does it give such error, if the archive logs has multiple destinations to keep writing???
Filesystem kbytes used avail capacity Mounted on
fs1:/vol/vol5/pool5/dbsdta32 124878792 124739656 139136 100% /opt/dbsdta32
You have ten seconds to abort this operation. Press Cltrl-C to stop now.
Exporting grxs database at Sat Sep 20 19:02:11 PDT 2003
Export: Release 9.2.0.4.0 - Production on Sat Sep 20 19:02:11 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
EXP-00056: ORACLE error 257 encountered
ORA-00257: archiver error. Connect internal only, until freed.
Username:
EXP-00030: Unexpected End-Of-File encountered while reading input
EXP-00000: Export terminated unsuccessfully
|
|
|
|
| Re: Oracle 9.2.0 -Archive log error even after multiplexing !!! [message #58627 is a reply to message #58624] |
Mon, 22 September 2003 12:47  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Roy,
you have several possibilities :
maybe the archivelog destination on the filer was defined MANDATORY or
maybe the ARchiver was not able to fullfill LOG_ARCHIVE_MIN_SUCCEED_DEST number of destinations becos of 1 or more filesystem failures or
maybe you defined all destinations to be MANDATORY and you had multiple failures
Check your LOG_ARCHIVE* parameters and adjust them to cater for failures(ie change anysome to OPTIONAL, decrease LOG_ARCHIVE_MIN_SUCCEED_DEST etc ). You know the environment better .
HTH
Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
