Oracle 11.2.0.4.0 Dataguard部署和日常維護(6)-Active dataguard

標籤：log   system   role   can   name   prot   protect   apply   stand   

1. 檢查主備庫的狀態

• on primary

column DATABASE_ROLE format a20column OPEN_MODE format a15column PROTECTION_MODE format a20column SWITCHOVER_STATUS format a20select DATABASE_ROLE,OPEN_MODE,PROTECTION_MODE,SWITCHOVER_STATUS from v$database;DATABASE_ROLE         OPEN_MODE         PROTECTION_MODE      SWITCHOVER_STATUS-------------------- --------------- -------------------- --------------------PRIMARY          READ WRITE      MAXIMUM PERFORMANCE  TO STANDBYselect max(sequence#) from v$archived_log;MAX(SEQUENCE#)--------------        68

• on standby

column DATABASE_ROLE format a20column OPEN_MODE format a15column PROTECTION_MODE format a20column SWITCHOVER_STATUS format a20select DATABASE_ROLE,OPEN_MODE,PROTECTION_MODE,SWITCHOVER_STATUS from v$database;DATABASE_ROLE        OPEN_MODE       PROTECTION_MODE      SWITCHOVER_STATUS-------------------- --------------- -------------------- --------------------PHYSICAL STANDBY     MOUNTED         MAXIMUM PERFORMANCE  NOT ALLOWEDselect SEQUENCE#,APPLIED from v$archived_log where SEQUENCE#=(select max(sequence#) from v$archived_log); SEQUENCE# APPLIED---------- ---------------------------    68 　　IN-MEMORYselect process,status,sequence# from v$managed_standby;PROCESS             STATUS                  SEQUENCE#------------------- ----------------------- ----------ARCH                CLOSING                     68ARCH                CONNECTED                    0ARCH                CONNECTED                    0ARCH                CLOSING                     65RFS                 IDLE                         0RFS                 IDLE                        69RFS                 IDLE                         0MRP0                APPLYING_LOG                69

2. 取消備庫的MPR恢複線程

alter database recover managed standby database cancel;

3. 備庫以readonly方式開啟

alter database open read only;select DATABASE_ROLE,OPEN_MODE,PROTECTION_MODE,SWITCHOVER_STATUS from v$database;DATABASE_ROLE        OPEN_MODE       PROTECTION_MODE      SWITCHOVER_STATUS-------------------- --------------- -------------------- --------------------PHYSICAL STANDBY     READ ONLY       MAXIMUM PERFORMANCE  NOT ALLOWEDselect process,status,sequence# from v$managed_standby;PROCESS             STATUS                  SEQUENCE#------------------- ----------------------- ----------ARCH                CLOSING                     68ARCH                CONNECTED                    0ARCH                CONNECTED                    0ARCH                CLOSING                     65RFS                 IDLE                         0RFS                 IDLE                        69RFS                 IDLE                         0

4. 開啟備庫的MPR線程

alter database recover managed standby database using current logfile disconnect from session;
select process,status,sequence# from v$managed_standby;PROCESS             STATUS                  SEQUENCE#------------------- ----------------------- ----------ARCH                CLOSING                     68ARCH                CONNECTED                    0ARCH                CONNECTED                    0ARCH                CLOSING                     65RFS                 IDLE                         0RFS                 IDLE                        69RFS                 IDLE                         0MRP0                APPLYING_LOG                69

5. 測試active dataguard

• on primary

create table test01 as select FILE_NAME from dba_data_files;select * from test01;FILE_NAME------------------------------------------------------------/u01/app/oracle/oradata/userdata/users01.dbf/u01/app/oracle/oradata/userdata/undotbs01.dbf/u01/app/oracle/oradata/userdata/sysaux01.dbf/u01/app/oracle/oradata/userdata/system01.dbf

• on standby

select * from test01;FILE_NAME------------------------------------------------------------/u01/app/oracle/oradata/userdata/users01.dbf/u01/app/oracle/oradata/userdata/undotbs01.dbf/u01/app/oracle/oradata/userdata/sysaux01.dbf/u01/app/oracle/oradata/userdata/system01.dbf

Oracle 11.2.0.4.0 Dataguard部署和日常維護(6)-Active dataguard