Advertisement
1 / 28

SQL-BackTrack for Sybase PowerPoint PPT Presentation


  • 86 Views
  • Uploaded on 22-05-2013
  • Presentation posted in: General

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. - PowerPoint PPT Presentation

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Sql backtrack for sybase

SQL-BackTrack for Sybase

高正宗

System Consultant Manager

黃仁政

System Consultant


Agenda

Agenda

  • 資料庫的可用性

  • 系統架構

  • 產品功能說明

  • 實機展示

  • 產品比較


Sql backtrack for sybase

資料可用性的策略

Switchingand WarmStandbyReplication

ColdStandby

DisasterRecovery

Catastrophic

HighAvailabilityClusters

HighAvailability

Unplanned

Severity of Database Downtime

OfflineMaintenance

Planned

OnlineMaintenance

No Downtime

ContinuousAvailability

Latency of Database Recovery


Sql backtrack for sybase

復原作業的問題

  • 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


Sql backtrack for sybase

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!


Why sql backtrack an example of a recovery of a sybase database using the native utility

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


Why sql backtrack an example of a recovery of a sybase database using the native utility1

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!!


Agenda1

Agenda

  • 資料庫的可用性

  • 系統架構

  • 產品功能說明

  • 實機展示

  • 產品比較


Sql backtrack for sybase

備份作業


Sql backtrack for sybase

復原作業


Sql backtrack for sybase

OBSI模組整合

ASE

Tape

Devices

SQL-BackTrack

Server

Program

Juke

Boxes

BT Module

Media/ Client Program

  • IBM Tivoli Storage Manager

  • VERITAS NetBackup DataCenter

  • Legato NetWorker


Sql backtrack for sybase

OBSI模組整合


Agenda2

Agenda

  • 資料庫的可用性

  • 系統架構

  • 產品功能說明

  • 實機展示

  • 產品比較


Common sql backtrack features

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


Unique sql backtrack features for sybase

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.)


Unique sql backtrack features over sybase native utilities

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.


Unique sql backtrack features over sybase native utilities1

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.


Unique sql backtrack features over sybase native utilities2

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.


Agenda3

Agenda

  • 資料庫的可用性

  • 系統架構

  • 產品功能說明

  • 實機展示

  • 產品比較


Sql backtrack components

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)


Sql backtrack executables

SQL-BackTrack Executables

sbacktrack

(main BT program)

dtsbackup

dtsrecover

dtsdump

dtsload

dtscreate

dtscheck

(lower-level SQL-BackTrack programs)


Sql backtrack control directory

/usr/sbt/

sbackups.physical

sbackups.logical

Server1

Server 2

Server 1

Server 2

.dtoptions

DB1

DB2

SQL-BackTrack Control Directory


Special recovery situations

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)


Agenda4

Agenda

  • 資料庫的可用性

  • 系統架構

  • 產品功能說明

  • 實機展示

  • 產品比較


Sql backtrack for sybase vs competition

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


Sql backtrack for sybase vs competition1

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


Sql backtrack for sybase vs competition2

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


Questions and discussion

Questions and Discussion