複製 Oracle Control file (SPFile) [ Clone / move oracle Control file ]

因為Database 要使用Control File 啟動數據庫, 所以只能在啟用的狀況下修改。

as database will startup with your server parameter file, you only can modify the control file when database online.

1. 用以下SQL 修改 / 增加 Control File 路徑 (Change or add control file path by following SQL)

alter system set control_files
= 'C:\oracle\db1\CONTROL01.CTL'
, 'C:\oracle\db1\CONTROL02.CTL'
, 'D:\oracle\db1\CONTROL03.CTL'
scope=spfile;

1. 關閉數據庫 ( Shutdown Database)

2. 把Control file由舊有的路徑複製到新的路徑 (Copy the control file from old path to the new path)
   ( C:\oracle\db1\CONTROL01.CTL – > D:\oracle\db1\CONTROL03.CTL )

3. 重新啟動數據庫 ( Startup Database)