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
Correct Answer: A
Explanation/Reference:
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;
Download Printable PDF. VALID exam to help you PASS.
|
|