场景: 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博客

RAC数据库COPY到单实例的测试环境