archive log setup/to put database in archive log mode (12c and 11.2)

follow below steps to put database in archive log mode.

1) create pfile from spfile
2) edit the pfile '
comment db_recovery* parameter if you dont want to use..
add below line
*.log_archive_dest_1='LOCATION=+XXX'
3) startup mount with the edited pfile file.
4) alter database archivelog;
5) alter database open.
6) create spfile from the pfile and bounce the database.




to disable:-

1) create a pfile from spfile.
2) shutdown database.
3) startup mount
4) alter database noarchivelog;
5) alter database open.

Hope this helps.....