-
Can not allocate log, archival required
Hi all,
For some reason, I got oracle error message about archive. Below is the actual error message:
.....................
Tue Jan 14 10:14:06 2003
ORACLE Instance P - Can not allocate log, archival required
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 13746
All online logs needed archiving
Current log# 1 seq# 13745 mem# 0: /env1/oraredo/P/log1P.dbf
Tue Jan 14 10:14:55 2003
Thread 1 advanced to log sequence 13746
Current log# 2 seq# 13746 mem# 0: /env1/oraredo/P/log2P.dbf
Tue Jan 14 10:15:04 2003
ORACLE Instance P - Can not allocate log, archival required
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 13747
All online logs needed archiving
.....................
Am I going to lose all the data that suppose to be archived? Anybody who had experience regarding above error could give me some explanation why I got this error message?
Oracle: 8.0.6
OS: UNIX
Redolog size : 32 MB
NO. of redolog: 4
Thank you in advance.
regards,
feroz
-
Either add more redo logs or make the existing ones bigger
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
I assume you have automatic archiving enabled for your database.
Have you checked the disk space on your archlog destination? It might be full. If so, make some room in it and archiving will continue.
If this isn't the case or if emptying the archlog destination doesn't help, try the following:
ALTER SYSTEM ARCHIVE LOG STOP;
ALTER SYSTEM ARCHIVE LOG START;
In any case, you won't loose any data becouse of this error. In fact, this error actually prevents you from potentialy loosing data in case media recovery will be needed in the future....
Last edited by jmodic; 01-14-2003 at 07:04 AM.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Hi again,
Thank you for replying. Space is not a problem. I might increase the redolog size and restart the archive process.
regards,
feroz
-
Then, did anybody stopped ARCH process in between? Check If you get any record for "Archive Log Stop" in near-by time in alert.log
-
Hi,
I've checked the alertlog file. Nobody issue ARCH process stop. Could it be heavy usage on the database?
regards,
Feroz
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|