| 角色 | IP | SID | DB_UNIQUE_NAME | 備註 |
|---|---|---|---|---|
| Primary | 192.168.1.11 | test | test | |
| Physical Standby | 192.168.1.12 | dgtest | dgtest | 既有 |
| Logical Standby (目標) | 192.168.1.15 | logicdg | logicdg | 由 Physical 轉換 |
DBMS_LOGSTDBY.SKIP 排除不支援物件)*.log_archive_config = 'dg_config=(test,dgtest,logicdg)'
*.log_archive_dest_2 = 'service=test12 arch valid_for=(online_logfiles,primary_role) db_unique_name=dgtest'
*.log_archive_dest_3 = 'service=test15 arch valid_for=(online_logfiles,primary_role) db_unique_name=logicdg'
*.log_archive_dest_state_2 = defer
*.log_archive_dest_state_3 = defer
*.fal_server = test11
*.fal_client = test12
*.standby_file_management = auto
*.db_file_name_convert = '/oracle/oradata/test','/oracle/oradata/dgtest/dgtest','/oracle/oradata/test','/oracle/oradata/logicdg'
*.log_file_name_convert = '/oracle/oradata/test','/oracle/oradata/dgtest/dgtest','/oracle/oradata/test','/oracle/oradata/logicdg'
-- Physical
SELECT sequence#, applied FROM v$archived_log;
-- Logical (現為 Physical)
SELECT sequence#, applied FROM v$archived_log;
確認 APPLIED = YES 且序號連續。
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
EXEC DBMS_LOGSTDBY.BUILD;
ALTER DATABASE RECOVER TO LOGICAL STANDBY logicdg;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM SET log_archive_dest_1 = 'location=/oracle/oradata/logicdg/local-archive valid_for=(online_logfiles,all_roles) db_unique_name=logicdg';
ALTER SYSTEM SET log_archive_dest_5 = 'location=/oracle/oradata/logicdg/archive valid_for=(standby_logfiles,standby_role) db_unique_name=logicdg';
ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 11 '/oracle/oradata/logicdg/standbyredo11.log' SIZE 100M;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 12 '/oracle/oradata/logicdg/standbyredo12.log' SIZE 100M;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 13 '/oracle/oradata/logicdg/standbyredo13.log' SIZE 100M;
ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;
SELECT * FROM v$logstdby_progress;
SELECT * FROM v$logstdby_state;
確認 APPLIED_SCN 持續推進。
DBA_LOGSTDBY_EVENTS 排查應用錯誤