场景: RAC(10.2.0.2)生产数据库要复制一份到测试环境的单实例.并改变dbname(proddb->uatdb)
步骤:
1.热备RAC其中一个节点.
2.将热备文件移到UAT对应的目录,以下步骤均在UAT上执行
3.sqlplus / as sysdba
alter system set db_name='proddb' scope=spfile;
shutdown immediate
startup mount;
4.用命令alter database rename file将数据文件/在线重做日志文件目录改为UAT下对应的目录
5.检查文件路径是否正确
select name from v$datafile ;
select name from v$tempfile;
select member from v$logfile ;
6.在sqlplus中执行
recover database;
alter database open;
shutdown immediate;
startup mount;
7.变更db name
nid target=/ dbname=uatdb
根据提示输入y
exit
sqlplus / as sysdba
startup nomount;
9.alter system set db_name='uatdb' scope=spfile;
shutdown immediate;
startup mount;
10.改为非归档方式
alter database noarchivelog;
alter database open resetlogs;
archive log list;
shutdown immediate;
startup
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/2073/viewspace-1020506/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/2073/viewspace-1020506/