Database altered
SQL> alter database rename file '/u01/app/oradata/orcl/users01.dbf' to '/u01/app/oradata/orcl2/users01.dbf';
Database altered.
SQL> alter database rename file '/u01/app/oradata/orcl/example01.dbf' to '/u01/app/oradata/orcl2/example01.dbf';
Database altered.
SQL> alter database rename file '/u01/app/oradata/orcl/rman01.dbf' to '/u01/app/oradata/orcl2/rman01.dbf';
Database altered.
SQL> alter database rename file '/u01/app/oradata/orcl/sjb01.dbf' to '/u01/app/oradata/orcl2/sjb01.dbf';
Database altered.
SQL> alter database rename file '/u01/app/oradata/orcl/sjb02.dbf' to '/u01/app/oradata/orcl2/sjb02.dbf';
Database altered
SQL> alter database rename file '/u01/app/oradata/orcl/t_drop01.dbf' to '/u01/app/oradata/orcl2/t_drop01.dbf';
Database altered.
SQL> alter database rename file '/u01/app/oradata/orcl/undotbs201.dbf' to '/u01/app/oradata/orcl2/undotbs201.dbf';
Database altered
SQL> alter database rename file '/u01/app/oradata/orcl/temp01.dbf' to '/u01/app/oradata/orcl2/temp01.dbf';
Database altered.
SQL> alter database rename file '/u01/app/oradata/orcl/redo01_a.log' to '/u01/app/oradata/orcl2/redo01_a.log';
Database altered.
SQL> alter database rename file '/u01/app/oradata/orcl/redo01_b.log' to '/u01/app/oradata/orcl2/redo01_b.log';
Database altered.
SQL> alter database rename file '/u01/app/oradata/orcl/redo02_a.log' to '/u01/app/oradata/orcl2/redo02_a.log';
Database altered.
SQL> alter database rename file '/u01/app/oradata/orcl/redo02_b.log' to '/u01/app/oradata/orcl2/redo02_b.log';
Database altered.
SQL> alter database rename file '/u01/app/oradata/orcl/redo03_a.log' to '/u01/app/oradata/orcl2/redo03_a.log';
Database altered.
SQL> alter database rename file '/u01/app/oradata/orcl/redo03_b.log' to '/u01/app/oradata/orcl2/redo03_b.log';
Database altered.
2.5 打开数据库并验证
SQL> alter database open resetlogs;
Database altered.
SQL> select name,dbid from v$database;
NAME DBID
--------------------------- ----------
ORCL2 737391906
总结：数据库更名后，原来所有的备份信息和归档全部无效，数据库需要以resetlogs方式打开，意味着数据库需要换化身，如果方法一更改数据库名，需要注意临时文件的添加，同时可以使用emca命令重新配置dbconsole
本文出自 “月牙天冲” 博客