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