Data Guard 快照备库

1、ora19c.oracle.com主机中的 PROD 作为主库， SID 为 PROD， DB_UNIQUE_NAME

设置为 PROD

2、emcc.oracle.com主机中的 SBDB作为备库，SID 为 SBDB， DB_UNIQUE_NAME 设置为 SBDB

3、备库文件路径 /u01/app/oracle/oradata/SBDB

	主库	备库
db_name	PROD	PROD
db_unique_name	PROD	SBDB
net service name	PROD	SBDB
SID/instance_name	PROD	SBDB
Service_name	PROD.oracle.com	SBDB.oracle.com
hostname	ora19c.oracle.com	emcc.oracle.com
ip	192.168.100.191	192.168.100.192

一、查快速恢复区

设置快速恢复区 fast recovery area

alter system set db_recovery_file_dest_size=8G;
alter system set db_recovery_file_dest='/u01/app/oracle/fast_recovery_area';
show parameter db_recovery

二、备库取消日志应用

SYS@SBDB>recover managed standby database cancel;

三、备库关库启动到 mount 状态 

SYS@SBDB>shutdown immediate;
SYS@SBDB>startup mount;
SYS@SBDB>select db_unique_name,database_role,protection_mode,open_mode from v$database;

四、物理备库切 snapshot standby

SYS@SBDB>alter database convert to snapshot standby;
SYS@SBDB>select db_unique_name,database_role,protection_mode,open_mode from v$database;
SYS@SBDB>alter database open;
SYS@SBDB>select db_unique_name,database_role,protection_mode,open_mode from v$database;

 

五、快照备库写测试

主库 scott.emp1 查数据，提交，切日志组

SYS@PROD>insert into scott.emp1 select * from scott.emp1;
SYS@PROD>commit;
SYS@PROD>select count(*) from scott.emp1;
SYS@PROD>alter system switch logfile;

 

备库查看

SYS@SBDB>select count(*) from scott.emp1;

 

查看 FRA 空间

SYS@SBDB> select file_type,number_of_files,percent_space_used from v$recovery_area_usage;

 

六、快照 DG 切回物理 DG

查看当前状态

SYS@SBDB>select db_unique_name,database_role,protection_mode,open_mode from v$database;

关闭备库，启动到 mount 状态

SYS@SBDB>shutdown immediate;
SYS@SBDB>startup mount;
SYS@SBDB>select db_unique_name,database_role,protection_mode,open_mode from v$database;

 

 

切换到物理备库

SYS@SBDB>alter database convert to physical standby;
SYS@SBDB>select db_unique_name,database_role,protection_mode,open_mode from v$database;

 

备库开库，应用日志，查看

SYS@SBDB>alter database open;
SYS@SBDB>recover managed standby database disconnect;
SYS@SBDB>select db_unique_name,database_role,protection_mode,open_mode from v$database;

 查看表中数据，快照 DG 期间备库建的表已不存在，备库已经应用日志与主库同步

SYS@SBDB>select count(*) from scott.emp2;
SYS@SBDB>select count(*) from scott.emp1;