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
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;