Hi Everybody,
Happy Hoildays
I running oracle 8.03 on winnt 4.0 box and get the following error message
ORACLE Instance md - Cannot allocate log. Archival required
Pressto acknowledge message
Can any one help please
Thanks in advance
Vinay
Printable View
Hi Everybody,
Happy Hoildays
I running oracle 8.03 on winnt 4.0 box and get the following error message
ORACLE Instance md - Cannot allocate log. Archival required
Pressto acknowledge message
Can any one help please
Thanks in advance
Vinay
You need to add more redo log groups. The current redo logs are full and have not been archived when the systems is trying to use the log.
Add new log group and it should resolve the issue.
how do I add redo log files. I can not even log into the database
Did u try through svrmgrl uyility
sounds like LOG_ARCHIVE_START is set to false? is it, if it is you need to manually archive your logs, you should set this to true unless you have a specific reason to set it to false