Change Archivelog Destination (FRA)
2 min readScenario: If current Archivelog mountpoint is full then we want to change the Archivelog destination in the database.
It can be done in up are running condition of DB . No downtime required.
For Real application cluster(RAC):
In RAC, the archive destination is pointed to an ASM diskgroup.
SQL> show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string LOCATION=+PROD_DG_FLASH
Change the archive destination: Before pointing the path to new ASM DG, make sure that Diskgroup exists. -- Use sid='*', so that parameter will be changed across all the instance pfiles.
alter system set log_archive_dest_1='LOCATION=+FRA' scope=both sid='*'
System altered.
SQL> select destination,STATUS from v$archive_dest where statuS='VALID';
DESTINATION STATUS
------------------ ---------
+FRA VALID
FOR STANDALONE DATABASE:
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /opt/app/oracle/FRA/Arch
Oldest online log sequence 98674
Next log sequence to archive 98676
Current log sequence 98676
SQL> select destination,status from v$archive_dest where status='VALID';
DESTINATION STATUS
---------------------------------- ---------
/opt/app/oracle/FRA/Arch VALID
Create the new archive location:
mkdir -p /newFRA/arch
Change the destination:
SQL> alter system set log_archive_dest_1='LOCATION=/newFRA/arch' scope=both;
System altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /newFRA/arch
Oldest online log sequence 98674
Next log sequence to archive 98676
Current log sequence 98676
SQL> select destination,status from v$archive_dest where status='VALID';
DESTINATION STATUS
---------------------------------- ---------
/newFRA/arch VALID
Check whether archives are getting generated at new location:
SQL> alter system switch logfile;
System altered.
$ cd /newFRA/arch
$ ls -ltr
total 1231
-rw-r----- 1 oracle oinstall 12049920 Aug 16 10:34 1_98675_754673927.dbf
