Oracle 11.2.0.1,先建物理備庫再轉換為邏輯備庫。
-- 生成 LogMiner 字典,會觸發數次日志切換,報錯可忽略
EXECUTE dbms_logstdby.build;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
ALTER DATABASE RECOVER TO LOGICAL STANDBY orcl; -- orcl 為 db_name
SHUTDOWN IMMEDIATE
STARTUP MOUNT
SELECT db_unique_name, open_mode, database_role, switchover_status, guard_status, protection_mode FROM v$database;
orapwd file=$ORACLE_HOME/dbs/orapwstby password=oracle entries=5 ignorecase=y force=y
ALTER SYSTEM SET log_archive_dest_1='location=/u01/oradata/arch/stby valid_for=(online_logfiles,all_roles) db_unique_name=stby';
ALTER SYSTEM SET log_archive_dest_2='location=/u01/oradata/arch valid_for=(standby_logfiles,standby_roles) db_unique_name=stby';
ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 ('/u01/oradata/stby/standbylj01.log') SIZE 20M REUSE;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 ('/u01/oradata/stby/standbylj02.log') SIZE 20M REUSE;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 ('/u01/oradata/stby/standbylj03.log') SIZE 20M REUSE;
ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;
-- 主庫建表測試
CREATE TABLE scott.t4 (id INT);
INSERT INTO scott.t4 VALUES(4);
COMMIT;
ALTER SYSTEM SWITCH LOGFILE;
-- 稍後備庫查詢
SELECT * FROM scott.t4;
ignorecase=y 否則歸檔傳輸失敗guard_status 為 ALL