Oracle 11g将数据库移动到不同的ASM磁盘组/修改ASM磁盘组的冗余属性(二)

2014-11-24 17:34:08 · 作者: · 浏览: 1
---------------------------------- -----------------------------------------


control_file_record_keep_time integer 7


control_files string +DATA/orcl/controlfile/current


.260.833734379,+DATA01/orcl/c


ontrolfile/current.256.833744103


control_management_pack_access string DIAGNOSTIC+TUNING


SQL> alter system setcontrol_files='+DATA01/orcl/controlfile/current.256.833744103' scope=spfile;


System altered.


SQL> shutdown immediate


Database closed.


Database dismounted.


ORACLE instance shut down.


SQL> startup


ORACLE instance started.


Total System Global Area 1653518336 bytes


Fixed Size 2228904 bytes


Variable Size 973081944 bytes


Database Buffers 671088640 bytes


Redo Buffers 7118848 bytes


Database mounted.


Database opened.


SQL> show parameter control;


NAME TYPE VALUE


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


control_file_record_keep_time integer 7


control_files string +DATA01/orcl/controlfile/curre


nt.256.833744103


control_management_pack_access string DIAGNOSTIC+TUNING



数据库启动到mount状态:


RMAN> shutdown immediate


RMAN> startup nomount


RMAN> alter database mount ;


database mounted


released channel: ORA_DISK_1


启用RAMN工具,将数据库镜像备份到新磁盘组:


RMAN>backup as copy database format '+DATA01';


Starting backupat 05-DEC-13


allocatedchannel: ORA_DISK_1


channelORA_DISK_1: SID=13 device type=DISK


channelORA_DISK_1: starting datafile copy


input datafilefile number=00001 name=+DATA/orcl/datafile/system.264.833372265


output filename=+DATA01/orcl/datafile/system.257.833384045 tag=TAG20131205T153405 RECID=3STAMP=833384056


channelORA_DISK_1: datafile copy complete, elapsed time: 00:00:15


channelORA_DISK_1: starting datafile copy


input datafilefile number=00002 name=+DATA/orcl/datafile/sysaux.263.833372265


output filename=+DATA01/orcl/datafile/sysaux.258.833384061 tag=TAG20131205T153405 RECID=4STAMP=833384069


channelORA_DISK_1: datafile copy complete, elapsed time: 00:00:15


channelORA_DISK_1: starting datafile copy


input datafilefile number=00005 name=+DATA/orcl/datafile/example.268.833372347


output filename=+DATA01/orcl/datafile/example.259.833384075 tag=TAG20131205T153405 RECID=5STAMP=833384080


channelORA_DISK_1: datafile copy complete, elapsed time: 00:00:08


channelORA_DISK_1: starting datafile copy


input datafilefile number=00003 name=+DATA/orcl/datafile/undotbs1.267.833372265


output filename=+DATA01/orcl/datafile/undotbs1.260.833384083 tag=TAG20131205T153405RECID=6 STAMP=833384084


channelORA_DISK_1: datafile copy complete, elapsed time: 00:00:03


channelORA_DISK_1: starting datafile copy


copying currentcontrol file


output filename=+DATA01/orcl/controlfile/backup.261.833384087 tag=TAG20131205T153405RECID=7 STAMP=833384086


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


channelORA_DISK_1: starting datafile copy


input datafilefile number=00004 name=+DATA/orcl/datafile/users.269.833372265


output filename=+DATA01/orcl/datafile/users.262.833384087 tag=TAG20131205T153405 RECID=8STAMP=833384087


channelORA_DISK_1: datafile copy complete, elapsed time: 00:00:01


channelORA_DISK_1: starting full datafile backup set


channelORA_DISK_1: specifying datafile(s) in backup set


including currentSPFILE in backup set


channel ORA_DISK_1:starting piece 1 at 05-DEC-13


channelORA_DISK_1: finished piece