oracle 10g rac轉成單機

遇到一個case，需要把10g的rac搞成單機，騰出一臺主機做別的用，環境是hpux加asm，改成檔案系統。
exp或者expdp肯定可以，但感覺麻煩並且時間長。資料庫是沒有歸檔的。可以停。最後考慮
用rman，在rman backup和rman copy直接選擇copy。

把rac停下來，只啟動一個節點到mount狀態，建立pfile檔案，
create pfile='1.ora' from spfile;
建立控制檔案的trace，copy控制檔案
copy current controlfile to '/oradata/test/control1.ora';

alter database backup controlfile to trace  ;

將來恢復可以使用控制檔案copy，也可以用trace檔案去重建控制檔案，考慮到除了資料檔案位置變化，日誌檔案的檔案變化，簡單的辦法是重建控制檔案。兩個都在，保險下。
copy資料檔案
copy datafile   1   to '/oradata/kyjxc/system.dat';                                                                                                                                                                                                                                                                                                                                                                                                                                          
copy datafile   2   to '/oradata/kyjxc/undotbs1.dat';                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
copy datafile   3   to '/oradata/kyjxc/sysaux.dat';                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
copy datafile   4   to '/oradata/kyjxc/users.dat';                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
copy datafile   5   to '/oradata/kyjxc/undotbs2.dat';    
關閉資料庫。