????1.rman??????????????????????datafile??controlfile??spfile???????????????archivelog??????redolog??
????2.rman?????????
????a.RMAN0??????????:
????run{
????allocatechannelc1typedisk;
????allocatechannelc2typedisk;
????allocatechannelc3typedisk;
????backupincrementallevel0tag'level0'format"E: ecovery_area fdb fdbAUTOBACKUP man_dirRFDB_level_0_%u_%s_%p"ascompressedbackupset
????database;
????sql"altersystemarchivelogcurrent";
????backupfilesperset3format"E: ecovery_area fdb fdbAUTOBACKUP man_dirarch_%u_%s_%p_%c"
????archivelogalldeleteinput;#????鵵???????????????????
????releasechannelc1;
????releasechannelc2;
????releasechannelc3;
????}
????b.RMAN1??????????:
????run{
????allocatechannelc1typedisk;
????allocatechannelc2typedisk;
????allocatechannelc3typedisk;
????backupincrementallevel1tag'level1'format'E: ecovery_area fdb fdbAUTOBACKUP man_dirRFDB_level_1_%u_%s_%p'ascompressedbackupset
????database;
????sql'altersystemarchivelogcurrent';
????backupfilesperset3format'E: ecovery_area fdb fdbAUTOBACKUP man_dirarch_%u_%s_%p'
????archivelogalldeleteinput;#????鵵???????????????????
????releasechannelc1;
????releasechannelc2;
????releasechannelc3;
????}
????c.rman??????????????????????????￡?????????????:
????DELETENOPROMPTOBSOLETERECOVERYWINDOWOF1DAYS;
????d.??????????????rman????????????
????rmantargetsys/rf4rfvbgt56yhn@rfdbnocatalogCMDFILE'D:app man man_filelevel_0.txt'log=E: ecovery_area fdb fdbAUTOBACKUP man_dirlog man_level_0.log
????3.rman???
????a.????datafile??controlfile??spfile??rman??????????????archivelog??????redolog??????μ??????
????b.?л???oracle?????????rman????????sid????
????exportORACLE_SID=rfdb
????rlwraprmantarget/
????c.??????α?????
????RMAN>startupnomount
????connectedtotargetdatabase(notstarted)
????startupfailed:ORA-01078:failureinprocessingsystemparameters
????LRM-00109:couldnotopenparameterfile'/u01/app/oracle/product/11.2.0/db1/dbs/initrfdb.ora'
????startingOracleinstancewithoutparameterfileforretrievalofspfile
????Oracleinstancestarted
????TotalSystemGlobalArea1068937216bytes
????FixedSize2260088bytes
????VariableSize281019272bytes
????DatabaseBuffers780140544bytes
????RedoBuffers5517312bytes
????d.??α???????spfile?????????????rman??????????
????RMAN>restorespfilefrom"/u01/ora_bak/ora_bak/autobackup/2015_12_07/o1_mf_s_897845728_c6bnq1rq_.bkp";
????Startingrestoreat14-DEC-15
????usingchannelORA_DISK_1
????channelORA_DISK_1:restoringspfilefromAUTOBACKUP/u01/ora_bak/ora_bak/autobackup/2015_12_07/o1_mf_s_897845728_c6bnq1rq_.bkp
????channelORA_DISK_1:SPFILErestorefromAUTOBACKUPcomplete
????Finishedrestoreat14-DEC-15
????e.???α???????spfile????????nomount????
????RMAN>shutdownabort
????Oracleinstanceshutdown
????RMAN>startupnomount
????connectedtotargetdatabase(notstarted)
????Oracleinstancestarted
????TotalSystemGlobalArea1068937216bytes
????FixedSize2260088bytes
????VariableSize910164872bytes
????DatabaseBuffers150994944bytes
????RedoBuffers5517312bytes
????f.????????????????????rman???????????????ú?spfile???????????????
????RMAN>restorecontrolfilefrom"/u01/ora_bak/ora_bak/autobackup/2015_12_07/o1_mf_s_897845728_c6bnq1rq_.bkp";
????Startingrestoreat14-DEC-15
????allocatedchannel:ORA_DISK_1
????channelORA_DISK_1:SID=1146devicetype=DISK
????channelORA_DISK_1:restoringcontrolfile
????channelORA_DISK_1:restorecomplete??elapsedtime:00:00:01
????outputfilename=/u01/app/oracle/oradata/ATEST/controlfile/o1_mf_c5fr9b0h_.ctl
????outputfilename=/u01/app/oracle/fast_recovery_area/ATEST/controlfile/o1_mf_c5fr9b6n_.ctl
????Finishedrestoreat14-DEC-15
????g.??????????mount????
????RMAN>alterdatabasemount;
????databasemounted
????releasedchannel:ORA_DISK_1