Quote Originally Posted by abdel
Reeshe,

You should know that, in real life situation one of the decisions that the DBA has to take is whether or not to operate his database in Archivelog mode. This means he has to have a thorough understanding of both operating mode. By default a database runs in noarchivelog mode. When you want to shift to archive mode, some configurations are necessary. You should add few parameters in you init.ora file. But the most important are:
log_archive_start=true, log_archive_dest and log_archive_format. Of course you do that after cleanly shutting down you database. Once those parameters are configured, you start up your Db in mount stage and issue the alter database archivelog command. Next you shut it down(cleanly) again and start it anew. You can check whether the archiving is enable by querying the v$database table and selecting the log_mode field. If you wanna stop the automatic archiving you start the Db in mount stage and issue the alter database noarchivelog.

why add a reply over a week later and add nothing?