rman异机恢复实践全图解析

《rman异机恢复实践全图解析》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、全库备份(包括数据库，控制文件，归档日志)RMAN>run{2>backupfulldatabaseformat'/orabk/full_%U.bak';3>backuparchivelogallformat'/orabk/arc_%U.bak'deleteinput;4>copycurrentcontrolfileto'/orabk/control_bak.ctl';5>}Startingbackupat28-MAY-07usingchannelORA_DISK_1channelORA_DISK_1:startingfulldatafilebac

2、kupsetchannelORA_DISK_1:specifyingdatafile(s)inbackupsetincludingcurrentSPFILEinbackupsetincludingcurrentcontrolfileinbackupsetinputdatafilefno=00011name=/u01/app/oracle/oradata/orcl9i/rep_test.dbfinputdatafilefno=00001name=/u01/app/oracle/oradata/orcl9i/system01.dbfinputdataf

3、ilefno=00002name=/u01/app/oracle/oradata/orcl9i/undotbs01.dbfinputdatafilefno=00005name=/u01/app/oracle/oradata/orcl9i/example01.dbfinputdatafilefno=00012name=/u01/app/oracle/oradata/orcl9i/rman_ts01.dbfinputdatafilefno=00010name=/u01/app/oracle/oradata/orcl9i/xdb01.dbfinputda

4、tafilefno=00006name=/u01/app/oracle/oradata/orcl9i/indx01.dbfinputdatafilefno=00009name=/u01/app/oracle/oradata/orcl9i/users01.dbfinputdatafilefno=00003name=/u01/app/oracle/oradata/orcl9i/cwmlite01.dbfinputdatafilefno=00004name=/u01/app/oracle/oradata/orcl9i/drsys01.dbfinputda

5、tafilefno=00007name=/u01/app/oracle/oradata/orcl9i/odm01.dbfinputdatafilefno=00008name=/u01/app/oracle/oradata/orcl9i/tools01.dbfchannelORA_DISK_1:startingpiece1at28-MAY-07channelORA_DISK_1:finishedpiece1at28-MAY-07piecehandle=/orabk/full_07iis0oe_1_1.bakcomment=NONEchannelORA

6、_DISK_1:backupsetcomplete,elapsedtime:00:24:05Finishedbackupat28-MAY-07Startingbackupat28-MAY-07currentlogarchivedusingchannelORA_DISK_1channelORA_DISK_1:startingarchivelogbackupsetchannelORA_DISK_1:specifyingarchivelog(s)inbackupsetinputarchivelogthread=1sequence=23recid=23st

7、amp=623773878channelORA_DISK_1:startingpiece1at28-MAY-07channelORA_DISK_1:finishedpiece1at28-MAY-07piecehandle=/orabk/arc_08iis25m_1_1.bakcomment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:00:02channelORA_DISK_1:deletingarchivelog(s)archivelogfilename=/u01/app/orac

8、le/oradata/orcl9i/archive/1_23.dbfrecid=23stamp=623773878Fini