How do you put database is ARCHIVELOG mode, explain procedure ?

1)Check whether database is in ArchiveLog or Noarchive , SQL>archive log list

2)If it is in NoArchive log fllow below steps to enable database into ArchiveLog

3)To set a single location for ARchiveLogs open Parameter file and set the following parameter,

LOG_ARCHIVE_DEST='PATH'

4)Start database in Mount state 5)Here also you can check about the mode of Database

SQL>select log_mode from v$database;

6)To bring database to Archivelog mode

SQL>alter database archivelog;

To bring database to Noarchivelog mode SQL>alter database noarchivelog;

7)Finally Open the database.

Instead of rehashing and possibly getting something wrong, it is all outlined in the Database Administrators Guide documentation Changing the Database Archiving Mode. (This is for 10g, see appropriate Database Administrators Guide for your version if you are using something different).

-Dave