Select the correct order in which these tasks need to be performed.

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.

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *