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
If you must move the fast recovery area of your database to a new location, then follow this procedure:
Start a SQL*Plus on the target database and change the DB_RECOVERY_FILE_DEST initialization parameter. For example, enter the following command to set the destination to the ASM disk group disk1:
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1′ SCOPE=BOTH SID=’*’;
After you change this parameter, all new fast recovery area files are created in the new location.
Either leave or move the permanent files, flashback logs, and transient files in the old flash recovery location.
If you leave the existing files in the flash recovery, then the database deletes the transient files from the old fast recovery area as they become eligible for deletion.
If you must move the old files to the new fast recovery area, then see the Oracle Database Storage Administrator’s Guide. The procedure for moving database files into and out of an ASM disk group with RMAN works when moving files into and out of a fast recovery area.
214