| ORACLE redo log archival [message #52927] |
Wed, 21 August 2002 00:46  |
ritesh kumar tiwary
Messages: 7
Registered: August 2002
|
Junior Member |
|
|
hi friends
I have got an error in my ORACLE server i.e.
WARNING - The Following error occured during ORACLE redo log archival
ORACLE Instance demo can not allocate log, archival required.
what is this means, and my database is running under archival mode
Anybody can help me in this problem
Thanks
|
|
|
|
| Re: ORACLE redo log archival [message #52948 is a reply to message #52927] |
Wed, 21 August 2002 09:58  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
That means you don't have enough redo log groups or the members of each group are too small. The ARCH is still archiving the last redo log group since the LGWR is trying to write new redo logs ( redo logs are cyclical). But in your case LGWR has to wait before the ARCH finish and release the redo log group.
You have two choices:
- create additional redo log groups;
- recreate the members of your redo log groups with bigger size.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
