rman备份恢复详解

《rman备份恢复详解》由会员分享，可在线阅读，更多相关《rman备份恢复详解（47页珍藏版）》请在装配图网上搜索。

1、第一部分，认识rmanRMAN可连接的数据库的类型: TargetdatabaseRMANconnectsyoutothetargetdatabase,whichisthedatabasethatyouareback!nguporrecovering,withtheSYSDBAprivilege.Ifyoudonothavethisprivilege,thentheconnectionfails. RecoverycatalogdatabaseThisdatabaseisoptional.Bydefault.RMANrunsinNOCATALOGmode. AuxiliarydatabaseY

2、oucanconnecttoastandbydatabase,duplicatedatabase,orauxiliaryinstance(standbyinstaneeortablespacepoint-intimGrecoveryinstance).fnrootdirector#find/-namerman/u01/oracle/10g/sysman/admin/scripts/db/rman/u01/oracle/10g/oc4j/j2ee/oc4j_applications/applications/em/em/WEB-INF/perl/db/rman/u01/oracle/10g/oc

3、4j/j2ee/oc4j_applications/applications/em/em/database/rman/u01/oracle/10g/bin/rman调整顺序的话就调整这个文件rootdirector#if-f/.bashrc;then./.bashrcfi#UserspecificenvironmentandstartupprogramsPATH=$PATH:$HOME/binexportPATHexportORACLE_BASE=/u01/oracleexportORACLE_HOME=$ORACLE_BASE/10gexportORACLE_SID=TestDBexport

4、PATH=$ORACLE_HOME/jdk/bin:$PATHexportPATH=/usr/sbin:$PATH:$ORACLE_HOME/bin;exportPATH=$ORACLE_HOME/bin:$PATH;exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;exportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;aliassqlplus=rlwrapsqlplusrman备份可以进行的前提条件是数据库必须处于归档模式oracledire

5、ctor$sqlplus/assysdbaSQL*Plus:Release10.2.0.1.0-ProductiononFriMay2004:50:022016Copyright(c)1982,2005,Oracle.Allrightsreserved.Connectedto:OracleDatabase10gEnterpriseEditionRelease10.2.0.1.0-ProductionWiththePartitioning,OLAPandDataMiningoptionsSQLarchiveloglist;DatabaselogmodeArchiveModeAutomaticar

6、chivalEnabledArchivedestinationUSE_DB_RECOVERY_FILE_DESTOldestonlinelogsequenee3Nextlogsequeneetoarchive5Currentlogsequenee5强制归档日志命令SQLitersystemarchivelogeurrent;Systemaltered.SQLaltersystemswitchlogfile;Systemaltered.SQL配置rmanRMANshowall;RMANconfigurationparametersare:CONFIGURERETENTIONPOLICYTOREC

7、OVERYWINDOWOF1DAYS;设置保存策略CONFIGUREBACKUPOPTIMIZATIONON;设置为优化选项为onCONFIGUREDEFAULTDEVICETYPETOSBT_TAPE：设置备份介质CONFIGURECONTROLFILEAUTOBACKUPON;设置自动备份控制文件CONFIGURECONTROLFILEAUTOBACKUPFORMATFORDEVICETYPESBT_TAPETO%F：#defaultCONFIGURECONTROLFILEAUTOBACKUPFORMATFORDEVICETYPEDISKTO%F;#defaultCONFIGUREDEVI

8、CETYPESBT_TAPEPARALLELISM4BACKUPTYPETOBACKUPSET;备份通道个数CONFIGUREDEVICETYPEDISKPARALLELISM8BACKUPTYPETOBACKUPSET;磁盘通道个数CONFIGUREDATAFILEBACKUPCOPIESFORDEVICETYPESBT_TAPETO1;#defaultCONFIGUREDATAFILEBACKUPCOPIESFORDEVICETYPEDISKTO1;#defaultCONFIGUREARCHIVELOGBACKUPCOPIESFORDEVICETYPESBT_TAPETO1;#defaul

9、tCONFIGUREARCHIVELOGBACKUPCOPIESFORDEVICETYPEDISKTO1;#defaultCONFIGURECHANNEL1DEVICETYPESBT_TAPEPARMSENV=(OB_MEDIA_FAMILY=station21)CONNECTsys/oracle1orcl;设置媒介家庭CONFIGURECHANNEL2DEVICETYPESBT_TAPEPARMSENV=(OB_MEDIA_FAMILY=station21)CONNECTsys/oracle1orcl;设置媒介家庭CONFIGUREMAXSETSIZETOUNLIMITED;#default

10、CONFIGUREENCRYPTIONFORDATABASEOFF;#defaultCONFIGUREENCRYPTIONALGORITHMAES128：#defaultCONFIGUREARCHIVELOGDELETIONPOLICYTONONE;#defaultCONFIGURESNAPSHOTCONTROLFILENAMETO7u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_orclf;#defaultsetORACLE_SID=portalreportRMAN命令详解一、list命令1. List当前RMAN所备份的数据库:1.1.listb

11、ackupsummary;-概述可用的备份listincarnation;-汇总查询-如果备份文件多的话多用这两个list命令可以对备份文件有个总体了解。B表示backupA表示Archivelog、F表示fullbackup、0,1,2表示incrementallevel备份A表示可用AVALIABLE、X表示EXPIRED这个命令可以派生出很多类似命令，例如listbackupofdatabasesummarylistbackupofarchivelogallsummarylistbackupoftablespaceuserssummary;listbackupofdatafilen,n,

12、nsummary这些命令可以让我们对已有的备份文件有一个整体，直观的了解。1.2.listbackupbyfile;-按照文件类型分别列出SPFILE列表分别为：数据文件列表、归档日志列表、控制文件列表、1.3.listbackup;这个命令列出已有备份集的详细信息。1.4.listexpiredbackup;列出过期的备份文件1.5.listcopy;列出copy文件listcopyofdatabase;listcopyofcontrolfile;listcopyoftablespaceusers;listcopyofdatafilen,n,n;listcopyofarchivelogall

13、;listcopyofarchivelogfromsen10000;listcopyofarchiveloguntilsequenee12;List相关文件的信息listbackupofarchivelog,controlfile,database,datafile,spfile,tablespace;listbackupofdatabase;-full,incremental,tablespace,datafile2.1服务器参数文件：listbackupofspfile;2.2控制文件：listbackupofcontrolfile;2.3数据文件：listbackupofdataflen

14、,n,n,n;2.4表空间：listbackupoftablespacetablespace_name;-表空间对应的backup2.5归档日志：listbackupofarchivelogall,from,high,like,logseq,low,sen,sequenee,time,until;listbackupofarchivelogall;listbackupofarchiveloguntiltimesysdate-1;listbackupofarchivelogfromsequenee10;listbackupofarchiveloguntilsequenee10;listbacku

15、pofarchivelogfromsen10000;listbackupofarchiveloguntilsen200000;listarchivelogfromsen1000;listarchiveloguntilsen2000;listarchivelogfromsequenee10;listarchiveloguntilsequenee12;二、report常用命令总结备忘report用于判断数据库当前可恢复状态、以及数据库已有备份的信息。最常使用的是reportobsolete;reportschema;reportdevice,need,obsolete,schema,unrecov

16、erablereportschema;reportobsolete;reportunrecoverable;reportneedbackup;reportneedbackupdays=3;-报告最近3天内没有备份的文件reportneedbackupredundancy=3;-报告冗余次数小于3的数据文件。reportneedbackuprecoverywindowof2days;reportschema;-报告数据库模式reportobsolete;-报告已丢弃的备份集（配置了保留策略）。reportunrecoverable;-报告当前数据库中不可恢复的数据文件（即没有这个数据文件的备份、

17、或者该数据文件的备份已经过期）reportneedbackup;-报告需要备份的数据文件（根据条件不同）reportneedbackupdays=3;-最近三天没有备份的数据文件（如果出问题的话，这些数据文件将需要最近3天的归档日志才能恢复）reportneedbackupincremental=3;-需要多少个增量备份文件才能恢复的数据文件。（如果出问题，这些数据文件将需要3个增量备份才能恢复）reportneedbackupredundancy=3;-报告出冗余次数小于3的数据文件-例如数据文件中包含2个数据文件system01.dbf和users01.dbf.-在3次或都3次以上备份中都

18、包含system01.dbf这个数据文件，而users01.dbf则小于3次-那么，报告出来的数据文件就是users01.dbf-即，报告出数据库中冗余次数小于n的数据文件reportneedbackuprecoverywindowof2days;-报告出恢复需要2天归档日志的数据文件三、backup常用命令总结备忘1. 设置备份标记backupdatabasetag=full_bak1;注：每个标记必须唯一，相同的标记可以用于多个备份只还原最新的备份。2. 设置备份集大小（一次备份的所有结果为一个备份集，要注意备份集大小）backupdatabasemaxsetsize=100mtag=da

19、tafile1;注：maxsetsize限定备份集的大小。所以必须大于数据库总数据文件的大小，否则会报错。RMAN-06183:datafileordatafilecopylargerthanMAXSETSIZE:file#1/data/oradata/system01.dbf3. 设置备份片大小（磁带或文件系统限制）runallocatechannelcltypediskmaxpicecsize100mformat7data/backup/full_0_%U_%T：backupdatabasetag=full_O：releasechannelc1;可以在allocate子句中设定每个备份片的

20、大小，以达到磁带或系统限制。也可以在configure中设置备份片大小。Configurechanneldevicetypediskmaxpiecesize100m;configurechanneldevicetypediskclear;4备份集的保存策略backupdatabasekeepforever;-永久保留备份文件backupdatabasekeepuntiltime=sysdate+30：-保存备份30天5. 重写configureexclude命令backupdatabasnoexcludekeepforevertag=testbackup;6. 检查数据库错误backupval

21、idatedatabase;使用RMAN来扫描数据库的物理/逻辑错误，并不执行实际备份。7. 跳过脱机，不可存取或只读文件backupdatabaseskipreadonly;backupdatabaseskipoffline;backupdatabaseskipinaccessible;backupdatabaseskipreadonlyskipofflineskipinaccessible;8. 强制备份backupdatabaseforce;9. 基于上次备份时间备份数据文件1只备份添加的新数据文件backupdatabasenotbackedup;2备份在限定时间周期内”没有被备份的数

22、据文件backupdatabasenotbackedupsincetime=sysdate-2;10. 备份操作期间检查逻辑错误backupchecklogicaldatabase;backupvalidatechecklogicaldatabase;11. 生成备份副本backupdatabasecopies=2;12. 备份控制文件backupdatabasedevicetypediskincludcurrentcontrolfile;四、configure常用命令总结备忘4.1显示当前的配置信息RMANshowall;RMAN配置参数为：CONFIGURERETENTIONPOLICYT

23、OREDUNDANCY1;#defaultCONFIGUREBACKUPOPTIMIZATIONOFF;#defaultCONFIGUREDEFAULTDEVICETYPETODISK;#defaultCONFIGURECONTROLFILEAUTOBACKUPOFF;#defaultCONFIGURECONTROLFILEAUTOBACKUPFORMATFORDEVICETYPEDISKTO%F;#defaultCONFIGUREDEVICETYPEDISKPARALLELISM1BACKUPTYPETOBACKUPSET;#defaultCONFIGUREDATAFILEBACKUPCOP

24、IESFORDEVICETYPEDISKTO1;#defaultCONFIGUREARCHIVELOGBACKUPCOPIESFORDEVICETYPEDISKTO1;#defaultCONFIGUREMAXSETSIZETOUNLIMITED;#defaultCONFIGUREENCRYPTIONFORDATABASEOFF;#defaultCONFIGUREENCRYPTIONALGORITHMAES128;#defaultCONFIGUREARCHIVELOGDELETIONPOLICYTONONE;#defaultCONFIGURESNAPSHOTCONTROLFILENAMETOD:

25、/ORACLE/PRODUCT/1O.2.O/DB_1/DATABASE/SNCFDBA.ORA;#default4.1.2查询RMAN设置中非默认值：SQLselectname,valuefromv$rman_configuration;4.2.常用的configure选项4.2.1 保存策略(retentionpolicy)configureretentionpolicytorecoverywindowof7days;configureretentionpolicytoredundancy5;configureretentionpolicyclear;CONFIGURERETENTIONP

26、OLICYTONONE;第一种recoverwindow是保持所有足够的备份，可以将数据库系统恢复到最近七天内的任意时刻。任何超过最近七天的数据库备份将被标记为obsolete。第二种redundancy是为了保持可以恢复的最新的5份数据库备份，任何超过最新5份的备份都将被标记为redundancy。它的默认值是1份。第三四：NONE可以把使备份保持策略失效，Clear将恢复默认的保持策略一般最安全的方法是采用第二种保持策略。4.2.2 备份优化backupoptimizationconfigurebackupoptimizationon;configurebackupoptimization

27、off;configurebackupoptimizationclear;默认值为关闭，如果打开，rman将对备份的数据文件及归档等文件进行一种优化的算法。4.2.3 默认设备defaultdevicetypeconfiguredefaultdevicetypetodisk;configuredefaultdevicetypetostb;configuredefaultdevicetypeclear;是指定所有I/O操作的设备类型是硬盘或者磁带，默认值是硬盘磁带的设置是CONFIGUREDEFAULTDEVICETYPETOSBT;控制文件controlfileconfigurecontrol

28、fileautobackupon;configurecontrolfileautobackupformatfordevicetypediskto7cfs01/backup/conf/conf_%F;configurecontrolfileautobackupclear;configruecontrolfileautobackupformatfordevicetypediskclear;configruesnapshotcontrolfilenameto7cfs01/backup/snapcf/scontrofile.snp：-是配置控制文件的快照文件的存放路径和文件名，这个快照文件是在备份期间

29、产生的，用于控制文件的读一致性。configruesnapshotcontrolfilenameclear;强制数据库在备份文件或者执行改变数据库结构的命令之后将控制文件自动备份，默认值为关闭。这样可以避免控制文件和catalog丢失后，控制文件仍然可以恢复。4.3.4 并行数（通道数）devicetypedisk|stbpallelismn;configuredevicetypedisk|stbparallelism2;configuredevicetypedisk|stbclear;-用于清除上面的信道配置configurechanneldevicetypediskformate/:rma

30、nback_%U;configurechanneldevicetypediskmaxpiecesize100mconfigurechanneldevicetypediskrate1200Kconfigurechannel1devicetypediskformate/:rmanback_%U;configurechannel2devicetypediskformate/:rmanback_%U;configurechannel1devicetypediskmaxpiecesize100m配置数据库设备类型的并行度。4.3.5 生成备份副本datafile|archivelogbackupcopi

31、esconfiguredatafilebackupcopiesfordevicetypedisk|stbto3;configurearchivelogbackupcopiesfordevicetypedisk|stbto3;-是设置数据库的归档日志的存放设备类型configuredatafile|archivelogbackupcopiesfordevicetypedisk|stbclearBACKUPDEVICETYPEDISKDATABASEFORMAT7disk1/backup/%U,7disk2/backup/%U,7disk3/backup/%U：是配置数据库的每次备份的copy数量

32、，oracle的每一次备份都可以有多份完全相同的拷贝。4.3.7排除选项excludeconfigureexcludefortablespaceusers;configrueexcludeclear;此命令用于将指定的表空间不备份到备份集中，此命令对只读表空间是非常有用的。4.3.8备份集大小maxsetsizeconfiguremaxsetsizeto1G|1000M|1000000K|unlimited;configuremaxsetsizeclear;4.3.9其它选项auxiliaryCONFIGUREAUXNAMEFORDATAFILE1TO7oracle/auxfiles/aux_

33、1f;CONFIGUREAUXNAMEFORDATAFILE2TO7oracle/auxfiles/aux_2f;CONFIGUREAUXNAMEFORDATAFILE3TO7oracle/auxfiles/aux_3f;CONFIGUREAUXNAMEFORDATAFILE4TO7oracle/auxfiles/aux_4f;CONFIGUREAUXNAMEFORDATAFILE1CLEAR;CONFIGUREAUXNAMEFORDATAFILE2CLEAR;CONFIGUREAUXNAMEFORDATAFILE3CLEAR;CONFIGUREAUXNAMEFORDATAFILE4CLEAR

34、;五、delete命令删除相关的备份集或镜像副本的物理文件，同时将删除标记DELETE更新到控制文件,如果使用恢复目录，则是清除恢复目录内的备份集。RMANdeletebackupset;RMANdeletebackupsetn;RMANdeleteobsolete;RMANdeleteobsoleteredundancy2;RMANdeletenopromptcopy;RMANdeletenopromptbackupsettagTAG20101016T143521;RMANdeleteobsoleterecoverywindowof7days;RMANdeleteexpiredbackups

35、et;RMANdeleteexpiredcopy;RMANdeleteexpiredarchivelogall;RMANdeletearchiveloguntiltimesysdate-5;六、crosscheck命令用于检验存储仓库中的备份集或镜像副本，执行改命令后，将更新存储仓库中的刚刚校验的对象状态，便于后续操作处理。RMAN备份校验是的几种状态：Expired:对象不存在于磁盘或磁带。当一个备份集处于expired状态，则该备份集中所有的备份片同样处于expired状态。Available:对象处于可用状态。当一个备份集可用，则改备份集内的所有备份片同样可用。Unavailable:对

36、象处于不可用状态。当一个备份可不用，则改备份集内的所有备份片同样不可用RMANcrosscheckbackupset;RMANcrosscheckcopy；RMANcrosscheckbackupofcontrolfile;RMANcrosscheckbackupofarchivelogall;RMANcrosscheckbackupofdatafile1,2;RMANcrosscheckbackupoftablespacesysaux,system;RMANcrosscheckbackupcompletedbetween13-OCT-10and23-OCT-10：RMANcrosscheck

37、backupset1067,1068;第二部分rman备份实战仓U建catalog1:创建用户和表空间并授权SQLCREATETABLESPACEmanDATAFILE7u01/oracle/oradata/orcl/rman01.dbfsize5MAUTOEXTENDONNEXT5MMAXSIZE500MEXTENTMANAGEMENTLOCAL;SQLCREATEUSERRMANIDENTIFIEDBYrmanTEMPORARYTABLESPACEempDEFAULTTABLESPACErmanQUOTAUNLIMITEDONrman;SQLGRANTRECOVERY_CATALOG_OW

38、NERTOrman;SQLconnrman/rmanConnected.SQLselectcount(*)fromuser_objects;COUNT(*)SQL2:创建恢复目录oracledata-1-2$rmancatalogrman/rmanorclRecoveryManager:Release10.2.0.1.0-ProductiononFriMay2006:22:312016Copyright(c)1982,2005,Oracle.Allrightsreserved.connectedtorecoverycatalogdatabaseRMANCREATECATALOG;recover

39、ycatalogcreatedRMANexitSQLconnrman/rmanConnected.SQLselectcount(*)fromuser_objects;COUNT(*)195SQL3:连接,注册target数据库，同步catalog和控制文件修改target数据库的tnsnames.ora加入标黄的那一段File:File:oracledirector$cat/u01/oracle/10g/network/admin/tnsnames.oratnsnames.oraNetworkConfiguration/u01/oracle/10g/network/admin/tnsnames

40、.oraGeneratedbyOracleconfigurationtools.TestDB=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.48.137)(PORT1521)(CONNECTDATA=(SERVER=DEDICATED)(SERVICE_NAME=TestDB)ORCL=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.48.133)(PORT=1521)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orci)oracledire

41、ctor$oracledirectoradmin$rmantarget/catalogrman/rmanorcl(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orci)oracledirector$oracledirectoradmin$rmantarget/catalogrman/rmanorclRecoveryManager:Release10.2.0.1.0-ProductiononFriMay2009:31:142016Copyright(c)1982,2005,Oracle.Allrightsreserved.connectedtotar

42、getdatabase:TESTDB(DBID=2695394133)connectedtorecoverycatalogdatabaseRMANRMANREGISTERDATABASE;databaseregisteredinrecoverycatalogstartingfullresyncofrecoverycatalogfullresynccompleteRMANRMANRESYNCCATALOG;startingfullresyncofrecoverycatalogfullresynccompleteRMANRMANLISTINCARNATION;ListofDatabaseIncar

43、nationsDBKeyIncKeyDBNameDBIDDBKeyIncKeyDBNameDBIDSTATUSResetSCNResetTimeTESTDB2695394133TESTDB2695394133PARENT44607515-MAY-16TESTDB2695394133CURRENT576891117-MAY-16an的0级增量备份和1级增量备份Rman的备份信息除了在catalog里面有，在控制文件里面也存在一份Cd/u01/oracle/oradata/TestDBoracledirectorTestDB$stringscontrol01.ctlCatalog数据库里面有没有呢

44、？SQLselect*fromRC_BACKUP_CONTROLFILE_DETAILS;真正开始一个零级备份RMANbackupincrementallevel0database;Startingbackupat20-MAY-16allocatedchannel:ORA_DISK_1channelORA_DISK_1:sid=141devtype=DISKchannelORA_DISK_1:startingincrementallevel0datafilebackupsetchannelORA_DISK_1:specifyingdatafile(s)inbackupsetinputdataf

45、ilefno=00001name=/u01/oracle/oradata/TestDB/system01.dbfinputdatafilefno=00003name=/u01/oracle/oradata/TestDB/sysaux01.dbfinputdatafilefno=00002name=/u01/oracle/oradata/TestDB/undotbsOl.dbfinputdatafilefno=00004name=/u01/oracle/oradata/TestDB/users01.dbfchannelORA_DISK_1:startingpiece1at20-MAY-16cha

46、nnelORA_DISK_1:finishedpiece1at20-MAY-16piecehandle=/u01/oracle/flash_recovery_area/TESTDB/backupset/2016_05_20/o1_mf_nnnd0_TAG20160520T230822_cmzn96sl_.bkptag=TAG20160520T230822comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:00:45Finishedbackupat20-MAY-16StartingControlFileandSPFILEA

47、utobackupat20-MAY-16piecehandle=/u01/oracle/flash_recovery_area/TESTDB/autobackup/2016_05_20/o1_mf_s_912380949_cmznbprw_.bkpcomment=NONEFinishedControlFileandSPFILEAutobackupat20-MAY-16RMAN再来个一级增量备份RMANbackupincrementallevel1database;Startingbackupat20-MAY-16usingchannelORA_DISK_1channelORA_DISK_1:s

48、tartingincrementallevel1datafilebackupsetchannelORA_DISK_1:specifyingdatafile(s)inbackupsetinputdatafilefno=00001name=/u01/oracle/oradata/TestDB/system01.dbfinputdatafilefno=00003name=/u01/oracle/oradata/TestDB/sysaux01.dbfinputdatafilefno=00002name=/u01/oracle/oradata/TestDB/undotbsOl.dbfinputdataf

49、ilefno=00004name=/u01/oracle/oradata/TestDB/users01.dbfchannelORA_DISK_1:startingpiece1at20-MAY-16channelORA_DISK_1:finishedpiece1at20-MAY-16piecehandle=/u01/oracle/flash_recovery_area/TESTDB/backupset/2016_05_20/o1_mf_nnnd1_TAG20160520T231848_cmznwsOI_.bkptag=TAG20160520T231848comment=NONEchannelOR

50、A_DISK_1:backupsetcomplete,elapsedtime:00:00:26Finishedbackupat20-MAY-16StartingControlFileandSPFILEAutobackupat20-MAY-16piecehandle=/u01/oracle/flash_recovery_area/TESTDB/autobackup/2016_05_20/o1_mf_s_912381554_cmznxm2n_.bkpcomment=NONEFinishedControlFileandSPFILEAutobackupat20-MAY-16RMANlistbackup

51、set;比较一下RMANlistbackupset;ListofBackupSetsBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime44Full535.83MDISK00:00:5220-MAY-16BPKey:45Status:AVAILABLECompressed:NOTag:TAG20160520T095248PieceName:/u01/oracle/flash_recovery_area/TESTDB/backupset/2016_05_20/o1_mf_nnndf_TAG20160520T095248_cmy5okm6_.bkpL

52、istofDatafilesinbackupset44FileLVTypeCkpSCNCkpTimeName1234Full63618820-MAY-16/u01/oracle/oradata/TestDB/system01.dbfFull63618820-MAY-16/u01/oracle/oradata/TestDB/undotbs01.dbfFull63618820-MAY-16/u01/oracle/oradata/TestDB/sysaux01.dbfFull63618820-MAY-16/u01/oracle/oradata/TestDB/users01.dbfBSKeyTypeL

53、VSizeBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTimeBPKey:61Status:AVAILABLECompressed:NOTag:TAG20160520T09534656Full7.11MDISK56Full7.11MDISK00:00:0120-MAY-16PieceName:/u01/oracle/flash_recovery_area/TESTDB/autobackup/2016_05_20/o1_mf_s_912333226_cmy5qbqk_.bkpControlFileIncluded:CkpSCN:636215Ckpt

54、ime:20-MAY-16SPFILEIncluded:Modificationtime:17-MAY-16BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime106Incr0538.92MDISK00:00:4320-MAY-16BPKey:109Status:AVAILABLECompressed:NOTag:TAG20160520T230822PieceName:/u01/oracle/flash_recovery_area/TESTDB/backupset/2016_05_20/o1_mf_nnnd0_TAG20160520T230822

55、_cmzn96sl_.bkpListofDatafilesinbackupset106FileLVTypeCkpSCNCkpTimeName10Incr66132020Incr66132030Incr66132040Incr661320BSKeyTypeLVSize20-MAY-16/u01/oracle/oradata/TestDB/system01.dbf20-MAY-16/u01/oracle/oradata/TestDB/undotbs01.dbf20-MAY-16/u01/oracle/oradata/TestDB/sysaux01.dbf20-MAY-16/u01/oracle/o

56、radata/TestDB/users01.dbfDeviceTypeElapsedTimeCompletionTime118Full7.11MDISK00:00:0220-MAY-16BPKey:123Status:AVAILABLECompressed:NOTag:TAG20160520T230909PieceName:/u01/oracle/flash_recovery_area/TESTDB/autobackup/2016_05_20/o1_mf_s_912380949_cmznbprw_.bkpControlFileIncluded:CkpSCN:661349Ckptime:20-M

57、AY-16SPFILEIncluded:Modificationtime:17-MAY-16BSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime136Incr1600.00KDISK00:00:1820-MAY-16BPKey:139Status:AVAILABLECompressed:NOTag:TAG20160520T231848PieceName:/u01/oracle/flash_recovery_area/TESTDB/backupset/2016_05_20/o1_mf_nnnd1_TAG20160520T231848_cmznws0

58、l_.bkpListofDatafilesinbackupset136FileLVTypeCkpSCNCkpTimeName1Incr6617581Incr66175820-MAY-16/u01/oracle/oradata/TestDB/system01.dbf20-MAY-16/u01/oracle/oradata/TestDB/undotbs01.dbfRMANbackupincrementallevel1databaseplusarchivelogdeleteallinput;对比上面的备份我们已经备份了如下内容数据文件控制文件参数文件口令文件不用备份还差重做日志文件归档日志文件没备份

59、redolog无法备份Archivelog的备份RMANbackupdatabasedatabaseplusarchivelogdeleteallinput;1Incr6617581Incr66175820-MAY-16/u01/oracle/oradata/TestDB/sysaux01.dbf41Incr66175820-MAY-16/u01/oracle/oradata/TestDB/users01.dbfBSKeyTypeLVSizeDeviceTypeElapsedTimeCompletionTime150Full7.11MDISK00:00:0120-MAY-16BPKey:155

60、Status:AVAILABLECompressed:NOTag:TAG20160520T231914PieceName:/u01/oracle/flash_recovery_area/TESTDB/autobackup/2016_05_20/o1_mf_s_912381554_cmznxm2n_.bkpControlFileIncluded:CkpSCN:661778Ckptime:20-MAY-16SPFILEIncluded:Modificationtime:17-MAY-16RMAN现在看看oracle的体系结构图基本组件概览1RUER口令文件腹务器进程日志文件BOBAcoStarti

61、ngbackupat21-MAY-16currentlogarchivedusingchannelORA_DISK_1channelORA_DISK_1:startingarchivelogbackupsetchannelORA_DISK_1:specifyingarchivelog(s)inbackupsetinputarchivelogthread=1sequence=1recid=1stamp=912070064inputarchivelogthread=1sequence=2recid=2stamp=912071208inputarchivelogthread=1sequence=3r

62、ecid=3stamp=912071337inputarchivelogthread=1sequence=4recid=4stamp=912071361inputarchivelogthread=1sequence=5recid=5stamp=912315146inputarchivelogthread=1sequence=6recid=6stamp=912315175inputarchivelogthread=1sequence=7recid=7stamp=912384029channelORA_DISK_1:startingpiece1at21-MAY-16channelORA_DISK_

63、1:finishedpiece1at21-MAY-16piecehandle=/u01/oracle/flash_recovery_area/TESTDB/backupset/2016_05_21/o1_mf_annnn_TAG20160521T000030_cmzqc001_.bkptag=TAG20160521T000030comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:00:03channelORA_DISK_1:deletingarchivelog(s)archivelogfilename=/u01/oracle/flash_recovery_area/TESTDB/archivelog/2016_