資源描述:
《ORACLE教程DBA_Les06_backup》由會(huì)員上傳分享,免費(fèi)在線閱讀,更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫(kù)。
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