How to change Flash Recovery Area to a new location

PURPOSE
-------
 
This document shows how to change the Flash Recovery Area destination and
how to move the files from old area to new area.
 
 
How to change Flash Recovery Area to a new location ?
-----------------------------------------------------
 
If you need to move the Flash Recovery Area of your database to a new location, 
invoke SQL*Plus to change the DB_RECOVERY_FILE_DEST initialization parameter. 
For example:
 
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='+disk1' SCOPE=BOTH SID='*';
 
After you change this parameter, all new Flash Recovery Area files will be 
created in the new location.
 
The permanent files (control files and online redolog files), flashback logs 
and transient files can be left in the old Flash Recovery Area location. The 
database will delete the transient files from the old Flash Recovery Area 
location as they become eligible for deletion.
 
For the FLASHBACK logfiles to be able to to pick up the new 'db_recovery_file_dest' location, 
the flashback option needs to be toggled off and on.
 
This can be done like this:
- Shutdown the Database
- Startup mount the Database:
  SQL> startup mount;
- 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;
 
  • July 11, 2018 | 14 views
  • Comments