Saturday, October 24, 2020

How to change archivelog destination in oracle

 STEP 1:

Open the  Database

                                                   

STEP 2: 

Verifying recovery file and archive log state:

command: show parameter recovery;





STEP 3:

altering archvie destination location -

command : alter system set log_archive_dest_1= 'LOCATION=/u01/app/oracle/fast_recovery_area/ELEVENG/archivelog/01' scope=both;

 


 




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




verfications: Check whether archives are getting generated at new location:








No comments:

Post a Comment

ASM

Rename Asm DiskGroup Name On Oracle 12c

  Step1:Startup asm with created asm pfile. startup pfile=$ORACLE_HOME/dbs/init+ASM.ora; Step2:Dismount all disks.  alter diskgroup all dism...