在單機 Windows 2000 上模擬構建 Oracle 9i Data Guard 物理備庫 (PSTANDBY),主庫 DEMO 已啟用歸檔模式。記錄從參數調整、冷備份、控制文件創建、參數文件修改、目錄結構創建、監聽/TNS 配置到啟動驗證的完整步驟。
SQL> ARCHIVE LOG LIST
Database log mode: Archive Mode
Automatic archival: Enabled
Archive destination: D:\ORACLE\ORADATA\DEMO\ARCHIVE
Oldest online log sequence: 42
Next log sequence to archive: 44
Current log sequence: 44
ALTER SYSTEM SET LOG_ARCHIVE_START=TRUE SCOPE=SPFILE;
STARTUP MOUNT → ALTER DATABASE ARCHIVELOG → ALTER DATABASE OPEN → SHUTDOWN IMMEDIATESQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS 'D:\ORACLE\ORADATA\PSTANDBY\CONTROL01.CTL';
D:\ORACLE\ORADATA\PSTANDBY\initPSTANDBY.ora → 從主庫 initDEMO.ora 複製並修改*.db_name = 'DEMO' # 必須與主庫一致
*.db_unique_name = 'PSTANDBY' # 9i 用 db_name + instance_name 區分
*.control_files = 'D:\ORACLE\ORADATA\PSTANDBY\CONTROL01.CTL'
*.log_archive_dest_1 = 'LOCATION=D:\ORACLE\ORADATA\PSTANDBY\ARCHIVE'
*.log_archive_format = 'ARC%S_%T.%R'
*.fal_server = 'DEMO_TNS' # Fetch Archive Log 服務器
*.fal_client = 'PSTANDBY_TNS'
*.standby_archive_dest = 'D:\ORACLE\ORADATA\PSTANDBY\ARCHIVE'
*.db_file_name_convert = 'DEMO','PSTANDBY'
*.log_file_name_convert = 'DEMO','PSTANDBY'
C:\> oradim -NEW -SID PSTANDBY -INTPWD SYS_PWD -STARTMODE MANUAL -PFILE D:\ORACLE\ADMIN\PSTANDBY\PFILE\INITPSTANDBY.ORA
C:\> net start OracleServicePSTANDBY
listener.ora (備庫端):註冊 SID_NAME=PSTANDBY、GLOBAL_DBNAME=PSTANDBYtnsnames.ora (雙向):DEMO_TNS 指向主庫、PSTANDBY_TNS 指向備庫tnsping DEMO_TNS / tnsping PSTANDBY_TNSSQL> STARTUP NOMOUNT PFILE=...
SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
-- 主庫
SQL> ALTER SYSTEM SWITCH LOGFILE;
-- 備庫
SQL> SELECT SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
註: 本文為 9i 時代單機模擬筆記,生產部署請參考官方 Data Guard Concepts and Administration 並嚴格遵循 MAA 最佳實踐。