恢複缺少一個控制檔案

缺少一個copy的控制檔案
1)執行shutdown abort
2)複製一個好的copy到一個新目錄
3）sql>startup nomount
     sql>select name ,value from v$spparameter
            where name = 'control_files';
NAME VALUE
--------------- --------------------------------------------------
control_files /u02/oradata/ord/control01.ctl
control_files /u06/oradata/ord/control02.ctl
control_files /u07/oradata/ord/control03.ctl

4)修改參數
SQL>alter system set control_file =
   '/u02/oradata/ord/control01.ctl',
    '/u06/oradata/ord/control02.ctl'
     scope = spfile;

5)sql>shutdown immediate

6）sql>startup
   sql>select name ,value from v$spparameter
            where name = 'control_files';