DG备库delay设置备库延时apply archivelog 但不延时传送归archivelog

alter database recover managed standby database delay 120 disconnect from session;   
延时测试

1，在备库上运行：
alter database recover managed standby database delay 120 disconnect from session;   

2，在主库上：
alter system switch logfile ;

可以看到
sys@R2>  select process,status,sequence# from v$managed_standby ;
PROCESS        STATUS            SEQUENCE#
------------------ ------------------------ ---------
ARCH           CLOSING              171
ARCH           CLOSING              170
ARCH           CLOSING              166
ARCH           CLOSING              171
LGWR           WRITING              172

sys@R2>
sys@R2>
sys@R2> alter system switch logfile ;
System altered.
sys@R2> alter system switch logfile ;
System altered.
sys@R2> alter system switch logfile ;
System altered.
sys@R2> alter system switch logfile ;
System altered.
sys@R2> alter system switch logfile ;
System altered.
sys@R2> select process,status,sequence# from v$managed_standby ;
PROCESS        STATUS            SEQUENCE#
------------------ ------------------------ ---------
ARCH           CLOSING              176
ARCH           CLOSING              170
ARCH           CLOSING              174
ARCH           CLOSING              175
LGWR           WRITING              177

sys@R2> select count(1) from a ;

  COUNT(1)
----------
     4
sys@R2> truncate table a ;
sys@R2> alter system switch logfile ;
System altered.
sys@R2> /
System altered.
sys@R2> /
System altered.
sys@R2> /
System altered.

3，备库上：：
SQL>  select process,status,sequence# from v$managed_standby ;

PROCESS        STATUS             SEQUENCE#
------------------ ------------------------ ----------
ARCH           CLOSING               174
ARCH           CLOSING               175
ARCH           CONNECTED                 0
ARCH           CLOSING               176
RFS           IDLE                  0
RFS           IDLE                177
RFS           IDLE                  0
MRP0           WAIT_FOR_LOG            170

SQL> host
[oracle@node1 ~]$ cd /u01/archivelog/
[oracle@node1 archivelog]$ ll
-rw-r----- 1 oracle oinstall  3360768 Aug 16 17:34 1_160_918985159.dbf
-rw-r----- 1 oracle oinstall   262144 Aug 16 17:34 1_161_918985159.dbf
-rw-r----- 1 oracle oinstall   774656 Aug 16 17:34 1_162_918985159.dbf
-rw-r----- 1 oracle oinstall 16742400 Aug 17 10:05 1_167_918985159.dbf
-rw-r----- 1 oracle oinstall   493056 Aug 17 10:17 1_168_918985159.dbf
-rw-r----- 1 oracle oinstall   305152 Aug 17 10:17 1_169_918985159.dbf
-rw-r----- 1 oracle oinstall 33174528 Aug 17 10:35 1_170_918985159.dbf
-rw-r----- 1 oracle oinstall    37888 Aug 17 10:35 1_171_918985159.dbf
-rw-r----- 1 oracle oinstall   295424 Aug 17 10:39 1_172_918985159.dbf
-rw-r----- 1 oracle oinstall     3584 Aug 17 10:39 1_173_918985159.dbf
-rw-r----- 1 oracle oinstall     8704 Aug 17 10:39 1_174_918985159.dbf
-rw-r----- 1 oracle oinstall     1536 Aug 17 10:39 1_175_918985159.dbf
-rw-r----- 1 oracle oinstall     3584 Aug 17 10:39 1_176_918985159.dbf
-rw-r----- 1 oracle oinstall    63488 Aug 17 10:40 1_177_918985159.dbf
-rw-r----- 1 oracle oinstall     1536 Aug 17 10:40 1_178_918985159.dbf
-rw-r----- 1 oracle oinstall     3584 Aug 17 10:40 1_179_918985159.dbf
-rw-r----- 1 oracle oinstall     1024 Aug 17 10:40 1_180_918985159.dbf

SQL> select * from a ;

A              B
------------ ----------
10-AUG-16          1
10-AUG-16          1
10-AUG-16          2
10-AUG-16          3

SQL> archive log list ;
Database log mode           Archive Mode
Automatic archival           Enabled
Archive destination           /u01/archivelog
Oldest online log sequence     179
Next log sequence to archive   0
Current log sequence           183

日志传送过来，当并没有运行

4，此时主库的DG状态是正常：
sys@R2> select switchover_status from v$database ;

SWITCHOVER_STATUS
----------------------------------------
TO STANDBY



5，在备库上：
alter database recover managed standby database using current logfile disconnect from session;

SQL> alter database recover managed standby database  disconnect from session
  2  /
alter database recover managed standby database  disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active


SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> host
[oracle@node1 ~]$ ll 01153
ls: 01153: No such file or directory
[oracle@node1 ~]$ oerr ora 01153
01153, 00000, "an incompatible media recovery is active"
// *Cause: Attempted to start an incompatible media recovery or open resetlogs
//         during media recovery or RMAN backup . Media recovery sessions
//         are incompatible if they attempt to recover the same data file.
//         Incomplete media recovery or open resetlogs is incompatible with
//         any media recovery. Backup or restore by RMAN is incompatible
//         with open resetlogs
// *Action: Complete or cancel the other media recovery session or RMAN backup
[oracle@node1 ~]$
[oracle@node1 ~]$


SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 17 10:51:06 2016

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

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

Database altered.

SQL> select process,status ,sequence# from v$managed_standby ;

PROCESS        STATUS             SEQUENCE#
------------------ ------------------------ ----------
ARCH           CONNECTED                 0
ARCH           CLOSING               181
ARCH           CONNECTED                 0
ARCH           CLOSING               182
RFS           IDLE                  0
RFS           IDLE                183
RFS           IDLE                  0
MRP0           APPLYING_LOG            183

8 rows selected.

SQL>  select * from a ;

no rows selected


小结：
alter database recover managed standby database delay 120 disconnect from session;   
1、能让备库延时使用归档日志

2、主库的switchover_status 显示是正常

3、并不延时传送archivelog