Hi Friends,

User did not 'alter database noarchivelog'

He changed log_archive_start to false and shut down (immediate) and then restarted the database. On restart the database hung for a little while.


I have told him that next time he needs to turn archivelog off to :

Shut down db.
startup mount exclusive
connect internal
alter database noarchivelog
alter database open

and to restart :

shut down db
startup mount exclusive
connect internal
alter database archivelog
alter database open


Does this sound right ?


Thanks for your help guys..

Suresh