Change default Archive log destination in Oracle

Change the default Archive log destination in Oracle

1. Find the current archive log destination

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination E:\oracle\12.2.0\dbhome_1\rdbms
Oldest online log sequence 4556
Next log sequence to archive 4558
Current log sequence 4558
OR
SQL> select destination,STATUS from v$archive_dest where statuS='VALID';

DESTINATION                        STATUS
---------------------------------- ---------
E:\oracle\12.2.0\dbhome_1\rdbms    VALID


2. Create the new folder or location for new archive destination with OS commands.
3. Change the Destination of archive log.
alter system set log_archive_dest_1='LOCATION=D:\Oracle\Archivelog' scope=both;
4. Verified with commands:
SQL> Alter system switch logfiles;
SQL>archive log list;

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 )

Connecting to %s

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