alter database open;

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

READ ONLY WITH APPLY

DGMGRL> show database verbose standby;

Database - standby

  Role:            PHYSICAL STANDBY

  Intended State:  APPLY-ON

  Transport Lag:   0 seconds

  Apply Lag:       0 seconds

  Real Time Query: ON

  Instance(s):

    standby

alter database enable block change tracking using file '/home/oracle/blk_chg.tra';

SQL> select status from v$block_change_tracking;

STATUS

----------

ENABLED

SQL> select filename from v$block_change_tracking;

FILENAME

--------------------------------------------------------------------------------

/home/oracle/blk_chg.tra

将standby转换成快照数据库，可以用来测试用

DGMGRL> CONVERT DATABASE standby to SNAPSHOT STANDBY;

GMGRL> show configuration;

Configuration - c1

  Protection Mode: MaxPerformance

  Databases:

    woods   - Primary database

    standby - Snapshot standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

CONVERT DATABASE standby to PHYSICAL STANDBY;

DGMGRL> SWITCHOVER TO standby;

DGMGRL> show configuration;

Configuration - c1

  Protection Mode: MaxPerformance

  Databases:

    standby - Primary database

    woods   - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

SWITCHOVER TO woods;

rman target /

CONFIGURE ARCHIVELOG DELETION POLICY TO shipped to standby;

会有这个报错：RMAN-08591: WARNING: invalid archived log deletion policy

alter system set "_log_deletion_policy"=ALL scope=spfile ;

重启一下主库，再重新配置rman参数，就不会报错了

（1）主备库都启动快速闪回

alter database flashback on;

（备库在应用日志，启动不了，可以先取消日志应用，启动闪回后再开启日志应用：

alter database recover managed standby database cancel;

alter database flashback on;

alter database recover managed standby database using current logfile disconnect from session;）

（2）EDIT DATABASE woods SET PROPERTY FastStartFailoverTarget='standby';

（3）sta端

     [oracle@sta ~]$ dgmgrl sys/oracle

     DGMGRL> start observer;

（4）DGMGRL> EDIT DATABASE woods SET PROPERTY FastStartFailoverTarget='standby';

DGMGRL> EDIT DATABASE woods SET PROPERTY LogXptMode='SYNC';

DGMGRL> EDIT DATABASE standby SET PROPERTY LogXptMode='SYNC';

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MaxAvailability;

（5）启动

DGMGRL> ENABLE FAST_START FAILOVER;

Enabled.

DGMGRL> show configuration;

Configuration - c1

  Protection Mode: MaxAvailability

  Databases:

    woods   - Primary database

    standby - (*) Physical standby database

Fast-Start Failover: ENABLED

Configuration Status:

SUCCESS