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;