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

本文出自 “月牙天冲” 博客