Dataguard实战(16)：RHEL4.5 安装 Oracle10G Dataguard 多个备库 - 快照备库的利用（主机vmtwo）

十六、快照备库的利用（主机vmtwo）

可以利用快照备库（和生产库一样的环境），做一些测试，然后回到测试前的状态，可完成无数次的测试。

16.1 设置闪回区和大小
SQL> alter system set db_recovery_file_dest='/orahome/flash_recovery_area';
SQL> alter system set db_recovery_file_dest_size=3G;

16.2 取消备库的自动恢复
SQL> recover managed standby database cancel;

16.3 创建一个还原点
SQL> create restore point restore_point_test guarantee flashback database;

16.4 主库归档前，确保刚才创建还原点的scn的归档日志已经传到备库了（主机vmone）
SQL> alter system archive log current;

16.5 disable主库到备库的归档目的地（主机vmone）
SQL> alter system set log_archive_dest_state_2=defer;

16.6 激活备库到读写状态
SQL> alter database activate standby database;
SQL> alter database open;
SQL> select name,database_role,db_unique_name,open_mode,protection_mode,protection_level,switchover_status,supplemental_log_data_pk,supplemental_log_data_ui from v$database;
NAME DATABASE_ROLE DB_UNIQUE_NAME OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL SWITCHOVER_STATUS SUP SUP
-------- ---------------- ------------------------------ ---------- -------------------- -------------------- -------------------- --- ---
ORCLDB PRIMARY PHYSTDBY READ WRITE MAXIMUM AVAILABILITY RESYNCHRONIZATION SESSIONS ACTIVE NO NO

16.7 测试，读写。。。。
SQL> create table u_test.t_test999 as select * from dba_users;
SQL> select count(*) from u_test.t_test999;
COUNT(*)
----------
10
SQL> select table_name from dba_tables where owner='U_TEST';
TABLE_NAME
------------------------------
T_TEST
T_TEST1
T_TEST3
T_TEST2
T_TEST4
TS_TEST5
T_TEST999

16.8 测试完后将库闪回到保存的还原点
SQL> startup mount force;
SQL> flashback database to restore point restore_point_test;
SQL> alter database convert to physical standby;

16.9 将备库转为自动恢复
SQL> startup mount force
SQL> recover managed standby database disconnect;
SQL> select name,database_role,db_unique_name,open_mode,protection_mode,protection_level,switchover_status,supplemental_log_data_pk,supplemental_log_data_ui from v$database;
NAME DATABASE_ROLE DB_UNIQUE_NAME OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL SWITCHOVER_STATUS SUP SUP
-------- ---------------- ------------------------------ ---------- -------------------- -------------------- -------------------- --- ---
ORCLDB PHYSICAL STANDBY PHYSTDBY MOUNTED MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY NOT ALLOWED NO NO

16.10 enable主库到备库的归档目的地（主机vmone）
SQL> alter system set log_archive_dest_state_2=enable;
SQL> alter system archive log current;

--End--

from:http://hi.baidu.com/edeed/blog/item/b1be513d4fa543e93d6d971a.html