69.You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area

69.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

答案：A

解析：

1.打开、关闭闪回需要在mount或者open状态下

2.修改DB_RECOVERY_FILE_DEST需要mount、open下

这道题我感觉都可以，挨着都测试一下,从后往前测试

首先看下当前的配置

SQL> select flashback_on from v$database;

FLASHBACK_ON

——————

YES

–当前闪回开着

SQL> show parameter db_re               

NAME                                 TYPE        VALUE

———————————— ———– ——————————

db_recovery_file_dest                string      /home/oracle/db_recover

db_recovery_file_dest_size           big integer 4122M

db_recycle_cache_size                big integer 0

SQL> ! ls -l /home/oracle/db_recover/WAHAHA3/flashback

total 102420

-rw-r—–. 1 oracle oinstall 52436992 Jul 21 15:40 o1_mf_cs0y16z7_.flb

-rw-r—–. 1 oracle oinstall 52436992 Jul 21 15:22 o1_mf_cs0y1mv6_.flb

按照D的步骤来进行配置 D:3,2,1,4,5,6

SQL> ALTER DATABASE FLASHBACK OFF;

Database altered.

SQL> alter system set DB_RECOVERY_FILE_DEST=’/u01/oracle/fast_recovery_area’ scope=both;

System altered.

SQL> shutdown immediate

SQL> startup mount;

SQL> ALTER DATABASE FLASHBACK ON;

SQL> alter database open;

–验证

[oracle@wahaha3 flashback]$ ls -l

total 0

[oracle@wahaha3 flashback]$ pwd

/home/oracle/db_recover/WAHAHA3/flashback

–这里是原来的路径，文件没有了

[oracle@wahaha3 flashback]$ pwd

/u01/oracle/fast_recovery_area/WAHAHA3/flashback

[oracle@wahaha3 flashback]$ ls -l

total 102420

-rw-r—–. 1 oracle oinstall 52436992 Jul 21 15:52 o1_mf_cs0zrf5o_.flb

-rw-r—–. 1 oracle oinstall 52436992 Jul 21 15:51 o1_mf_cs0zrky5_.flb

–这里是新改的路径，说明D也是对的，但是这里文件名是改变了

按照C的步骤来进行配置 D:1, 4, 2, 6, 3, 5

SQL> shutdown immediate

SQL> startup mount

SQL> alter system set DB_RECOVERY_FILE_DEST=’/home/oracle/db_recover’ scope=both;

SQL> alter database open;

SQL> ALTER DATABASE FLASHBACK OFF;

SQL> ALTER DATABASE FLASHBACK ON;

[oracle@wahaha3 flashback]$ pwd

/home/oracle/db_recover/WAHAHA3/flashback

[oracle@wahaha3 flashback]$ ls -l

total 102420

-rw-r—–. 1 oracle oinstall 52436992 Jul 21 16:03 o1_mf_cs10dhdd_.flb

-rw-r—–. 1 oracle oinstall 52436992 Jul 21 16:02 o1_mf_cs10dw8o_.flb

–新的路径下有了

[oracle@wahaha3 flashback]$ pwd

/u01/oracle/fast_recovery_area/WAHAHA3/flashback

[oracle@wahaha3 flashback]$ ls -l

total 0

–旧的没有了

按照B的步骤进行配置B.1, 4, 3, 2, 6, 5

SQL> shutdown immediate

SQL> startup mount;

SQL> ALTER DATABASE FLASHBACK OFF;

SQL> alter system set DB_RECOVERY_FILE_DEST=’/u01/oracle/fast_recovery_area’ scope=both;

SQL> alter database open;

SQL> ALTER DATABASE FLASHBACK ON;

–验证

[oracle@wahaha3 flashback]$ ls -l

total 102420

-rw-r—–. 1 oracle oinstall 52436992 Jul 22 00:57 o1_mf_cs1zqmq0_.flb

-rw-r—–. 1 oracle oinstall 52436992 Jul 22 00:57 o1_mf_cs1zqq4m_.flb

[oracle@wahaha3 flashback]$ pwd

/u01/oracle/fast_recovery_area/WAHAHA3/flashback

–新的路径下有了

[oracle@wahaha3 flashback]$ ls -l

total 0

[oracle@wahaha3 flashback]$ pwd

/home/oracle/db_recover/WAHAHA3/flashback

–旧的没有了

按照A的步骤进行配置A.2, 1, 4, 3, 5, 6

SQL> alter system set DB_RECOVERY_FILE_DEST=’/home/oracle/db_recover’ scope=both;

SQL> shutdown immediate;

SQL> startup mount;

SQL> ALTER DATABASE FLASHBACK OFF;

SQL> ALTER DATABASE FLASHBACK ON;

SQL> alter database open;

–验证

[oracle@wahaha3 flashback]$ ls -l

total 102420

-rw-r—–. 1 oracle oinstall 52436992 Jul 22 01:01 o1_mf_cs1zz52l_.flb

-rw-r—–. 1 oracle oinstall 52436992 Jul 22 01:01 o1_mf_cs1zz7fy_.flb

[oracle@wahaha3 flashback]$ pwd

/home/oracle/db_recover/WAHAHA3/flashback

[oracle@wahaha3 flashback]$ ls -l

total 0

[oracle@wahaha3 flashback]$ pwd

/u01/oracle/fast_recovery_area/WAHAHA3/flashback

总结：上面四个都可以改变，说明只要修改路径后，在启动一次闪回就修改了，但是这里存在另外一个问题，那就是

之前的闪回是否可用，因为BCD都是在数据库open状态下进行关闭、或打开闪回功能的，这是不是可能会造成历史的闪回数据不可以使用了

这里不知道应该怎样验证

http://docs.oracle.com/cd/E11882_01/server.112/e10803/outage.htm#HABPT004

这里由一个事例是按照A执行的，那就选择A吧今天的文章69.You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area分享到此就结束了，感谢您的阅读。