Change the method from Flash Recovery Area (FRA) to a new path, recoveryfra

Change the method from Flash Recovery Area (FRA) to a new path, recoveryfra

Change the Flash Recovery Area (FRA) to a new path.

Source:
How to change Flash Recovery Area to a new location? (Documentation ID 305651.1)

Objectives:
This article describes how to change the FRA destination and how to move file from the old FRA to the new FRA.

Solution:
If you need to change your FRA to the new path, you need to change the DB_RECOVERY_FILE_DEST initialization parameter from sqlplus:

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='+disk1' SCOPE=BOTH SID='*';

After you change this parameter, all new FRA files will be created in the new path.

Permanent file (control file and online log file), flash log and temporary file can be placed in the old FRA area. When these temporary files can be deleted, the database will delete these temporary files from the old FRA area.

In order to use the new 'db _ recovery_file_dest 'location for the flashback log, the database's flashback option needs to be off and then on

The method is as follows:

- Shutdown the Database       SQL> shutdown immediate - Startup mount the Database:   SQL> startup mount;  - Drop the garanteed restore points       SQL> select * from v$restore_point;        drop restore point <name>; - Toggle the Flashback off:   SQL> alter database flashback off;  - Toggle the Flashback on:   SQL> alter database flashback on;  - Open the Database:   SQL> alter database open;

If you need to move your permanent files and temporary files to the new FRA area, follow these steps:
1) To move the existing backupsets and archived redo log files, use the following command:

   RMAN> BACKUP AS COPY ARCHIVELOG ALL DELETE INPUT;    RMAN> BACKUP DEVICE TYPE DISK BACKUPSET ALL DELETE INPUT;

2) To move the datafile copies. Run the below command for each datafile copy:

RMAN> BACKUP AS COPY DATAFILECOPY <name> DELETE INPUT;

Where the <name> is the datafilecopy name in the old recovery area.

3) To move the controlfile from the old Flash Recovery Area to new one.
Change the location in the parameter CONTROL_FILES to the new location
And restart the instance in NOMOUNT.

RMAN> RESTORE CONTROLFILE FROM 'filename_of_old_control_file';

4) To move the online redo logs. Use the commands to add a log file stored in
The new Flash Recovery Area and drop the logfile in the old Flash Recovery Area
For each redo log group.

SQL> alter database add logfile size 100M;SQL> alter database drop logfile '<name of the old redo log>';

Oracle will clean up transient files remaining in the old Flash Recovery Area
Location as they become eligible for deletion.

 

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.