DG之物理Standby的failover

1.檢查歸檔文件是否連續 ORCLPRE: ORCLPRE_STD startup ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 1218316 bytes Variable Size 75499764 bytes Database Buffers 88080384 bytes Redo Buffers 2973696 bytes Database

1.檢查歸檔文件是否連續
ORCLPRE:
ORCLPRE_STD >startup
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 75499764 bytes
Database Buffers 88080384 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
ORCLPRE_STD >select thread#,low_sequence#,high_sequence# from v$archive_gap;

no rows selected
若有記錄，把列出的記錄號對應的歸檔轉換到待轉換的Standby，不然數據會不一致。并加入數據字典（Alter database register physical logfile 'filespecl'）
2.檢查歸檔文件是否完整
ORCLPRE_STD >select distinct thread#,max(sequence#) over(partition by thread#) A from v$archived_log;

THREAD# A
---------- ----------
1 39
ORCLPDG:
ORCLPDG_PRI >startup
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 62916852 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
ORCLPDG_PRI >select distinct thread#,max(sequence#) over(partition by thread#) A from v$archived_log;

THREAD# A
---------- ----------
1 39
若最大序號不同，需要復制到待轉換的Standby。
3.啟動failover

ORCLPRE_STD >alter database recover managed standby database finish force;//force停止當前活動的RFS進程（RFS是REDO傳輸服務）。

Database altered.
4.切換物理Standby為Primary
ORCLPRE_STD >alter database commit to switchover to primary;

Database altered.

5.啟動新的Primary
ORCLPRE_STD >select status from v$instance;

STATUS
------------
STARTED

ORCLPRE_STD >alter database open;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted

ORCLPRE_STD >shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
ORCLPRE_STD >startup
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 75499764 bytes
Database Buffers 88080384 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
ORCLPRE_STD >select * from scott.test;

ID
----------
1
2
3
4
5
6

6 rows selected.

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com