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、能让备库延时使用归档日志
延时测试
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