同一台 Linux 機器,Oracle 11.2.0.1,主庫 orcl (DB_UNIQUE_NAME=prim),備庫 stby。
*.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)'
RMAN> BACKUP DATABASE FORMAT '/u01/oradata/dbfull%U';
SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/oradata/stby/stbycontrol.ctl';
-- 複製為 control01.ctl、control02.ctl
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;
修改 tnsnames.ora 同時包含 orcl 與 stby 服務名(同機器用 localhost)。
-- 備庫
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
-- 主庫切換日志
ALTER SYSTEM SWITCH LOGFILE;
-- 備庫檢查
SELECT sequence#, applied FROM v$archived_log ORDER BY 1;
SELECT switchover_status FROM v$database; 返回 TO STANDBYALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;SHUTDOWN IMMEDIATE; STARTUP MOUNT;SELECT switchover_status FROM v$database; 返回 TO PRIMARYALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;ALTER DATABASE OPEN;(若備庫為只讀模式需先 SHUTDOWN/STARTUP)ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;ALTER SYSTEM SWITCH LOGFILE;ALTER DATABASE REGISTER PHYSICAL LOGFILE 'filespec1';
-- 強制終止 RFS 進程加速故障轉移
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE;