ARCHIVE LOG:
In Oracle, the Archive log is a copy of a filled redo log file, The process of converting the redo log into archiving log file is called Archiving.
STEPS TO CHANGE THE ARCHIVE LOG DESTINATION:
Note: Database should be in ‘Mount Stage’ in order to change the state(enable or disable) of archive log,
STEP 1:
Opening database
Here ‘ELEVENG’ is the database name and it is in the mount stage.
STEP 2: Verifying recovery file and archive log state:
Command: show parameter recovery;
Archive log mode is enabled and also the default location ‘fast_recovery_area’ is shown,
STEP 3:
altering archive destination location –
command :
alter system set log_archive_dest_1= ‘LOCATION=/u01/app/oracle/fast_recovery_area/ELEVENG/archivelog/01’ scope=both;
by executing the above command we can change the destination,
after executing the previous command , We can check the Archive mode and location,
select destination,STATUS from v$archive_dest where statuS=’VALID’;
verifications: Check whether archives are getting generated at the new location:
Now the log files are switching, So the location of the Archive log has been successfully changed.
