萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 資料庫 >> Oracle 教學

Oracle 11gR2 物理備用數據庫搭建與主備切換實戰

環境

同一台 Linux 機器,Oracle 11.2.0.1,主庫 orcl (DB_UNIQUE_NAME=prim),備庫 stby。

1. 參數文件配置

主庫關鍵參數

*.db_name='orcl'
*.db_unique_name='prim'
*.log_archive_dest_1='location=/oradata/arch/orcl valid_for=(all_logfiles,all_roles) db_unique_name=prim'
*.log_archive_dest_2='service=stby valid_for=(online_logfiles,primary_role) db_unique_name=stby'
*.fal_client='prim'
*.fal_server='stby'
*.standby_file_management=auto
*.log_archive_config='dg_config=(prim,stby)'

備庫關鍵參數

*.db_name='orcl'  -- 必須與主庫一致
*.db_unique_name='stby'
*.db_file_name_convert='/oradata/orcl','/oradata/stby'
*.log_file_name_convert='/oradata/orcl','/oradata/stby'
*.fal_client='stby'
*.fal_server='prim'
*.log_archive_dest_1='location=/oradata/arch/stby valid_for=(all_logfiles,all_roles) db_unique_name=stby'
*.log_archive_dest_2='service=prim valid_for=(online_logfiles,primary_role) db_unique_name=prim'
*.log_archive_config='dg_config=(prim,stby)'

2. 備份主庫與創建備庫控制文件

RMAN> BACKUP DATABASE FORMAT '/u01/oradata/dbfull%U';
SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/oradata/stby/stbycontrol.ctl';
-- 複製為 control01.ctl、control02.ctl

3. 備庫實例啟動與恢復

export ORACLE_SID=stby
orapwd file=.../orapwstby password=oracle entries=5 ignorecase=y force=y
SQL> STARTUP NOMOUNT
SQL> ALTER DATABASE MOUNT;
RMAN> RESTORE DATABASE;

4. 主庫重啟並配置網絡

修改 tnsnames.ora 同時包含 orcl 與 stby 服務名(同機器用 localhost)。

5. 啟動歸檔應用並驗證

-- 備庫
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
-- 主庫切換日志
ALTER SYSTEM SWITCH LOGFILE;
-- 備庫檢查
SELECT sequence#, applied FROM v$archived_log ORDER BY 1;

6. 主備角色切換

  1. 主庫驗證:SELECT switchover_status FROM v$database; 返回 TO STANDBY
  2. 主庫提交切換:ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;
  3. 主庫重啟到 MOUNT:SHUTDOWN IMMEDIATE; STARTUP MOUNT;
  4. 備庫驗證:SELECT switchover_status FROM v$database; 返回 TO PRIMARY
  5. 備庫提交切換:ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
  6. 新主庫打開:ALTER DATABASE OPEN;(若備庫為只讀模式需先 SHUTDOWN/STARTUP)
  7. 新備庫啟動應用:ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
  8. 新主庫切換日志:ALTER SYSTEM SWITCH LOGFILE;

補充:缺失歸檔處理

ALTER DATABASE REGISTER PHYSICAL LOGFILE 'filespec1';
-- 強制終止 RFS 進程加速故障轉移
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE;
copyright © 萬盛學電腦網 all rights reserved