| Archive process error [message #60104] |
Thu, 15 January 2004 20:30  |
shankar
Messages: 29
Registered: January 2002
|
Junior Member |
|
|
Hi
Can anybody help me in solving the following problem ?
Archive process error: oracle instance INTOOLS - cannot allocate log. Archival required.
thanks in advance
Shankar
|
|
|
|
| Re: Archive process error [message #60105 is a reply to message #60104] |
Thu, 15 January 2004 20:34  |
shankar
Messages: 29
Registered: January 2002
|
Junior Member |
|
|
Hi
I am facing a problem with the following server message in Event Viewer. Can anybody help me ?
Archive process error: Oracle instance INTOOLS - cannot allocate log. Archival required.
Thanks in advance
Shankar
|
|
|
|
| Re: Archive process error [message #60134 is a reply to message #60105] |
Sat, 17 January 2004 06:04 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Hi
as the message indicates, LGWR wasnt able to overwrite the contents of the online redolog file since it hasnt been archived yet by ARCH process. You will need to make sure you have LOG_ARCHIVE_START=true to startup the archiver process when the instance starts up and if there are arch process already,make sure LOG_ARCHIVE_DEST is not full. You may need to start more archiver processes to speed up archiving so as not to block LGWR.
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
