Pages

Sunday, March 6, 2022

Changing Oracle Archive Files Location

Need to change /oracle_db/db1/db_igt/arch to /oracle_db/db2/db_igt/arch/
Steps

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /oracle_db/db1/db_igt/arch
Oldest online log sequence     417
Next log sequence to archive   419
Current log sequence           419

select destination,STATUS from v$archive_dest where statuS='VALID';

DESTINATION                           STATUS
------------------------------------- ------------
/oracle_db/db1/db_igt/arch            VALID


SQL> alter system set log_archive_dest_1='LOCATION=/oracle_db/db2/db_igt/arch/' scope=both;
System altered.

SQL> archive log list

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /oracle_db/db2/db_igt/arch/
Oldest online log sequence     417
Next log sequence to archive   419
Current log sequence           419

SQL> alter system switch logfile;
System altered.

SQL> !ls -ltr

total 253952
-rw-r----- 1 oracle dba 260046336 Mar  6 13:59 arch0001_421_1097758151.arc

SQL> !pwd
/oracle_db/db2/db_igt/arch


No comments:

Post a Comment