oracle11G备份恢复讲义

某OCP培训机构Oracle11G 备份恢复讲义。LuiseDalian讲议_BackupAndRecoveryOracle Database 11G Backup And RecoverycuuG LuiseDalian1. Purpose of Backup and recovery functionalityPurpose of Backup and Recovery FunctionalityBackup and recovery functionality is needed for the followingData protectionMedia failureUser errorsApplication errorsData preservation and historical retentionData transferORACLECopyright o 2009, Oracle. All rights reserved.3/682技术博客:htt:/ blog. itpub. net/17013648/新浪微博:htt://eibo,com/ uiseDalian QQ:1173332914Oracle Database 11G Backup And RecoverycuuG LuiseDalian1.2 Typical Backup and recovery TasksTypical Backup and Recovery TasksTo be able to recover from data loss problems with minimaldown time.Configure the database for recoverabilityDefine a backup schedulePlan and test different types of failure scenariosMonitor, tune, and troubleshoot the backup and recoveryenvironmentRestore data from backupsRecover transactions to a desired point in timeORACLEopyright o 2009, Oracle. All rights reserved4/682技术博客:htt:/ blog. itpub. net/17013648/新浪微博:htt://eibo,com/ uiseDalian QQ:1173332914Oracle Database 11G Backup And RecoverycuuG LuiseDalian1.3 Oracle Backup and Recovery SolutionsOracle Backup and recovery solutionsFor a recoverable systemRMANBlock media recoveryUnused block compressionBinary compressionBackup encryptionSolutions achieved via backup typesAll data blocks within your chosen files(full or incremental level O)Only information that has changed since a previous backup〔 incremental)Cumulative (changes up to last level ODifferential (changes up to last incremental)ORACL∈Copyright o 2009, Oracle. All rights reserved5/682技术博客:htt:/ blog. itpub. net/17013648/新浪微博:htt://eibo,com/ uiseDalian QQ:1173332914Oracle Database 11G Backup And RecoverycuuG LuiseDalian1.4 Oracle Backup SolutionsOracle Backup SolutionsRMANOSBBack up asbackup setData file 2Backupplece(filesperset 3)BackupImageData file 3BackuppleceImageData file 4Backup setFilesystemBackupfile6.ImageORACLECopyright o 2009, Oracle. All rights reserved.6/682技术博客:htt:/ blog. itpub. net/17013648/新浪微博:htt://eibo,com/ uiseDalian QQ:1173332914Oracle Database 11G Backup And RecoverycuuG LuiseDalian1.5 Terminology ReviewTerminology ReviewMatch the following terms and descriptionsbacks up a portion of the database. The control filemay or may not be includedheaders matches the SCN in the control files n data fileis a consistent backup because the SCN irbacks up each data block that contains data and thatis within the files being backed upis an inconsistent backup because there is noguarantee that the data files are synchronized with thecontrol files5includes all data files and at least one control file(W)Whole database backup() Full backup(C)Cold or offlinebackup(P)Partial database backup(O)Online backupORACL∈Copyright o 2009, Oracle. All rights reserved7/682技术博客:htt:/ blog. itpub. net/17013648/新浪微博:htt:// weibo. com/ uiseDalian QQ:173332914Oracle Database 11G Backup And RecoverycuuG LuiseDalian1.6 Terminology ReviewTerminology ReviewWhich description tits best the following backup types1. Image copies2. Backup setsDescriptionA)They are collections of one or more binary files thatcontain one or more data files control files, serverparameter files, or archived log files. Empty data blocksand currently unused blocks are not storedB)They are duplicates of data or archived log files(similar toa file copy,ORACLECopyright e 2009, Oracle. All rights reserved8/682技术博客:htt:/ blog. itpub. net/17013648/新浪微博:htt://eibo,com/ uiseDalian QQ:1173332914Oracle Database 11G Backup And RecoverycuuG LuiseDalian1.7 What You already know: Oracle-Suggested Backup(可用性>管理>调度备份)What You Already Know:Oracle- Suggested BackupHangeshe止kuphedule BackupBasad on your cisk andor t图 eomguran, Orac b prowls an autorai如km闻gy, cI you can dewvBtp your own bec ku stategy w Perm Recove④Manage Mestre Pon1o Backup Strategies Vew and Manage Treraactiono隐 ace surfs ted Bac kupCock suggestedschedule a backup using Cracks auemskd tac kup stratey y(Schedule Oracle-5uqgesled Backu4 Prows an oul-df-the-bex backup strategy basedon the叫 on wrl back up the entre士kEe. Thecate训lbacKup dilaton. opns may vary based cn UeBe backed up cn dai and weekI intalCustom bad Backu9 Sets up recoery w ndow for backup managementCacct the E yeu want k bock upSche dul Cust mized Backup)a Echad ba recurring and meck a beck p山 mae backup manarAfbA Bpecity the cbct be backed upf Arc helgea Choose dEk or tare backup italianr Allfecoyery Fibs an Dsk● CAerE theastaut keep 3onIhe aa 1esincude al anahrocas end dak ba:kpe that ars rot aroasi Shade the bakuHost credential和 m a backup, suppy operating syslm h图be旧e妞d组User ameORACLECopyright o 2009, Oracle. All rights reserved9/682技术博客:htt:/ blog. itpub. net/17013648/新浪微博:htt://eibo,com/ uiseDalian QQ:1173332914Oracle Database 11G Backup And Recoverycuug LuiseDalian创建需要的日录[oracle@hcstl yisi net: /home/oracle]s mkdir -p /u01/backup[oracleahcstl yisi net: /home/oracle]s mkdir -p /uol/backup2[oracleghcstl yisi net: /one/oracle]s mkdir -p /u01/arch destl[oracleahestl yisi net: /home/oracle]9 mkdir -p /u01/arch dest.2修改数据库的归档目的地Ys@ testdb11>alter sysrem set log archive dest 1='location=/u01/arch destl'isYsa testdb11>alter syscem set log archive dest 2='location=/uol/arch dest2'i使数据库进入到归档模式sYsa testdb11>shutdown immediate isYs@ testdb11>startup mountsYSa testdbli>alter database archivelocsYsa testdb11>alter database openi10/682技术博客:http://blogitpub.net/17013648/新浪微博http:/weibo.com/luiseDalianQq:1173332914