OS: RH Linux
DB: Oracle 11.2.0.4
已完成源库RMAN全备,传至实验机。
备份集位置改变,恢复到新位置。实验机原有spfile文件。
$ rman target /
--启动到nomount状态
RMAN> startup nomount;
connected to target database (not started)
Oracle instance startedTotal System Global Area 68412682240 bytes
Fixed Size 2270360 bytes
Variable Size 6845107048 bytes
Database Buffers 61203283968 bytes
Redo Buffers 362020864 bytes
(如果不成功,startup force nomount;)
--恢复控制文件
RMAN> restore controlfile from '/data/u01/oracle/backups05/rmanbak/20170614/ctl_ORCL_20170614_3262_1';
Starting restore at 14-6月 -17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=529 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/oradata/orcl/control01.ctl
output file name=/oradata/orcl/control02.ctl
Finished restore at 14-6月 -17
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
--因为备份集更改了位置,所以删除控制文件中记录的旧信息,注册现在的备份集
RMAN> crosscheck backup;RMAN> delete noprompt expired backup;
RMAN> CATALOG START WITH '/data/u01/oracle/backups05/rmanbak/20170614/';
searching for all files that match the pattern /data/u01/oracle/backups05/rmanbak/20170614/
List of Files Unknown to the Database
=====================================
File Name: /data/u01/oracle/backups05/rmanbak/20170614/arch_ORCL_20170614_3255_1
File Name: /data/u01/oracle/backups05/rmanbak/20170614/arch_ORCL_20170614_3256_1
File Name: /data/u01/oracle/backups05/rmanbak/20170614/arch_ORCL_20170614_3254_1
File Name: /data/u01/oracle/backups05/rmanbak/20170614/full_ORCL_20170614_3245_1
File Name: /data/u01/oracle/backups05/rmanbak/20170614/arch_ORCL_20170614_3257_1
File Name: /data/u01/oracle/backups05/rmanbak/20170614/arch_ORCL_20170614_3259_1
File Name: /data/u01/oracle/backups05/rmanbak/20170614/full_ORCL_20170614_3246_1
File Name: /data/u01/oracle/backups05/rmanbak/20170614/arch_ORCL_20170614_3258_1
File Name: /data/u01/oracle/backups05/rmanbak/20170614/ctl_ORCL_20170614_3262_1
File Name: /data/u01/oracle/backups05/rmanbak/20170614/full_ORCL_20170614_3248_1
File Name: /data/u01/oracle/backups05/rmanbak/20170614/arch_ORCL_20170614_3253_1
File Name: /data/u01/oracle/backups05/rmanbak/20170614/arch_ORCL_20170614_3260_1
File Name: /data/u01/oracle/backups05/rmanbak/20170614/arch_ORCL_20170614_3261_1
File Name: /data/u01/oracle/backups05/rmanbak/20170614/full_ORCL_20170614_3249_1
File Name: /data/u01/oracle/backups05/rmanbak/20170614/full_ORCL_20170614_3244_1
File Name: /data/u01/oracle/backups05/rmanbak/20170614/full_ORCL_20170614_3247_1
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /data/u01/oracle/backups05/rmanbak/20170614/arch_ORCL_20170614_3255_1
File Name: /data/u01/oracle/backups05/rmanbak/20170614/arch_ORCL_20170614_3256_1
File Name: /data/u01/oracle/backups05/rmanbak/20170614/arch_ORCL_20170614_3254_1
File Name: /data/u01/o