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';    
关闭数据库。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13337857/viewspace-738555/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13337857/viewspace-738555/