主庫重命名資料檔(ALTER TABLESPACE ... RENAME DATAFILE)不會自動傳播至備庫,即使 STANDBY_FILE_MANAGEMENT=AUTO 也無效。必須在備庫手動完成同步操作。
ALTER TABLESPACE tbs_4 OFFLINE;mv /disk1/oracle/oradata/payroll/tbs_4.dbf /disk1/oracle/oradata/payroll/tbs_x.dbfALTER TABLESPACE tbs_4 RENAME DATAFILE '/disk1/oracle/oradata/payroll/tbs_4.dbf' TO '/disk1/oracle/oradata/payroll/tbs_x.dbf';
ALTER TABLESPACE tbs_4 ONLINE;SELECT SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;SHUTDOWN IMMEDIATE;mv /disk1/oracle/oradata/payroll/tbs_4.dbf /disk1/oracle/oradata/payroll/tbs_x.dbfSTARTUP MOUNT;STANDBY_FILE_MANAGEMENT=MANUAL):ALTER DATABASE RENAME FILE '/disk1/oracle/oradata/payroll/tbs_4.dbf' TO '/disk1/oracle/oradata/payroll/tbs_x.dbf';ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;若跳過備庫操作,後續 Redo Apply 會嘗試存取新路徑檔案而失敗,Alert Log 出現:
ORA-00283: recovery session canceled due to errors
ORA-01157: cannot identify/lock datafile 4
ORA-01110: datafile 4: '/Disk1/oracle/oradata/payroll/tbs_x.dbf'
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;DBMS_FILE_TRANSFER 或 ASM 搬移替代 OS mv,確保權限一致。SELECT FILE_NAME FROM DBA_DATA_FILES WHERE TABLESPACE_NAME='TBS_4'; 雙端對比驗證。Data Guard 架構下主庫結構變更(重命名、新增/刪除資料檔)均需備庫手動跟進,將此流程固化為標準作業程序(SOP)是保障備庫可用性的關鍵。