Skip to content
Advertisements

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\’

Advertisements
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: