Download

SQL-BackTrack for Sybase






Advertisement
/ 28 []
Download Presentation
Comments
Leo
From:
|  
(3834) |   (0) |   (0)
Views: 65 | Added:
Rate Presentation: 0 0
Description:
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.
SQL-BackTrack for Sybase

An Image/Link below is provided (as is) to

Download Policy: Content on the Website is provided to you AS IS for your information and personal use only and may not be sold or licensed nor shared on other sites. SlideServe reserves the right to change this policy at anytime. 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 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -




Slide 1

SQL-BackTrack for Sybase

高正宗

System Consultant Manager

黃仁政

System Consultant

Slide 2

Agenda

  • 資料庫的可用性

  • 系統架構

  • 產品功能說明

  • 實機展示

  • 產品比較

Slide 3

資料可用性的策略

Switchingand WarmStandbyReplication

ColdStandby

DisasterRecovery

Catastrophic

HighAvailabilityClusters

HighAvailability

Unplanned

Severity of Database Downtime

OfflineMaintenance

Planned

OnlineMaintenance

No Downtime

ContinuousAvailability

Latency of Database Recovery

Slide 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

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

Slide 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

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

Slide 8

Agenda

  • 資料庫的可用性

  • 系統架構

  • 產品功能說明

  • 實機展示

  • 產品比較

Slide 9

備份作業

Slide 10

復原作業

Slide 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

Slide 12

OBSI模組整合

Slide 13

Agenda

  • 資料庫的可用性

  • 系統架構

  • 產品功能說明

  • 實機展示

  • 產品比較

Slide 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

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

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

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

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

Slide 19

Agenda

  • 資料庫的可用性

  • 系統架構

  • 產品功能說明

  • 實機展示

  • 產品比較

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

Slide 21

SQL-BackTrack Executables

sbacktrack

(main BT program)

dtsbackup

dtsrecover

dtsdump

dtsload

dtscreate

dtscheck

(lower-level SQL-BackTrack programs)

Slide 22

/usr/sbt/

sbackups.physical

sbackups.logical

Server1

Server 2

Server 1

Server 2

.dtoptions

DB1

DB2

SQL-BackTrack Control Directory

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

Slide 24

Agenda

  • 資料庫的可用性

  • 系統架構

  • 產品功能說明

  • 實機展示

  • 產品比較

Slide 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

Slide 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

Slide 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

Slide 28

Questions and Discussion


Copyright © 2014 SlideServe. All rights reserved | Powered By DigitalOfficePro