先备份数据库

[oracle@localhost NACEC]$ pwd

/dat/DBData/oradata/NACEC

[oracle@localhost NACEC]$ mkdir ECOAL

[oracle@localhost NACEC]$ rman target /

RMAN> shutdown immediate;

RMAN> startup mount;

run{

set newname for datafile '/dat/DBData/oradata/NACEC/test1.dbf' to '/dat/DBData/oradata/NACEC/ECOAL/test1.dbf'; 8

set newname for datafile '/dat/DBData/oradata/NACEC/test.dbf' to '/dat/DBData/oradata/NACEC/ECOAL/test.dbf';  7

restore database;

switch datafile all;

recover database;

alter database open;

}

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 20-MAR-14

configuration for DISK channel 2 is ignored

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=157 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to /dat/DBData/oradata/NACEC/system01.dbf

restoring datafile 00002 to /dat/DBData/oradata/NACEC/undotbs01.dbf

restoring datafile 00003 to /dat/DBData/oradata/NACEC/sysaux01.dbf

restoring datafile 00004 to /dat/DBData/oradata/NACEC/users01.dbf

restoring datafile 00005 to /dat/DBData/oradata/NACEC/test_undo.dbf

restoring datafile 00006 to /dat/DBData/oradata/NACEC/tempundotbs.dbf

restoring datafile 00007 to /dat/DBData/oradata/NACEC/ECOAL/test.dbf

restoring datafile 00008 to /dat/DBData/oradata/NACEC/ECOAL/test1.dbf

restoring datafile 00009 to /dat/DBData/oradata/NACEC/catalog.dbf

channel ORA_DISK_1: reading from backup piece /bak/rman/backup_19p3kv10_1_1

channel ORA_DISK_1: restored backup piece 1

piece handle=/bak/rman/backup_19p3kv10_1_1 tag=TAG20140320T093424

channel ORA_DISK_1: restore complete, elapsed time: 00:01:15

Finished restore at 20-MAR-14

datafile 8 switched to datafile copy

input datafile copy recid=37 stamp=842694081 filename=/dat/DBData/oradata/NACEC/ECOAL/test1.dbf

datafile 7 switched to datafile copy

input datafile copy recid=38 stamp=842694081 filename=/dat/DBData/oradata/NACEC/ECOAL/test.dbf

Starting recover at 20-MAR-14

using channel ORA_DISK_1

starting media recovery

media recovery complete, elapsed time: 00:00:03

Finished recover at 20-MAR-14

database opened

SQL> select file_id,file_name from dba_data_files;

   FILE_ID

----------

FILE_NAME

--------------------------------------------------------------------------------

         8

/dat/DBData/oradata/NACEC/ECOAL/test1.dbf

         6

/dat/DBData/oradata/NACEC/tempundotbs.dbf

         5

/dat/DBData/oradata/NACEC/test_undo.dbf

   FILE_ID

----------

FILE_NAME

--------------------------------------------------------------------------------

         4

/dat/DBData/oradata/NACEC/users01.dbf

         3

/dat/DBData/oradata/NACEC/sysaux01.dbf

         2

/dat/DBData/oradata/NACEC/undotbs01.dbf

   FILE_ID

----------

FILE_NAME

--------------------------------------------------------------------------------

         1

/dat/DBData/oradata/NACEC/system01.dbf

         7

/dat/DBData/oradata/NACEC/ECOAL/test.dbf

         9

/dat/DBData/oradata/NACEC/catalog.dbf

9 rows selected.