Oracle DB使用RMAN将数据库移植到ASM存储区(三)
e users;
7> sql 'alter tablespace users online';
8> }
sql statement: alter tablespace users offline immediate
executing command: SET NEWNAME
Starting restore at 24-OCT-13
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to +DATA
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/TEST0924/backupset/2013_10_24/o1_mf_nnndf_TAG20131024T101748_96lc0dxh_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/TEST0924/backupset/2013_10_24/o1_mf_nnndf_TAG20131024T101748_96lc0dxh_.bkp tag=TAG20131024T101748
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 24-OCT-13
datafile 4 switched to datafile copy
input datafile copy RECID=6 STAMP=829650049 file name=+DATA/test0924/datafile/users.260.829650045
Starting recover at 24-OCT-13
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 24-OCT-13
sql statement: alter tablespace users online
sys@TEST0924>
select file_name from dba_data_files;
FILE_NAME
----------------------------------------------------------------------------------------------------
+DATA/test0924/datafile/users.260.829650045
/u01/app/oracle/oradata/test0924/sysaux01.dbf
/u01/app/oracle/oradata/test0924/system01.dbf
/u01/app/oracle/oradata/test0924/example01.dbf
/u01/app/oracle/oradata/test0924/undotbs02.dbf
/u01/app/oracle/oradata/test0924/undotbs01.dbf
/u01/app/oracle/oradata/test0924/inventory01.dbf
7 rows selected.