Buddy Yuan的个人技术博客

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。