Converting the oracle database from Noarchive log mode to Archive log mode

Converting the oracle database from Noarchive log mode to Archive log mode:

1. Check weather the database is in archive log mode or not.

archive log list

2. Shutdown the database.

shutdown immediate;

3. Start the database in mount mode.

startup mount;

4. Convert the database to archive log mode.

alter database archivelog;

5. Open the database.

alter database open ;

6. Check wheather the database is in archive log mode or not.

archive log mode;

Note: After the database is in archive log mode you must take the full database backup.