html5做手机网站建设,店面设计绘画,阿里云网站空间做商城流程,惠州做网站乐云seoOracle 11g Dataguard Snapshot Standby数据库功能#xff0c;可将备库置于打开读写状态#xff0c;进行模拟生产环境主库中测试。当备库Snapshot standby任务完成后#xff0c;可以切换回物理备库角色。在Snapshot Standby数据库状态下#xff0c;备库是可以接受主库传过来…Oracle 11g Dataguard Snapshot Standby数据库功能可将备库置于打开读写状态进行模拟生产环境主库中测试。当备库Snapshot standby任务完成后可以切换回物理备库角色。在Snapshot Standby数据库状态下备库是可以接受主库传过来的日志但是不能够将变化应用在备库中。1. 采用DG Broker配置Snapshot Standby配置1) 查看配置信息$ dgmgrl sys/oracleDGMGRL for Linux: Version 11.2.0.1.0 - 64bit ProductionCopyright (c) 2000, 2009, Oracle. All rights reserved.Welcome to DGMGRL, type help for information.Connected.DGMGRL show configurationConfiguration - dgfxoptdbProtection Mode: MaxAvailabilityDatabases:fxopt - Primary databasefxopt_std - Physical standby databaseFast-Start Failover: DISABLEDConfiguration Status:SUCCESS2. 转换备库为镜像库(Snapshot Standby)DGMGRL convert database fxopt_std to snapshot standby;Converting database fxopt_std to a Snapshot Standby database, please wait...Database fxopt_std converted successfully这里必须要开启Flashback功能否则会失败报不能创建还原点的错误--开启FLASHBACK功能SQL select name,flashback_on from v$database;SQL show parameter db_recoverySQL alter system set db_recovery_file_dest_size2G;SQL alter system set db_recovery_file_dest/u01/fast_recovery_area;SQL alter system set db_flashback_retention_target 1440;--重启数据库SQL alter database flashback on;SQL alter database open;DGMGRL show configurationConfiguration - dgfxoptdbProtection Mode: MaxAvailabilityDatabases:fxopt - Primary databasefxopt_std - Snapshot standby databaseFast-Start Failover: DISABLEDConfiguration Status:SUCCESSSQL select open_mode,database_role,db_unique_name from v$database;OPEN_MODE DATABASE_ROLE DB_UNIQUE_NAME--------------------- ------------------------ ------------------------READ WRITE SNAPSHOT STANDBY fxopt_std3. 测试镜像库1) 备库上操作SQL select open_mode,database_role,db_unique_name from v$database;OPEN_MODE DATABASE_ROLE DB_UNIQUE_NAME--------------------- ------------------------ ------------------------READ WRITE SNAPSHOT STANDBY fxopt_std现在备库已经是READ WRITE状态数据库角色也是SNAPSHOT STANDBY。SQL conn abc/abcConnected.SQL select * from tab;TNAME TABTYPE CLUSTERID------------------------------------------------------------ -------------- ----------TTTSQL select * from ttt;NAME SCORE---------------------------------------- ----------Evan 100SQL insert into ttt values(Richard, 98);1 row created.SQL commit;Commit complete.SQL create table abc(id number, name varchar2(20), grade number);Table created.SQL insert into abc values(1,Richar,2003);1 row created.SQL commit;Commit complete.SQL select * from tab;TNAME TABTYPE CLUSTERID------------------------------------------------------------ -------------- ----------ABC TABLETTT TABLESQL select * from abc;ID NAME GRADE---------- ---------------------------------------- ----------1 Richar 2003可以在备库做查询和修改操作。2) 主库上查看SQL select open_mode,database_role,db_unique_name from v$database;OPEN_MODE DATABASE_ROLE DB_UNIQUE_NAME-------------------- ---------------- ------------------------------READ WRITE PRIMARY fxopt在主库上插入记录并切换日志。SQL conn abc/abcConnected.SQL select * from ttt;NAME SCORE---------------------------------------- ----------Evan 100SQL insert into ttt values(Lilly, 99);1 row created.SQL commit;Commit complete.SQL select * from ttt;NAME SCORE---------------------------------------- ----------Evan 100Lilly 99SQL conn / as sysdba;SQL archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination /ora_rman/arcOldest online log sequence 50Next log sequence to archive 52Current log sequence 52查看主库规档日志$ ll-rw-r----- 1 oracle oinstall 154624 Mar 7 15:48 ARC_0001_0000000043_0841415433.arc-rw-r----- 1 oracle oinstall 58368 Mar 7 15:50 ARC_0001_0000000044_0841415433.arc-rw-r----- 1 oracle oinstall 11776 Mar 7 15:51 ARC_0001_0000000045_0841415433.arc-rw-r----- 1 oracle oinstall 1559040 Mar 7 16:01 ARC_0001_0000000046_0841415433.arc-rw-r----- 1 oracle oinstall 1024 Mar 7 16:02 ARC_0001_0000000047_0841415433.arc-rw-r----- 1 oracle oinstall 486400 Mar 7 16:02 ARC_0001_0000000048_0841415433.arc-rw-r----- 1 oracle oinstall 58368 Mar 7 16:03 ARC_0001_0000000049_0841415433.arc-rw-r----- 1 oracle oinstall 66048 Mar 7 16:06 ARC_0001_0000000050_0841415433.arc-rw-r----- 1 oracle oinstall 36864 Mar 7 16:07 ARC_0001_0000000051_0841415433.arc主库上切换日志说明52号日志是刚才规档的日志。SQL alter system switch logfile;System altered.SQL archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination /ora_rman/arcOldest online log sequence 51Next log sequence to archive 53Current log sequence 53$ ll-rw-r----- 1 oracle oinstall 154624 Mar 7 15:48 ARC_0001_0000000043_0841415433.arc-rw-r----- 1 oracle oinstall 58368 Mar 7 15:50 ARC_0001_0000000044_0841415433.arc-rw-r----- 1 oracle oinstall 11776 Mar 7 15:51 ARC_0001_0000000045_0841415433.arc-rw-r----- 1 oracle oinstall 1559040 Mar 7 16:01 ARC_0001_0000000046_0841415433.arc-rw-r----- 1 oracle oinstall 1024 Mar 7 16:02 ARC_0001_0000000047_0841415433.arc-rw-r----- 1 oracle oinstall 486400 Mar 7 16:02 ARC_0001_0000000048_0841415433.arc-rw-r----- 1 oracle oinstall 58368 Mar 7 16:03 ARC_0001_0000000049_0841415433.arc-rw-r----- 1 oracle oinstall 66048 Mar 7 16:06 ARC_0001_0000000050_0841415433.arc-rw-r----- 1 oracle oinstall 36864 Mar 7 16:07 ARC_0001_0000000051_0841415433.arc-rw-r----- 1 oracle oinstall 483840 Mar 7 16:17 ARC_0001_0000000052_0841415433.arc查看备库规档日志$ ll-rw-r----- 1 oracle oinstall 154624 Mar 7 15:51 ARC_0001_0000000043_0841415433.arc-rw-r----- 1 oracle oinstall 58368 Mar 7 15:51 ARC_0001_0000000044_0841415433.arc-rw-r----- 1 oracle oinstall 11776 Mar 7 15:51 ARC_0001_0000000045_0841415433.arc-rw-r----- 1 oracle oinstall 1559040 Mar 7 16:01 ARC_0001_0000000046_0841415433.arc-rw-r----- 1 oracle oinstall 1024 Mar 7 16:02 ARC_0001_0000000047_0841415433.arc-rw-r----- 1 oracle oinstall 486400 Mar 7 16:02 ARC_0001_0000000048_0841415433.arc-rw-r----- 1 oracle oinstall 58368 Mar 7 16:07 ARC_0001_0000000049_0841415433.arc-rw-r----- 1 oracle oinstall 66048 Mar 7 16:07 ARC_0001_0000000050_0841415433.arc-rw-r----- 1 oracle oinstall 36864 Mar 7 16:07 ARC_0001_0000000051_0841415433.arc-rw-r----- 1 oracle oinstall 483840 Mar 7 16:17 ARC_0001_0000000052_0841415433.arc发现52号日志经传到备库上只是没有应用。查看备库日志应用情况50,51,52号日志都没有应用。SQL select sequence#,first_time,next_time,applied from v$archived_log order by sequence#;SEQUENCE# FIRST_TIME NEXT_TIME APPLIED---------- ------------ ------------ ------------------43 07-MAR-14 07-MAR-14 YES44 07-MAR-14 07-MAR-14 YES45 07-MAR-14 07-MAR-14 YES46 07-MAR-14 07-MAR-14 YES47 07-MAR-14 07-MAR-14 YES48 07-MAR-14 07-MAR-14 YES49 07-MAR-14 07-MAR-14 YES50 07-MAR-14 07-MAR-14 NO51 07-MAR-14 07-MAR-14 NO52 07-MAR-14 07-MAR-14 NO4. 镜像库(Snapshot Standby)转换备库Snaphost Standyb是通过闪回功能实现。镜像库切换回备库的过程是通过闪回到原还点并应用主库生成日志实现主备一致。1)切换回物理备库DGMGRL show configurationConfiguration - dgfxoptdbProtection Mode: MaxAvailabilityDatabases:fxopt - Primary databasefxopt_std - Snapshot standby databaseFast-Start Failover: DISABLEDConfiguration Status:SUCCESSDGMGRL convert database fxopt_std to physical standby;Converting database fxopt_std to a Snapshot Standby database, please wait...Database fxopt_std converted successfullyDGMGRL convert database fxopt_std to physical standby;Converting database fxopt_std to a Physical Standby database, please wait...Operation requires shutdown of instance fxopt on database fxopt_stdShutting down instance fxopt...Database closed.Database dismounted.ORACLE instance shut down.Operation requires startup of instance fxopt on database fxopt_stdStarting instance fxopt...ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instanceORACLE instance started.Database mounted.Continuing to convert database fxopt_std ...Operation requires shutdown of instance fxopt on database fxopt_stdShutting down instance fxopt...ORA-01109: database not openDatabase dismounted.ORACLE instance shut down.Operation requires startup of instance fxopt on database fxopt_stdStarting instance fxopt...ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instanceORACLE instance started.Database mounted.Database fxopt_std converted successfully2) 转换成功查看结果切换成功DGMGRL show configurationConfiguration - dgfxoptdbProtection Mode: MaxAvailabilityDatabases:fxopt - Primary databasefxopt_std - Physical standby databaseFast-Start Failover: DISABLEDConfiguration Status:SUCCESS打开Active dataguard特性查看验证刚才的50,51,52日志记录已经应用。SQL conn abc/abcConnected.SQL select * from ttt;NAME SCORE---------------------------------------- ----------Evan 100已经还原到与主库记录一致状态。
