Change Archivelog mode
Change database from noarchivelogmode to archivelogmode
Check your database either archive log mode or no archive log mode
sql> archive log list;
database log mode noarchive
automatic archival disable
If you want change database from no archive log mode to archive log mode…
Follow steps
sql> shutdown immediate
database shutdown.
sql>startup mount
Database mounted.
sql>archive log list;
database log mode noarchive
automatic archival disable
sql>alter database archivelog;
database altered.
sql>archive log start;
sql>show parameter log_archive_start
value
—–
False
sql>alter system set log_archive_start=true scope=spfile;
System altered.
(Note Skip “Sql>archive log start” this step if you are using oracle 10g.Otherwise ORA-32004: obsolete and/or deprecated parameter(s) specified error will be occur.
If you did wrong, check this link
http://azardba.blogspot.com/2008/11/ora-32004-obsolete-andor-deprecated.html )
sql>shutdown immediate
sql>startup
database opened.
sql>archive log list
database log mode Archive
automatic archival Enable
If you want do change archive destination
sql>alter system set log_archive_dest =’\oracle\admin\’ scope=spfile;
System altered.
sql>shutdown immediate
Database shutdown.
sql>startup
database open.
sql>archive log list
database log mode archive
automatic archival enable
Location ‘\orace\admin\’
DBA 