Commvault數(shù)據(jù)庫備份恢復(fù)功能介紹

1、數(shù)據(jù)庫備份恢復(fù)功能介紹塊級備份（Block Level Backup）MySQL、PostgreSQL塊級備份基于塊級備份表級恢復(fù)基于塊級備份Live Mount功能MySQL Enterprise Backup (MEB) Using SBT APIIntellisnap support for PostgreSQLV11新增Block Level BackupBlock Level Backup Support MatrixIntegrated into existing Commvault AgentsLinux, Unix, Windows, PostgreSQL, and MySQL

2、 available in Wave 1Other application agents coming in future wavesSupports/Enables: Full, Inc, Synth Full, IntelliSnap, Table Level, Streaming and Block Restore, Native AccessBlock Level Backup OverviewFaster backup通過追蹤更改的塊，降低scan時間；塊級數(shù)據(jù)傳輸；塊級永久增量+合成全備份；Quick granular restore表級恢復(fù)能力；Native copy acces

3、sLive Mount訪問，高效的驗證與測試；Block Level Backup Business ValueTrack blocks as they are changed; eliminate scan times on filesystemsLarge File/ApplicationTracked blocks inside datasets; eliminate reading everything to find changesBlock-level backups are supported only on Linux platforms.For block-level bac

4、kups, the supported Linux platforms must have kernel version 3.2 or earlier and glibc 2.13 or earlier.Support NotesIntelligent Table Level RecoveryTraditional ApproachCommvault Approach2: Create aux 4: Verify6: ImportImport1: Find3: RestoreBrowse5: ExportTable Level Recovery OverviewTraditionally, t

5、able recovery is a labor intensive task for DBAsCommvault automates complex recovery tasks to simplify the processEnabled at the subclient level prior to the backupWave 1 support for Oracle, DB2, PostgreSQL, MySQL, InformixFuture waves to support MS SQL, SybaseBlock Level Backup technology facilitat

6、es table level recovery for PostgreSQL and MySQL databases創(chuàng)建存儲策略添加nSnapCowSizeMB參數(shù)添加 sCVBFSNAPPART參數(shù)需要安裝的模塊：MA，Mysql /PostgreSQL，F(xiàn)S創(chuàng)建新快照拷貝在快照copy屬性-保留-選擇 啟用數(shù)據(jù)時效 假脫機拷貝子客戶端集成Option，啟用Block Level Backup表級恢復(fù)Option打開瀏覽和恢復(fù)選項，勾選表視圖（只有使用Block Level Backup才有此選項）選擇需要恢復(fù)的表在數(shù)據(jù)庫驗證數(shù)據(jù)已經(jīng)完全恢復(fù)OthersMySQL Enterprise Ba

7、ckup在商業(yè)版本中提供，內(nèi)置的備份恢復(fù)工具；在V3.6版本后, MEB product can interface with media management software (MMS) through System Backup to Tape (SBT) interface；The media management software must support Version 2 or higher of the System Backup to Tape (SBT) interface；MySQL Enterprise Backup (MEB) Using SBTCommvaultmy

8、sqldump utility;IntelliSnap Backup;BLB;MySQL Enterprise Backup Using SBT ;Veritas Netbackup無代理；MySQL Enterprise Backup Using SBT ;Zmanda Recovery Manager(ZRM),需要單獨購買;針對MySQL提供更全面的備份機制IntelliSnap Application SupportWAVE 2V11 RTMV11 RTMApplication SupportHypervisor SupportOS SupportWAVE 2WAVE 3All fut

9、ure wave releases subject to shift. Confirm requirements before discussing with clients/prospects.Oracle增強Oracle 歸檔Wave 1歸檔數(shù)據(jù)為XML 格式歸檔到相同的schema as prod歸檔預(yù)測工具（Archive Prediction Tool）Wave 2ODBC 訪問歸檔數(shù)據(jù)歸檔 table partitionsMSSQL 歸檔Oracle 歸檔流程Oracle 歸檔Oracle其它增強安全性SYSBACKUP role supportOracle Wallet supp

10、ortQcommand auth for 3rd party jobs自動日志備份支持12c Pluggable Database (PDB) 支持 “RAC Policy-Managed” databasesClone support for Pure, VMAXOracle readiness reportAgent Instance Readiness Status Oracle Agent Instance Name: NETAPPUser Account: oracle Ready.Instance user is member of Simpana install group: c

11、ommvault OKRead/Write permissions:/opt/simpana2/simpana2/Base/Temp OK/var/log/simpana2/Log_Files OK/etc/CommVaultRegistry OKDatabase status: OPEN OKRMAN SBT channel allocation: /opt/simpana2/simpana2/Base/libobk.so OKOracle Agent Instance Name: PROD01User Account: oracle Not Ready.Instance user is m

12、ember of Simpana install group: commvault OKRead/Write permissions:/opt/simpana2/simpana2/Base/Temp OK/var/log/simpana2/Log_Files OK/etc/CommVaultRegistry OKDatabase status: UNKNOWN FailedRMAN SBT channel allocation: /opt/simpana2/simpana2/Base/libobk.so FailedOracle Agent Instance Name: PROD02User

13、Account: oracle Not Ready.Instance user is member of Simpana install group: commvault OKRead/Write permissions:/opt/simpana2/simpana2/Base/Temp OK/var/log/simpana2/Log_Files OK/etc/CommVaultRegistry OKDatabase status: UNKNOWN FailedRMAN SBT channel allocation: /opt/simpana2/simpana2/Base/libobk.so F

14、ailedRoad Map OracleBlock Level BackupReplication and native accessIncremental / Synth Full supportLive SyncInstant app recoveryApp aware for VSAWave 2 and BeyondCONFIDENTIALSnap CloneAdmin console Support for HDSData masking for non-prodOracle VM hypervisor supportArchivingeBusiness SuiteDB2 ,Sybase增強DB2表級恢復(fù)Wave 1 base