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吧
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吧