实验: 把数据库迁移到ASM(完全恢复)(二)

2014-11-24 18:34:17 · 作者: · 浏览: 1
ut filename=+DATA/test/datafile/sysaux.260.752607043 tag=TAG20110531T172955 recid=3 stamp=752607059


channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25


channel ORA_DISK_1: starting datafile copy


input datafile fno=00005 name=/oradata/test/example01.dbf


output filename=+DATA/test/datafile/example.261.752607067 tag=TAG20110531T172955 recid=4 stamp=752607075


channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15


channel ORA_DISK_1: starting datafile copy


input datafile fno=00002 name=/oradata/test/undotbs01.dbf


output filename=+DATA/test/datafile/undotbs1.262.752607083 tag=TAG20110531T172955 recid=5 stamp=752607084


channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07


channel ORA_DISK_1: starting datafile copy


input datafile fno=00004 name=/oradata/test/users01.dbf


output filename=+DATA/test/datafile/users.263.752607089 tag=TAG20110531T172955 recid=6 stamp=752607089


channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01


channel ORA_DISK_1: starting datafile copy


copying current control file


output filename=+DATA/test/controlfile/backup.264.752607091 tag=TAG20110531T172955 recid=7 stamp=752607091


channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03


channel ORA_DISK_1: starting full datafile backupset


channel ORA_DISK_1: specifying datafile(s) in backupset


including current SPFILE in backupset


channel ORA_DISK_1: starting piece 1 at 2011-05-31 17:31:34


channel ORA_DISK_1: finished piece 1 at 2011-05-31 17:31:35


piece handle=+DATA/test/backupset/2011_05_31/nnsnf0_tag20110531t172955_0.265.752607095 tag=TAG20110531T172955 comment=NONE


channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02


Finished backup at 2011-05-31 17:31:35



RMAN> switch database to copy;


datafile 1 switched to datafile copy "+DATA/test/datafile/system.259.752606999"


datafile 2 switched to datafile copy "+DATA/test/datafile/undotbs1.262.752607083"


datafile 3 switched to datafile copy "+DATA/test/datafile/sysaux.260.752607043"


datafile 4 switched to datafile copy "+DATA/test/datafile/users.263.752607089"


datafile 5 switched to datafile copy "+DATA/test/datafile/example.261.752607067"


2.3 查看ASM数据文件


ASMCMD中看到的结果:


ASMCMD> ls


EXAMPLE.261.752607067


SYSAUX.260.752607043


SYSTEM.259.752606999


UNDOTBS1.262.752607083


USERS.263.752607089