Steps to change the database to Archivelog Mode:
1. Login to the database server. Connect to sqlplus as sysdba
$sqlplus / as sysdba
2. Shutdown the database
SQL> shutdown immediate
3. Take a full database Backup (Cold Backup in this case)
4. Startup the database in mount stage
SQL> startup mount
5. Enable Archivelog mode
SQL> alter database archivelog;
6. Open the Database.
SQL> Alter database open;
7. Verify the changes.
SQL> archive log list;
1. Login to the database server. Connect to sqlplus as sysdba
$sqlplus / as sysdba
2. Shutdown the database
SQL> shutdown immediate
3. Take a full database Backup (Cold Backup in this case)
4. Startup the database in mount stage
SQL> startup mount
5. Enable Archivelog mode
SQL> alter database archivelog;
6. Open the Database.
SQL> Alter database open;
7. Verify the changes.
SQL> archive log list;