Oracle数据库备份与恢复之最佳实践

VERITASSoftwareCorporationOracle••Oracle•Oracle•Oracle•Oracle?•–100-400%•–••OracleRACOracleVERITASOracleEmailWebCRMOracleVERITASOracleOracleEmailWebCRMOracleOracleOracle•––•––•––OracleOracle•VERITASNetBackup™––OracleRMAN–Oracle–RMAN––OracleOracleSBTAPINetBackupNetBackupforOracleRMANRMANOracle()1:OracleRMANNetBackupforOracle2:NetBackupforOracleNetBackup3:NetBackup4:DROracle•••OracledataarchivingXML•RMAN•RMAN•OracleRACRMAN•GUI•RMAN–RMAN–Oracle•Oracle•Oracle•••••OracleOracle•?–TB–––Oracle–•–VERITASVERITAS•(storagecheckpoints)(volumemirrors)––()InstantRecoveryNetBackupOracleNetBackup1:00pmVERITASVERITAS2:00pm3:00pmCatalogMeta-DataABCLANOracleOracleNetBackupNetBackupNetBackupNetBackupLANLAN0:000:140:280:430:571:121:261:40Time(hours)NetBackupforOracle(tape)NetBackupandInstantRecovery(Disk)FullBackupTime•SizeofOracledatabaseused:26GBNetBackupandInstantRecoverybackupstooklessthan4%ofthetimeittooktocompleteatapebasedbackup•SizeofOracledatabaseused:26GB0:000:070:140:210:280:360:430:500:571:041:12Time(hours)DatabaseTablespaceFileNetBackupforOracle(tape)NetBackupandInstantRecovery(disk)NetBackupandInstantRecoverytookfarlesstimethanittookfortapebasedrecoveryFlashSnap•Oracle–VERITASStorageFoundationforOracle––NetBackupAdvancedClient•OracleNBU•NetBackup•OracleNetBackupOracle(NetBackup)SnapshotMirrorPrimaryBlockLevelIncrementalBackup••(storagecheckpoints)–VERITASStorageFoundationforOracle•,•RMAN(ProxyCopy)•Oracle––I/O•OracleOracle•(?)–?–?–?–:••••Oracle•Oracle–?–?–?Oracle•–Oracle?–Oracle?–“”Oracle?Oracle••RMAN•–•––••Oracle•Oracle/–Oracle–Oracle•Oracle––(Vaulting)•Oracle––ANSWERSQUESTIONSCopyright©2004VERITASSoftwareCorporation.Allrightsreserved.VERITAS,theVERITASlogo,andallotherVERITASproductnamesandslogansaretrademarksorregisteredtrademarksofVERITASSoftwareCorporation.VERITASandtheVERITASLogoReg.U.S.Pat.&TmOff.Otherproductnamesand/orslogansmentionedhereinmaybetrademarksorregisteredtrademarksoftheirrespectivecompanies.