ORACLE教程DBA_Les06_backup

《ORACLE教程DBA_Les06_backup》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、RMANBackupsObjectivesAftercompletingthislesson,youshouldbeabletodothefollowing:IdentifytypesofRMANspecificbackupsUsetheRMANBACKUPcommandtocreatebackupsetsBackupthecontrolfileBackupthethearchivedredologfilesUsetheRMANCOPYcommandtocreateimagecopiesRMANBackupC

2、onceptsRecoveryManagerbackupisaserver-managedbackupRecoveryManagerusesOracleserversessionsforbackupoperationsIncludesdatabase,tablespaces,datafiles,controlfiles,archivedredologfilesCloseddatabasebackupTargetdatabasemustbemounted(notopen)Includesdatafiles,co

3、ntrolfiles,archivedredologfilesOpendatabasebackupTablespacesshouldnotbeputinbackupmodeIncludesdatafiles,controlfiles,archivedredologfilesArchivedLogfileDatafile3RecoveryManagerBackupsCopyofdatafile3CopyofarchivedlogImagecopyBackupsetBackupset1Backupset2Ba

4、ckupset3Datafile1Datafile2Datafile3Datafile4ControlfileDatafile4ControlfileDatafile1Datafile2Datafile3Datafile3ArchivedLogfileControlfileControlfileCopyofcontrolfileBackupSetsBackupset1Backupset2Backupset3Datafile1Datafile2Datafile3Datafile4Controlfi

5、leDatafile4ControlfileDatafile1Datafile2Datafile3CharacteristicsofBackupSetsTheBACKUPcommandcreatesbackupsets.Backupsetsusuallycontainmorethanonefile.Backupsetscanbewrittentoadiskortape.Arestoreoperationisrequiredtoextractfilesfromabackupset.Datafilebackup

6、setscanbeincrementalorfull.Backupsetsdonotincludenever-usedblocks.BackupPieceBackupset1(Logical)Piece2(file)Piece1(file)Datafile1Datafile4Datafile5Piece1(file)Datafile2Datafile3Datafile9Backupset2(Logical)Abackuppieceisafileinabackupset.Abackuppiececanconta

7、inblocksfrommorethanonedatafile.Tape1Tape2Serverprocess(channel)MMLServerprocess(channel)MMLTheBACKUPCommandRMAN>BACKUP2>FORMAT'/BACKUP/df_%d_%s_%p.bus'3>DATABASEfilesperset=2;Backupset1Backupset2Backupset3Datafile1Datafile2Datafile3Datafile4Contro

8、lfileDatafile4ControlfileDatafile1Datafile2Datafile3BackupPieceSizeBackuppiecesizecanbelimitedasfollows:RMAN>RUN{2>ALLOCATECHANNELt1TYPE'SBT_TAPE'3>MAXPIECESIZE=4G;4>BACKUP5>FORMAT'df_%t_%s_%p'FILESP