Enable and disable archive log mode in oracle

Enable or disable archive log in Oracle Database

Check the database is running in archive log mode

select log_mode from v$database;

Check the location where archive is created

Archive log list;

select dest_name, status, destination from v$archive_dest;

Enable in archivelog mode if disabled

alter system set log_archive_dest_1='LOCATION=D:\archive\orcl' scope=both;
shutdown immediate
startup mount
alter database archivelog;
alter database open;

Disable in archive Mode:

shutdown immediate;
start mount
alter database noarchivelog;
alter database open;

Change the location of Archive it going to full

-- first check the parameter which configured.
show parameter log_archive_dest

--Second change the location which having sufficient space
alter system set log_archive_dest_1='LOCATION=D:\archive\orcl' scope=both;

--Third backup the archive and clear with rman
RMAN>backup archivelog all delete input;

 

Advertisements

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.