Oracle 11g RMAN 异机恢复

以你之姓@ 2024-04-17 23:56 10阅读 0赞

源库：两节点RAC  
目标库：单实例数据库  
  
1、拷贝备份文件到恢复测试服务器

包括2016年2月17日的0级备份和归档日志备份，2月18日的1级累积增量备份和归档日志备份、2月19日的归档日志备份。  
  
scp /orabak/1bqu774c\_1\_1 /orabak/1cqu776a\_1\_1 root@10.100.40.34:/oradata/bk/rman  
.....  
  
拷贝控制文件到恢复测试服务器。

<table style="width:409.4pt;"> 
 <tbody> 
 <tr> 
 <td style="border:.5pt solid;background:#BFBFBF;"> RMAN&gt;&nbsp;LIST&nbsp;BACKUP&nbsp;OF&nbsp;CONTROLFILE; &nbsp; BS&nbsp;Key&nbsp;&nbsp;Type&nbsp;LV&nbsp;Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Device&nbsp;Type&nbsp;Elapsed&nbsp;Time&nbsp;Completion&nbsp;Time&nbsp;&nbsp;&nbsp;&nbsp; -------&nbsp;----&nbsp;--&nbsp;----------&nbsp;-----------&nbsp;------------&nbsp;------------------- 2048&nbsp;&nbsp;&nbsp;&nbsp;Full&nbsp;&nbsp;&nbsp;&nbsp;27.58M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DISK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;00:00:06&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2016-02-17&nbsp;03:53:03 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BP&nbsp;Key:&nbsp;2066&nbsp;&nbsp;&nbsp;Status:&nbsp;AVAILABLE&nbsp;&nbsp;Compressed:&nbsp;NO&nbsp;&nbsp;Tag:&nbsp;TAG20160217T035257 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Piece&nbsp;Name:&nbsp;/orabak/c-1864798816-20160217-00 &nbsp;&nbsp;Control&nbsp;File&nbsp;Included:&nbsp;Ckp&nbsp;SCN:&nbsp;10667216583&nbsp;&nbsp;&nbsp;Ckp&nbsp;time:&nbsp;2016-02-17&nbsp;03:52:57 &nbsp; BS&nbsp;Key&nbsp;&nbsp;Type&nbsp;LV&nbsp;Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Device&nbsp;Type&nbsp;Elapsed&nbsp;Time&nbsp;Completion&nbsp;Time&nbsp;&nbsp;&nbsp;&nbsp; -------&nbsp;----&nbsp;--&nbsp;----------&nbsp;-----------&nbsp;------------&nbsp;------------------- 2052&nbsp;&nbsp;&nbsp;&nbsp;Full&nbsp;&nbsp;&nbsp;&nbsp;27.58M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DISK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;00:00:01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2016-02-17&nbsp;03:55:56 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BP&nbsp;Key:&nbsp;2070&nbsp;&nbsp;&nbsp;Status:&nbsp;AVAILABLE&nbsp;&nbsp;Compressed:&nbsp;NO&nbsp;&nbsp;Tag:&nbsp;TAG20160217T035555 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Piece&nbsp;Name:&nbsp;/orabak/c-1864798816-20160217-01 &nbsp;&nbsp;Control&nbsp;File&nbsp;Included:&nbsp;Ckp&nbsp;SCN:&nbsp;10667223419&nbsp;&nbsp;&nbsp;Ckp&nbsp;time:&nbsp;2016-02-17&nbsp;03:55:55 &nbsp; scp&nbsp;/orabak/c-1864798816-20160217-00&nbsp;root@10.100.40.34:/oradata/bk/rman </td> 
 </tr> 
 </tbody> 
</table>

2、 恢复参数文件和控制文件

<table style="width:409.4pt;"> 
 <tbody> 
 <tr> 
 <td style="border:.5pt solid;background:#BFBFBF;"> [oracle@backup-recovery&nbsp;rman]$&nbsp;rman&nbsp;nocatalog &nbsp; Recovery&nbsp;Manager:&nbsp;Release&nbsp;11.2.0.3.0&nbsp;-&nbsp;Production&nbsp;on&nbsp;Wed&nbsp;Feb&nbsp;24&nbsp;15:34:12&nbsp;2016 &nbsp; Copyright&nbsp;(c)&nbsp;1982,&nbsp;2011,&nbsp;Oracle&nbsp;and/or&nbsp;its&nbsp;affiliates.&nbsp;&nbsp;All&nbsp;rights&nbsp;reserved. &nbsp; RMAN&gt;&nbsp;connect&nbsp;target&nbsp;/ &nbsp; connected&nbsp;to&nbsp;target&nbsp;database&nbsp;(not&nbsp;started) &nbsp; RMAN&gt;&nbsp;set&nbsp;dbid&nbsp;1864798816; &nbsp; executing&nbsp;command:&nbsp;SET&nbsp;DBID &nbsp; RMAN&gt;&nbsp;startup&nbsp;nomount &nbsp; Oracle&nbsp;instance&nbsp;started &nbsp; Total&nbsp;System&nbsp;Global&nbsp;Area&nbsp;&nbsp;&nbsp;17103163392&nbsp;bytes &nbsp; Fixed&nbsp;Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2245480&nbsp;bytes Variable&nbsp;Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2181041304&nbsp;bytes Database&nbsp;Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;14898167808&nbsp;bytes Redo&nbsp;Buffers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;21708800&nbsp;bytes &nbsp; --由于传输文件使用的是root [root@backup-recovery&nbsp;bk]#su&nbsp;- [root@backup-recovery&nbsp;bk]#&nbsp;chown&nbsp;-R&nbsp;oracle.oinstall&nbsp;rman/ &nbsp; RMAN&gt;&nbsp;RUN { &nbsp;&nbsp;ALLOCATE&nbsp;CHANNEL&nbsp;c1&nbsp;DEVICE&nbsp;TYPE&nbsp;disk; &nbsp;&nbsp;SET&nbsp;CONTROLFILE&nbsp;AUTOBACKUP&nbsp;FORMAT&nbsp;FOR&nbsp;DEVICE&nbsp;TYPE&nbsp;DISK&nbsp;TO&nbsp;'/oradata/bk/rman/%F'; &nbsp;&nbsp;RESTORE&nbsp;SPFILE&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;TO&nbsp;PFILE&nbsp;'/u01/app/oracle/product/11.2.0/db_1/dbs/initaftdb.ora'&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;AUTOBACKUP&nbsp;&nbsp;MAXDAYS&nbsp;30; &nbsp;&nbsp;SHUT2&gt;&nbsp;3&gt;&nbsp;4&gt;&nbsp;5&gt;&nbsp;6&gt;&nbsp;7&gt;&nbsp;8&gt;&nbsp;DOWN&nbsp;ABORT; }9&gt;&nbsp; &nbsp; allocated&nbsp;channel:&nbsp;c1 channel&nbsp;c1:&nbsp;SID=1072&nbsp;device&nbsp;type=DISK &nbsp; executing&nbsp;command:&nbsp;SET&nbsp;CONTROLFILE&nbsp;AUTOBACKUP&nbsp;FORMAT &nbsp; Starting&nbsp;restore&nbsp;at&nbsp;24-FEB-16 &nbsp; channel&nbsp;c1:&nbsp;looking&nbsp;for&nbsp;AUTOBACKUP&nbsp;on&nbsp;day:&nbsp;20160224 channel&nbsp;c1:&nbsp;looking&nbsp;for&nbsp;AUTOBACKUP&nbsp;on&nbsp;day:&nbsp;20160223 channel&nbsp;c1:&nbsp;looking&nbsp;for&nbsp;AUTOBACKUP&nbsp;on&nbsp;day:&nbsp;20160222 channel&nbsp;c1:&nbsp;looking&nbsp;for&nbsp;AUTOBACKUP&nbsp;on&nbsp;day:&nbsp;20160221 channel&nbsp;c1:&nbsp;looking&nbsp;for&nbsp;AUTOBACKUP&nbsp;on&nbsp;day:&nbsp;20160220 channel&nbsp;c1:&nbsp;looking&nbsp;for&nbsp;AUTOBACKUP&nbsp;on&nbsp;day:&nbsp;20160219 channel&nbsp;c1:&nbsp;looking&nbsp;for&nbsp;AUTOBACKUP&nbsp;on&nbsp;day:&nbsp;20160218 channel&nbsp;c1:&nbsp;looking&nbsp;for&nbsp;AUTOBACKUP&nbsp;on&nbsp;day:&nbsp;20160217 channel&nbsp;c1:&nbsp;AUTOBACKUP&nbsp;found:&nbsp;/oradata/bk/rman/c-1864798816-20160217-00 channel&nbsp;c1:&nbsp;restoring&nbsp;spfile&nbsp;from&nbsp;AUTOBACKUP&nbsp;/oradata/bk/rman/c-1864798816-20160217-00 channel&nbsp;c1:&nbsp;SPFILE&nbsp;restore&nbsp;from&nbsp;AUTOBACKUP&nbsp;complete Finished&nbsp;restore&nbsp;at&nbsp;24-FEB-16 &nbsp; Oracle&nbsp;instance&nbsp;shut&nbsp;down </td> 
 </tr> 
 </tbody> 
</table>

编辑生成的参数文件，修改对应的控制文件目录、audit\_file\_dest、db\_recovery\_file\_dest、db\_create\_online\_log\_dest 等目录，保证指定的目录存在。

<table style="width:409.4pt;"> 
 <tbody> 
 <tr> 
 <td style="border:.5pt solid;background:#BFBFBF;"> [oracle@backup-recovery&nbsp;dbs]$&nbsp;vim&nbsp;initaftdb.ora &nbsp; __db_cache_size=1542724608 __java_pool_size=67108864 __large_pool_size=67108864 __oracle_base='/u01/app/oracle'#ORACLE_BASE&nbsp;set&nbsp;from&nbsp;environment __pga_aggregate_target=2375342080 __sga_target=19126026240 __shared_io_pool_size=0 __shared_pool_size=845104128 __streams_pool_size=67108864 *.audit_file_dest='/u01/app/oracle/admin/aftdb/adump' *.audit_sys_operations=TRUE *.audit_trail='db' #*.cluster_database=true *.compatible='11.2.0.0.0' *.control_files='/oradata/aftdb/controlfile/control01.ctl','/oradata/aftdb/controlfile/control02.ctl' *.db_block_size=8192 *.db_create_file_dest='/oradata/aftdb/data' *.db_create_online_log_dest_1='/oradata/aftdb/log' *.db_create_online_log_dest_2='/oradata/aftdb/log' *.db_domain='' *.db_name='aftdb' *.db_recovery_file_dest='/oradata/aftdb/recovery' *.db_recovery_file_dest_size=536759762944 *.db_unique_name='aftdb' *.deferred_segment_creation=FALSE *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP)&nbsp;(SERVICE=aftdbXDB)' *.fal_server='atfdbdg' #aftdb2.instance_number=2 #aftdb1.instance_number=1 #*.log_archive_config='DG_CONFIG=(aftdb,atfdbdg)' *.LOG_ARCHIVE_DEST_1='LOCATION=/oradata/aftdb/arc' #&nbsp;&nbsp;VALID_FOR=(ALL_LOGFILES,ALL_ROLES) #&nbsp;&nbsp;DB_UNIQUE_NAME=aftdb' #*.LOG_ARCHIVE_DEST_2='SERVICE=atfdbdg&nbsp;ASYNC #&nbsp;&nbsp;VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) #DB_UNIQUE_NAME=atfdbdg *.LOG_ARCHIVE_DEST_STATE_1='ENABLE' *.log_archive_dest_state_2='enable' *.LOG_ARCHIVE_FORMAT='log%d_%t_%s_%r.arc' *.LOG_ARCHIVE_MAX_PROCESSES=30 *.open_cursors=300 *.os_roles=FALSE *.pga_aggregate_target=6357516288 *.processes=800 *.recyclebin='OFF' #*.remote_listener='rac-scan:1521' *.remote_login_passwordfile='EXCLUSIVE' *.session_cached_cursors=200 *.sessions=885 *.sga_target=19072548864 *.sql92_security=TRUE #*.STANDBY_FILE_MANAGEMENT='AUTO' #aftdb2.thread=2 #aftdb1.thread=1 #aftdb.undo_tablespace='UNDOTBS3' undo_tablespace='UNDOTBS1' &nbsp;--创建参数文件中对应的目录 mkdir&nbsp;-p&nbsp;/oradata/aftdb/data mkdir&nbsp;-p&nbsp;/oradata/aftdb/log mkdir&nbsp;-p&nbsp;/oradata/aftdb/arc mkdir&nbsp;-p&nbsp;/oradata/aftdb/recovery mkdir&nbsp;-p&nbsp;/oradata/aftdb/controlfile </td> 
 </tr> 
 </tbody> 
</table>

用新还原的参数文件启动数据库。

<table style="width:409.4pt;"> 
 <tbody> 
 <tr> 
 <td style="border:.5pt solid;background:#BFBFBF;"> SQL&gt;&nbsp;STARTUP&nbsp;FORCE&nbsp;NOMOUNT&nbsp;PFILE='/u01/app/oracle/product/11.2.0/db_1/dbs/initaftdb.ora'; ORACLE&nbsp;instance&nbsp;started. &nbsp; Total&nbsp;System&nbsp;Global&nbsp;Area&nbsp;1.9041E+10&nbsp;bytes Fixed&nbsp;Size &nbsp;&nbsp;&nbsp;&nbsp;2236368&nbsp;bytes Variable&nbsp;Size &nbsp;1543503920&nbsp;bytes Database&nbsp;Buffers &nbsp;1.7448E+10&nbsp;bytes Redo&nbsp;Buffers &nbsp;&nbsp;&nbsp;46587904&nbsp;bytes --执行控制文件恢复 [oracle@backup-recovery&nbsp;dbs]$&nbsp;rman&nbsp;target&nbsp;/ &nbsp; Recovery&nbsp;Manager:&nbsp;Release&nbsp;11.2.0.3.0&nbsp;-&nbsp;Production&nbsp;on&nbsp;Thu&nbsp;Feb&nbsp;25&nbsp;09:48:45&nbsp;2016 &nbsp; Copyright&nbsp;(c)&nbsp;1982,&nbsp;2011,&nbsp;Oracle&nbsp;and/or&nbsp;its&nbsp;affiliates.&nbsp;&nbsp;All&nbsp;rights&nbsp;reserved. &nbsp; connected&nbsp;to&nbsp;target&nbsp;database:&nbsp;AFTDB&nbsp;(not&nbsp;mounted) &nbsp; RMAN&gt;&nbsp;set&nbsp;dbid&nbsp;1864798816; &nbsp; executing&nbsp;command:&nbsp;SET&nbsp;DBID &nbsp; RMAN&gt;&nbsp;&nbsp;RUN&nbsp; { &nbsp;&nbsp;ALLOCATE&nbsp;CHANNEL&nbsp;c1&nbsp;DEVICE&nbsp;TYPE&nbsp;disk; SET&nbsp;CONTROLFILE&nbsp;AUTOBACKUP&nbsp;FORMAT&nbsp;FOR&nbsp;DEVICE&nbsp;TYPE&nbsp;DISK&nbsp;TO&nbsp;'/oradata/bk/rman/%F'; &nbsp;&nbsp;RESTORE&nbsp;CONTROLFILE&nbsp;FROM&nbsp;AUTOBACKUP&nbsp;MAXDAYS&nbsp;30; &nbsp;&nbsp;ALTER&nbsp;DATABASE&nbsp;MOUNT; }2&gt;&nbsp;3&gt;&nbsp;4&gt;&nbsp;5&gt;&nbsp;6&gt;&nbsp;7&gt;&nbsp; &nbsp;using&nbsp;target&nbsp;database&nbsp;control&nbsp;file&nbsp;instead&nbsp;of&nbsp;recovery&nbsp;catalog allocated&nbsp;channel:&nbsp;c1 channel&nbsp;c1:&nbsp;SID=1174&nbsp;device&nbsp;type=DISK &nbsp; executing&nbsp;command:&nbsp;SET&nbsp;CONTROLFILE&nbsp;AUTOBACKUP&nbsp;FORMAT &nbsp; Starting&nbsp;restore&nbsp;at&nbsp;25-FEB-16 &nbsp; recovery&nbsp;area&nbsp;destination:&nbsp;/oradata/aftdb/recovery database&nbsp;name&nbsp;(or&nbsp;database&nbsp;unique&nbsp;name)&nbsp;used&nbsp;for&nbsp;search:&nbsp;AFTDB channel&nbsp;c1:&nbsp;no&nbsp;AUTOBACKUPS&nbsp;found&nbsp;in&nbsp;the&nbsp;recovery&nbsp;area channel&nbsp;c1:&nbsp;looking&nbsp;for&nbsp;AUTOBACKUP&nbsp;on&nbsp;day:&nbsp;20160225 channel&nbsp;c1:&nbsp;looking&nbsp;for&nbsp;AUTOBACKUP&nbsp;on&nbsp;day:&nbsp;20160224 channel&nbsp;c1:&nbsp;looking&nbsp;for&nbsp;AUTOBACKUP&nbsp;on&nbsp;day:&nbsp;20160223 channel&nbsp;c1:&nbsp;looking&nbsp;for&nbsp;AUTOBACKUP&nbsp;on&nbsp;day:&nbsp;20160222 channel&nbsp;c1:&nbsp;looking&nbsp;for&nbsp;AUTOBACKUP&nbsp;on&nbsp;day:&nbsp;20160221 channel&nbsp;c1:&nbsp;looking&nbsp;for&nbsp;AUTOBACKUP&nbsp;on&nbsp;day:&nbsp;20160220 channel&nbsp;c1:&nbsp;looking&nbsp;for&nbsp;AUTOBACKUP&nbsp;on&nbsp;day:&nbsp;20160219 channel&nbsp;c1:&nbsp;looking&nbsp;for&nbsp;AUTOBACKUP&nbsp;on&nbsp;day:&nbsp;20160218 channel&nbsp;c1:&nbsp;looking&nbsp;for&nbsp;AUTOBACKUP&nbsp;on&nbsp;day:&nbsp;20160217 channel&nbsp;c1:&nbsp;AUTOBACKUP&nbsp;found:&nbsp;/oradata/bk/rman/c-1864798816-20160217-00 channel&nbsp;c1:&nbsp;restoring&nbsp;control&nbsp;file&nbsp;from&nbsp;AUTOBACKUP&nbsp;/oradata/bk/rman/c-1864798816-20160217-00 channel&nbsp;c1:&nbsp;control&nbsp;file&nbsp;restore&nbsp;from&nbsp;AUTOBACKUP&nbsp;complete output&nbsp;file&nbsp;name=/oradata/aftdb/controlfile/control01.ctl output&nbsp;file&nbsp;name=/oradata/aftdb/controlfile/control02.ctl Finished&nbsp;restore&nbsp;at&nbsp;25-FEB-16 &nbsp; database&nbsp;mounted released&nbsp;channel:&nbsp;c1 </td> 
 </tr> 
 </tbody> 
</table>

在  RMAN  中登记传输过来的备份文件。

<table style="width:409.4pt;"> 
 <tbody> 
 <tr> 
 <td style="border:.5pt solid;background:#BFBFBF;"> &nbsp; RMAN&gt;&nbsp;CATALOG&nbsp;START&nbsp;WITH&nbsp;'/oradata/bk/rman'; &nbsp; Starting&nbsp;implicit&nbsp;crosscheck&nbsp;backup&nbsp;at&nbsp;25-FEB-16 allocated&nbsp;channel:&nbsp;ORA_DISK_1 channel&nbsp;ORA_DISK_1:&nbsp;SID=1174&nbsp;device&nbsp;type=DISK allocated&nbsp;channel:&nbsp;ORA_DISK_2 channel&nbsp;ORA_DISK_2:&nbsp;SID=1&nbsp;device&nbsp;type=DISK Crosschecked&nbsp;312&nbsp;objects Finished&nbsp;implicit&nbsp;crosscheck&nbsp;backup&nbsp;at&nbsp;25-FEB-16 &nbsp; Starting&nbsp;implicit&nbsp;crosscheck&nbsp;copy&nbsp;at&nbsp;25-FEB-16 using&nbsp;channel&nbsp;ORA_DISK_1 using&nbsp;channel&nbsp;ORA_DISK_2 Crosschecked&nbsp;2&nbsp;objects Finished&nbsp;implicit&nbsp;crosscheck&nbsp;copy&nbsp;at&nbsp;25-FEB-16 &nbsp; searching&nbsp;for&nbsp;all&nbsp;files&nbsp;in&nbsp;the&nbsp;recovery&nbsp;area cataloging&nbsp;files... no&nbsp;files&nbsp;cataloged &nbsp; searching&nbsp;for&nbsp;all&nbsp;files&nbsp;that&nbsp;match&nbsp;the&nbsp;pattern&nbsp;/oradata/bk/rman &nbsp; List&nbsp;of&nbsp;Files&nbsp;Unknown&nbsp;to&nbsp;the&nbsp;Database ===================================== File&nbsp;Name:&nbsp;/oradata/bk/rman/11qu4c02_1_1 File&nbsp;Name:&nbsp;/oradata/bk/rman/18qu754j_1_1 File&nbsp;Name:&nbsp;/oradata/bk/rman/10qu4c02_1_1 File&nbsp;Name:&nbsp;/oradata/bk/rman/1iqua40d_1_1 File&nbsp;Name:&nbsp;/oradata/bk/rman/c-1864798816-20160217-00 File&nbsp;Name:&nbsp;/oradata/bk/rman/1hqua408_1_1 File&nbsp;Name:&nbsp;/oradata/bk/rman/17qu754j_1_1 File&nbsp;Name:&nbsp;/oradata/bk/rman/1jqua422_1_1 &nbsp; Do&nbsp;you&nbsp;really&nbsp;want&nbsp;to&nbsp;catalog&nbsp;the&nbsp;above&nbsp;files&nbsp;(enter&nbsp;YES&nbsp;or&nbsp;NO)?&nbsp;YES cataloging&nbsp;files... cataloging&nbsp;done &nbsp; List&nbsp;of&nbsp;Cataloged&nbsp;Files ======================= File&nbsp;Name:&nbsp;/oradata/bk/rman/11qu4c02_1_1 File&nbsp;Name:&nbsp;/oradata/bk/rman/18qu754j_1_1 File&nbsp;Name:&nbsp;/oradata/bk/rman/10qu4c02_1_1 File&nbsp;Name:&nbsp;/oradata/bk/rman/1iqua40d_1_1 File&nbsp;Name:&nbsp;/oradata/bk/rman/c-1864798816-20160217-00 File&nbsp;Name:&nbsp;/oradata/bk/rman/1hqua408_1_1 File&nbsp;Name:&nbsp;/oradata/bk/rman/17qu754j_1_1 File&nbsp;Name:&nbsp;/oradata/bk/rman/1jqua422_1_1 &nbsp; --检查数据备份，删除过期的备份 crosscheck&nbsp;backup; delete&nbsp;noprompt&nbsp;expired&nbsp;backup; </td> 
 </tr> 
 </tbody> 
</table>

3、恢复数据文件并打开数据库

<table style="width:409.4pt;"> 
 <tbody> 
 <tr> 
 <td style="border:.5pt solid;background:#BFBFBF;"> --查看归档日志备份的&nbsp;SCN，决定介质恢复的&nbsp;SCN list&nbsp;backup&nbsp;of&nbsp;archivelog&nbsp;all; BS&nbsp;Key&nbsp;&nbsp;Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Device&nbsp;Type&nbsp;Elapsed&nbsp;Time&nbsp;Completion&nbsp;Time&nbsp;&nbsp;&nbsp;&nbsp; -------&nbsp;----------&nbsp;-----------&nbsp;------------&nbsp;------------------- 2052&nbsp;&nbsp;&nbsp;&nbsp;6.15G&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DISK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;00:00:00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2016-02-19&nbsp;07:52:34 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BP&nbsp;Key:&nbsp;2072&nbsp;&nbsp;&nbsp;Status:&nbsp;AVAILABLE&nbsp;&nbsp;Compressed:&nbsp;NO&nbsp;&nbsp;Tag:&nbsp;BACKUP_AFTDB_00184_021916071802 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Piece&nbsp;Name:&nbsp;/oradata/bk/rman/1jqua422_1_1 &nbsp; &nbsp;&nbsp;List&nbsp;of&nbsp;Archived&nbsp;Logs&nbsp;in&nbsp;backup&nbsp;set&nbsp;2052 &nbsp;&nbsp;Thrd&nbsp;Seq&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Low&nbsp;SCN&nbsp;&nbsp;&nbsp;&nbsp;Low&nbsp;Time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Next&nbsp;SCN&nbsp;&nbsp;&nbsp;Next&nbsp;Time &nbsp; &nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;12266&nbsp;&nbsp;&nbsp;10713786121&nbsp;2016-02-18&nbsp;23:34:30&nbsp;10731754131&nbsp;2016-02-19&nbsp;00:07:10 &nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;12267&nbsp;&nbsp;&nbsp;10731754131&nbsp;2016-02-19&nbsp;00:07:10&nbsp;10731849681&nbsp;2016-02-19&nbsp;00:14:25 &nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;12268&nbsp;&nbsp;&nbsp;10731849681&nbsp;2016-02-19&nbsp;00:14:25&nbsp;10732092124&nbsp;2016-02-19&nbsp;00:33:38 &nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;12269&nbsp;&nbsp;&nbsp;10732092124&nbsp;2016-02-19&nbsp;00:33:38&nbsp;10732405415&nbsp;2016-02-19&nbsp;01:03:15 &nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;12270&nbsp;&nbsp;&nbsp;10732405415&nbsp;2016-02-19&nbsp;01:03:15&nbsp;10732726304&nbsp;2016-02-19&nbsp;01:40:52 &nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;12271&nbsp;&nbsp;&nbsp;10732726304&nbsp;2016-02-19&nbsp;01:40:52&nbsp;10734774257&nbsp;2016-02-19&nbsp;02:36:30 &nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;12272&nbsp;&nbsp;&nbsp;10734774257&nbsp;2016-02-19&nbsp;02:36:30&nbsp;10735123263&nbsp;2016-02-19&nbsp;03:52:15 &nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;12273&nbsp;&nbsp;&nbsp;10735123263&nbsp;2016-02-19&nbsp;03:52:15&nbsp;10735485192&nbsp;2016-02-19&nbsp;05:53:10 &nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;12274&nbsp;&nbsp;&nbsp;10735485192&nbsp;2016-02-19&nbsp;05:53:10&nbsp;10735843618&nbsp;2016-02-19&nbsp;07:22:16 &nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;12275&nbsp;&nbsp;&nbsp;10735843618&nbsp;2016-02-19&nbsp;07:22:16&nbsp;10736032424&nbsp;2016-02-19&nbsp;07:51:17 &nbsp; --执行&nbsp;RESTORE&nbsp;命令，恢复数据文件 --在源库生成 SET NEWNAME 的批量脚本 &nbsp;SQL&gt; select 'SET NEWNAME FOR DATAFILE ' || file_id || ' TO ' || &nbsp; &nbsp; &nbsp; &nbsp;'''/oradata/misdb/df' || file_id || '.dbf'''||';' &nbsp; from dba_data_files &nbsp;order by file_id;&nbsp; 'SETNEWNAMEFORDATAFILE'||FILE_ID||'TO'||'''/ORADATA/AFTDB/DATA/DF'||FILE_ID||'.DBF;''' ------------------------------------------------------------------------------------------------------------------------------------------ SET NEWNAME FOR DATAFILE 1 TO '/oradata/aftdb/data/df1.dbf;' SET NEWNAME FOR DATAFILE 2 TO '/oradata/aftdb/data/df2.dbf;' SET NEWNAME FOR DATAFILE 3 TO '/oradata/aftdb/data/df3.dbf;' SET NEWNAME FOR DATAFILE 4 TO '/oradata/aftdb/data/df4.dbf;' SET NEWNAME FOR DATAFILE 5 TO '/oradata/aftdb/data/df5.dbf;' SET NEWNAME FOR DATAFILE 6 TO '/oradata/aftdb/data/df6.dbf;' SET NEWNAME FOR DATAFILE 7 TO '/oradata/aftdb/data/df7.dbf;' SET NEWNAME FOR DATAFILE 8 TO '/oradata/aftdb/data/df8.dbf;' SET NEWNAME FOR DATAFILE 9 TO '/oradata/aftdb/data/df9.dbf;' SET NEWNAME FOR DATAFILE 10 TO '/oradata/aftdb/data/df10.dbf;' SET NEWNAME FOR DATAFILE 11 TO '/oradata/aftdb/data/df11.dbf;' 
 <div>
 ..... 
 </div> --编写 SHELL 脚本 [oracle@backup-recovery script]$ vim rman.sh&nbsp; echo "The operation starts .." &gt;&gt; /home/oracle/rman_timetable.log echo `date` &gt;&gt; /home/oracle/rman_timetable.log rman target / log=/home/oracle/rman.log &lt;&lt; EOF RUN { SET NEWNAME FOR DATAFILE 1 TO '/oradata/aftdb/data/df1.dbf'; SET NEWNAME FOR DATAFILE 2 TO '/oradata/aftdb/data/df2.dbf'; SET NEWNAME FOR DATAFILE 3 TO '/oradata/aftdb/data/df3.dbf'; SET NEWNAME FOR DATAFILE 4 TO '/oradata/aftdb/data/df4.dbf'; SET NEWNAME FOR DATAFILE 5 TO '/oradata/aftdb/data/df5.dbf'; SET NEWNAME FOR DATAFILE 6 TO '/oradata/aftdb/data/df6.dbf'; SET NEWNAME FOR DATAFILE 7 TO '/oradata/aftdb/data/df7.dbf'; SET NEWNAME FOR DATAFILE 8 TO '/oradata/aftdb/data/df8.dbf'; SET NEWNAME FOR DATAFILE 9 TO '/oradata/aftdb/data/df9.dbf'; SET NEWNAME FOR DATAFILE 10 TO '/oradata/aftdb/data/df10.dbf'; SET NEWNAME FOR DATAFILE 11 TO '/oradata/aftdb/data/df11.dbf'; SET NEWNAME FOR DATAFILE 12 TO '/oradata/aftdb/data/df12.dbf'; SET NEWNAME FOR DATAFILE 13 TO '/oradata/aftdb/data/df13.dbf'; SET NEWNAME FOR DATAFILE 14 TO '/oradata/aftdb/data/df14.dbf'; SET NEWNAME FOR DATAFILE 15 TO '/oradata/aftdb/data/df15.dbf'; SET NEWNAME FOR DATAFILE 16 TO '/oradata/aftdb/data/df16.dbf'; SET NEWNAME FOR DATAFILE 17 TO '/oradata/aftdb/data/df17.dbf'; SET NEWNAME FOR DATAFILE 18 TO '/oradata/aftdb/data/df18.dbf'; SET NEWNAME FOR DATAFILE 19 TO '/oradata/aftdb/data/df19.dbf'; SET NEWNAME FOR DATAFILE 20 TO '/oradata/aftdb/data/df20.dbf'; SET NEWNAME FOR DATAFILE 21 TO '/oradata/aftdb/data/df21.dbf'; SET NEWNAME FOR DATAFILE 22 TO '/oradata/aftdb/data/df22.dbf'; SET NEWNAME FOR DATAFILE 23 TO '/oradata/aftdb/data/df23.dbf'; SET NEWNAME FOR DATAFILE 24 TO '/oradata/aftdb/data/df24.dbf'; SET NEWNAME FOR DATAFILE 114 TO '/oradata/aftdb/data/df114.dbf'; RESTORE DATABASE; SWITCH DATAFILE ALL; } exit EOF echo "The operation finished .." &gt;&gt; /home/oracle/rman_timetable.log echo `date` &gt;&gt; /home/oracle/rman_timetable.log --也可以直接使用下面命令，而不用为每个数据文件命名 SET NEWNAME FOR DATABASE TO '/oradata1/%b'; nohup sh rma.sh &amp; tailf&nbsp;/home/oracle/rman.log --恢复完成后，打开数据库 SQL&gt; RECOVER DATABASE using backup controlfile UNTIL CHANGE 10736032424; SQL&gt;&nbsp;alter&nbsp;database&nbsp;open&nbsp;resetlogs; &nbsp; Database&nbsp;altered. --创建SPFILE SQL&gt;&nbsp;create&nbsp;spfile&nbsp;from&nbsp;PFILE='/u01/app/oracle/product/11.2.0/db_1/dbs/initaftdb.ora'; </td> 
 </tr> 
 </tbody> 
</table>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-1994603/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-1994603/