You are working on an instance started using the SPFILE. You want to move the Flash Recovery
Area of your database to a new location. You want the Flashback log files to be stored in the new
location. Given below are the steps to accomplish the task in random order:
1) Shut down the instance.
2) Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.
3) Execute the ALTER DATABASE FLASHBACK OFF command.
4) Start up the instance and mount the database.
5) Execute the ALTER DATABASE FLASHBACK ON command.
6) Open the database.
Select the correct order in which these tasks need to be performed.
A.
2, 1, 4, 3, 5, 6
B.
1, 4, 3, 2, 6, 5
C.
1, 4, 2, 6, 3, 5
D.
3, 2, 1, 4, 5, 6
Explanation:
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;
If you need to actually move your current permanent files, transient files, to the new Flash
Recovery Area, then follow the following 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;