| ARCHIVE and NO ARCHIVE !?!?! [message #58563] |
Wed, 17 September 2003 03:32  |
ruthf
Messages: 1
Registered: September 2003
|
Junior Member |
|
|
We changed our server from ARCHIVE to NO ARCHIVE mode.
WHY DO I GET THE FOLLOWING ERROR ???????????
Thread 1 cannot allocate new log, sequence 2107
All online logs needed archiving
Current log# 1 seq# 2106 mem# 0: E:ORACLEORADATAORC1REDO01_N.LOG
Current log# 1 seq# 2106 mem# 1: H:ORACLEORADATAREDO01_2.LOG
|
|
|
|
| Re: ARCHIVE and NO ARCHIVE !?!?! [message #58566 is a reply to message #58563] |
Wed, 17 September 2003 07:21  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Could you cut&paste the whole error message (including the error code ) ? How exactly did you switch from ARCHIVELOG mode to NOARCHIVELOG ?
If I ever have to do that,I would
alter system checkpoint;
alter system archivelog all;
shutdown immediate;
comment out any Log_archive parameters in init.ora
startup mount;
alter database noarchivelog;
alter database open;
Keep in mind that,you may get similar errors (nothing about archiving though) along with 'checkpoint not complete' even when you are operating the database in Noarchivelog mode. The reason in such a case would be the LGWR process tries to switch to the online redolog file whose checkpointing hasnt been completed yet.
HTH
Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
