1 / 28

SQL-BackTrack for Sybase

SQL-BackTrack for Sybase. 高正宗 System Consultant Manager 黃仁政 System Consultant. Agenda. 資料庫的可用性 系統架構 產品功能說明 實機展示 產品比較. 資料可用性的策略. Switching and Warm Standby Replication. Cold Standby. Disaster Recovery. Catastrophic. High Availability Clusters. High Availability. Unplanned.

Leo
Download Presentation

SQL-BackTrack for Sybase

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL-BackTrack for Sybase 高正宗 System Consultant Manager 黃仁政 System Consultant

  2. Agenda • 資料庫的可用性 • 系統架構 • 產品功能說明 • 實機展示 • 產品比較

  3. 資料可用性的策略 Switchingand WarmStandbyReplication ColdStandby DisasterRecovery Catastrophic HighAvailabilityClusters HighAvailability Unplanned Severity of Database Downtime OfflineMaintenance Planned OnlineMaintenance No Downtime ContinuousAvailability Latency of Database Recovery

  4. 復原作業的問題 • 80% of all unplanned downtime is caused by software or human error* • 70% of recovery is "think time"! *Source: Gartner, “Aftermath: Disaster Recovery”, Vic Wheatman, September 21, 2001

  5. Restore Analysis Preparation Source Copies backup data to the correct destination Issues the appropriate command in the correct sequence Issues the appropriate commands needed to prepare the database for the recovery process Perform appropriate post-recovery clean-up processes Investigate data loss/ corruption and discover what information must be replaced Identify location of and retrieve backup data Recover Post-op 確保復原作業 SQL-BackTrack automates the entire process!

  6. Determine which database to recover Determine where backups are located If the backups are striped locate all the stripes Order the backups in the required sequence to be applied. Determine the recovery type: physical, transaction log , is there a specific point in time for the recovery If it is a point in time recovery determine the transaction log backups to be applied. Start an isql session Issue load database Issue load transaction for all the transaction log backups If the recovery is PIT issue load transaction with until_time Issue online database or online for standby access Determine if the database and application are ready for production use. Why SQL-BackTrack? An example of a recovery of a Sybase database using the native utility

  7. Determine which database to recover Determine where backups are located If the backups are striped locate all the stripes Order the backups in the required sequence to be applied. Determine the recovery type: physical, transaction log , is there a specific point in time for the recovery If it is a point in time recovery determine the transaction log backups to be applied. Start an isql session Issue load database Issue load transaction for all the transaction log backups If the recovery is PIT issue load transaction with until_time Issue online database or online for standby access Determine if the database and application are ready for production use. Why SQL-BackTrack? An example of a recovery of a Sybase database using the native utility SQL-BackTrackreduces this effort to 2 STEPS!!

  8. Agenda • 資料庫的可用性 • 系統架構 • 產品功能說明 • 實機展示 • 產品比較

  9. 備份作業

  10. 復原作業

  11. OBSI模組整合 ASE Tape Devices SQL-BackTrack Server Program Juke Boxes BT Module Media/ Client Program • IBM Tivoli Storage Manager • VERITAS NetBackup DataCenter • Legato NetWorker

  12. OBSI模組整合

  13. Agenda • 資料庫的可用性 • 系統架構 • 產品功能說明 • 實機展示 • 產品比較

  14. Common SQL-BackTrack Features • Dry run backup and recovery • Table recovery from physical backup • Unattended on-line and off-line backup • Incremental backups • Compression and encryption • Storage management integration • Guided recovery

  15. Unique SQL-BackTrack Features for Sybase • Master database recovery • Needs to be rebuilt, if lost or damaged • Generates Master Database Recovery template script to recover • Remote administration • Warm stand-by server support • Table level recovery includes recovery of dependent objects (triggers, etc.)

  16. Unique SQL-BackTrack Features over Sybase Native Utilities • Logical Object extraction features: • DDL Only • DDL + Data • Specific objects or object types like: stored procedures only or tables only … • Will add objects to database in dependency order. For instance, will compile stored procedures into database in dependency order. • Can exclude specific objects like: exclude sysusers, sysalternates tables when copying database to another server. Or you can exclude a type of object like exclude all triggers. • Extract/restore database object and all of it’s dependent objects • Default is fast bcp in, unless told to do otherwise. Automatically takes care of rebuilding indexes.

  17. Unique SQL-BackTrack Features over Sybase Native Utilities • Logical restore options make shrinking your database much easier. 1 step - do a logical restore to a smaller database. • Warm Stand-by Server Support • Master database info, writes a text file of useful information about the master database such as device, configuration, database, sysusages, and syslogin information taken from a physical backup. Very useful in recovering the master database.

  18. Unique SQL-BackTrack Features over Sybase Native Utilities • Can restore data to a database using full sql insert statements -- useful if “select into/bulk copy” option is turned off • Can restore data to a different segment. Useful if you want to eliminate segments or move data from one segment to another • Prints database allocation info. (sysusages) from a physical backup. Useful if you have to manually recreate the database. • Supports calling SQL-BackTrack log dump commands from a stored procedure. Useful for thresholds.

  19. Agenda • 資料庫的可用性 • 系統架構 • 產品功能說明 • 實機展示 • 產品比較

  20. OBSI Software Backup device OBSI Software Backup device OBSI Software Backup device SQL Server SQL Server SQL Server SQL-BackTrack Components SQL-BackTrack Control Directory (with Control Files) .dtoptions file .dtoptions file .dtoptions file sbacktrack Executables (main BT program)

  21. SQL-BackTrack Executables sbacktrack (main BT program) dtsbackup dtsrecover dtsdump dtsload dtscreate dtscheck (lower-level SQL-BackTrack programs)

  22. /usr/sbt/ sbackups.physical sbackups.logical Server1 Server 2 Server 1 Server 2 .dtoptions DB1 DB2 SQL-BackTrack Control Directory

  23. Special Recovery Situations • Copying a database to a different machine / Migrating a database • Object extraction from physical backups • Resizing a database • Generating recovery templates(Master)

  24. Agenda • 資料庫的可用性 • 系統架構 • 產品功能說明 • 實機展示 • 產品比較

  25. SQL-BackTrack for Sybase vs Competition • Function • SBT • ASE 12.0/ 12.5 • Extensions (VERITAS & Legato) • Comments • Physical database backup (full) • YES • YES YES • Physical database backup (Incremental) • YES • NO NO SBT’s intelligent incremental backup feature writes only physical data blocks that have changed since last backup • Transaction Log Backup Automation • YES • Limited • Limited • ASE and extension are limited to scripts. SBT obtains relevant logs at backup time automatically. • Logical database backup • YES • NO • NO • Logical object backup • YES • Limited • Limited • ASE and extensions will only migrate data. SBT backups up table schema, dependencies, and data. (SBT unique) • Logical object recovery from a physical backup • YES • NO • NO • SBT’s Logical Extraction feature can recover tables, stored procedures, triggers, etc. directly from a physical backup Unique/noteworthy feature

  26. SQL-BackTrack for Sybase vs Competition • Function • SBT • ASE 12.0/ 12.5 • Extensions (VERITAS & Legato) • Comments • Recover to alternate host, database • YES • NO • NO • SBT allows users to recover information to alternate locations (Powerful DR support tool) • Dry Run Recovery • YES • NO • NO • Automation • YES • Limited • Limited ASE automation limited to commands included in scripts created by DBA. Extensions allow ASE scripts to be scheduled for execution. SBT provides guided recovery to automate backup & recovery as well as generate scripts automatically for use in scheduler. • Migration • YES • Limited Limited ASE (BCP utility) and extensions will logically backup data but not schema and is limited to environments with same OS and ASE levels. SBT will migrate data between differing ASE and OS versions as well as between varying database page sizes. Unique/noteworthy feature

  27. SQL-BackTrack for Sybase vs Competition • Function • SBT • ASE 12.0/ 12.5 • Extensions (VERITAS & Legato) • Comments • Master Database Recovery Template • YES • Limited • Limited • Master Database recovery is a tedious, manual process. SBT greatly simplifies process by generating template with relevant information in support of recovery. • Encryption • YES • NO • NO • SBT can recover tables, stored procedures, triggers, etc. directly from a physical backup • Storage Manager Integration • YES • NO • Limited • Extensions provide vendor specific support. SBT Modules provide seamless integration with IBM Tivoli Storage Manager (TSM), VERITAS NetBackup DataCenter, and Legato NetWorker Unique/noteworthy feature

  28. Questions and Discussion

More Related