12c考试还需要把Physical Standby转换成Snapshot模式。选择AVAILABILITY ->DATA Guard Administration,然后在Standby Database中选择Convert。
当然我们还可以通过DGMGRL来转换成snapshot standby;
[oracle@host01 ~]$ dgmgrl sys/oracle DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production Copyright (c) 2000, 2013, Oracle. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected as SYSDG. DGMGRL> show configuration Configuration - PROD5 Protection Mode: MaxPerformance Members: PROD5T1 - Primary database PROD5T2 - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated 42 seconds ago) DGMGRL> convert database "PROD5T2" to snapshot standby; Converting database "PROD5T2" to a Snapshot Standby database, please wait... Database "PROD5T2" converted successfully DGMGRL> show configuration Configuration - PROD5 Protection Mode: MaxPerformance Members: PROD5T1 - Primary database PROD5T2 - Snapshot standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated 33 seconds ago) DGMGRL> convert database "PROD5T2" to physical standby; Converting database "PROD5T2" to a Physical Standby database, please wait... Operation requires shut down of instance "PROD5" on database "PROD5T2" Shutting down instance "PROD5"... Database closed. Database dismounted. ORACLE instance shut down. Operation requires start up of instance "PROD5" on database "PROD5T2" Starting instance "PROD5"... ORACLE instance started. Database mounted. Continuing to convert database "PROD5T2" ... Database "PROD5T2" converted successfully
转换成Snapshot Standby之后,可以做一些操作,然后在转换回来。而在转换成Snapshot Standby的时候,Real-time Query是N/A的,也就是无法设置的,必须把它转换成Physical Standby才能开Real-time Query。
Post a Comment