Urgent! Cannot allocate log

[gschuah]

Hi,
I had disable my database archive_log_start=false. But after a day I hit the above problem. The db was stop moving. Please let me know if there are any step that I miss out.
My archive log list:-
database log mode => archive mode
automatic archival => disable
Thanks in advance

[SANJAY_G]

To change the mode to NOARCHIVELOG you should do this..
startup mount;
alter database noarchivelog;
alter database open;

Setting log_archive_start = false will only disable automatic archiveing but your db remains in archivelog mode.


HTH

Sanjay

[tharakab]

Hi,

Is it you wanted your database in NOARCHIVELOG mode or you wanted to stop automatic arhiving. If it is a) then follow what Sanjay has mentioned else you have to manual archive the log files by issuing the command: a) alter system archive log all OR if u want the database in ARCHIVELOG AND WANT TO MANUALLY ENABLE ARCHIVING do it by issuing the command :alter system archive log start;

[gschuah]

Hi,
I think I miss out the "alter database noarchivelog;" step. Anyway thank you for your valuable input.
Rdgs,
GS