Changing Fast Recovery Area destination


My database is running in archive log mode, but flashback is disabled because I do not need it.

The FRA is set to /flasharch mount point.

Now, I am going to change the FRA location to /flasharch01 mount point due to space limitation.

What to do with archivelog in the old location. Do I need to move the old files to new location?

Could you guys please guide me step by step?

RMAN uses control file instead of recovery catalog.

Should I create a recovery catalog? if yes.. please how? I need steps please.

As, I can't increase the FRA location. The only way to change the location is the solution. Could you please share the steps how to move the old files and how to catalog them? RMAN using control file instead of recovery catalog.

Best Answer

My problem is solved. I have changed the FRA to new location.

alter system set db_recovery_file_dest='/flasharch01';
alter system set db_recovery_file_dest_size=750G;

Copy all archive log file which is generated in old and copy to new location. using OS level copy commond.

RMAN> catalog db_recovery_file_dest; 


RMAN> catalog recovery area; 


RMAN> catalog start with 'New location Path';  
RMAN> catalog start with 'New location Path'; 

create PFILE='/flasharch/file_raiddb.ora' from spfile;

RMAN> crosscheck copy; 
RMAN> crosscheck backup;   
RMAN> delete expired copy; 
RMAN> delete expired backup;
alter system set log_archive_dest_1='location=/flasharch01';
create spfile from pfile=''/flasharch/file_raiddb.ora''

CREATE SPFILE='/flasharch/file_raiddb.ora'
FROM PFILE='/flasharch/file_raiddb.ora';