ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 10g rac转成单机

oracle 10g rac转成单机

原创 Linux操作系统 作者:tonglei2000 时间:2012-07-30 09:12:37 0 删除 编辑
  
遇到一个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博客 ” ,链接:https://blog.itpub.net/13337857/viewspace-738555/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-10-19

  • 博文量
    109
  • 访问量
    234780