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

0

因為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)

Share.

About Author

hahahahahaha......nothing here

發表迴響

error: Content is protected !!