> CommCell Console > Backup and Restore Agents > Databases > Sybase > Sybase Restores > Restoring to a Disk (App Free Restore)

Recovering the Database after a Restore

The dump files associated with a backup job will restored to a disk in the following format:

<BACKUP-JOB-ID>-<DATABASE-NAME>-<TOTAL-NO-OF-STRIPES>-<DB/XACT>-<TIME-STAMP>-<STRIPE-NUMBER>.

Example 1: Database dump files associated with database db1 and backup job 1989. Backup job 1989 was performed with 4 streams, hence you will see 4 files. 

1989-db1-4.DB.130212185252553.00
 1989-db1-4.DB.130212185252553.01
 1989-db1-4.DB.130212185252553.02
 1989-db1-4.DB.130212185252553.03

Example 2: Transaction dump files associated with database db1 and transaction log backup job 2140. Backup job 2140 was performed with 3 streams, hence you will see 3 files.

2140-db1-3.XACT.130221194903420.00
 2140-db1-3.XACT.130221194903420.01
 2140-db1-3.XACT.130221194903420.02

A restore script will be auto generated by Commvault for each database and for each backup job.

Restore script file format will be as follows:

<BACKUP-JOB-ID>-<DATABASE-NAME>.sql

Format for database restore script is as follows:

load database DATABASE-NAME  from “SybGalaxy:: -disk FIRST-STRIPE-DUMP-FILE-PATH ” stripe on “SybGalaxy:: -disk SECOND-STRIPE-DUMP-FILE-PATH ” ...........

Format for database recovery script is as follows:

load transaction DATABASE-NAME  from “SybGalaxy:: -disk FIRST-STRIPE-DUMP-FILE-PATH ” stripe on “SybGalaxy:: -disk SECOND-STRIPE-DUMP-FILE-PATH ” ...........

Example 1:

Script file name for database db1 job ID 1989(Database backup) is 1989--db1.sql

Script file content:

load database db1 from "SybGalaxy:: -disk /MyAppFreeRestore/2141/1989-db1-4.DB.130212185252553.00" stripe on "SybGalaxy:: -disk /MyAppFreeRestore/2141/1989-db1-4.DB.130212185252553.01" stripe on "SybGalaxy:: -disk /MyAppFreeRestore/2141/1989-db1-4.DB.130212185252553.02" stripe on "SybGalaxy:: -disk /MyAppFreeRestore/2141/1989-db1-4.DB.130212185252553.03"

Example 2:

Script file name for database db1 job ID 2140(Transaction log backup) is 2140—db1.sql

Script file content:

load transaction db1 from "SybGalaxy:: -disk /MyAppFreeRestore/2141/2140-db1-3.XACT.130221194903420.00" stripe on "SybGalaxy:: -disk /MyAppFreeRestore/2141/2140-db1-3.XACT.130221194903420.01"
 stripe on "SybGalaxy:: -disk /MyAppFreeRestore/2141/2140-db1-3.XACT.130221194903420.02"
 go

Connect to Sybase ASE server and execute the following restore script to restore/recover the database:

isql –U username –P password –S ServerName -i script_name.sql

Example : 

Execute restore script [root@localhost 2141]# isql -Usa -Padmin123 -SybGalaxy -i script_name.sql
 3> go
 Backup Server session id is: 60. Use this value when executing the
 'sp_volchanged' system stored procedure after fulfilling any volume change
 request from the Backup Server.
 Backup Server: 4.132.1.1: Attempting to open byte stream device: 'SybGalaxy::
 -disk /MyAppFreeRestore/2141/1989-db1-4.DB.130212185252553.00::00'
 Backup Server: 4.132.1.1: Attempting to open byte stream device: 'SybGalaxy::
 -disk /MyAppFreeRestore/2141/1989-db1-4.DB.130212185252553.01::01'
 Backup Server: 4.132.1.1: Attempting to open byte stream device: 'SybGalaxy::
 -disk /MyAppFreeRestore/2141/1989-db1-4.DB.130212185252553.02::02'
 Backup Server: 4.132.1.1: Attempting to open byte stream device: 'SybGalaxy::
 -disk /MyAppFreeRestore/2141/1989-db1-4.DB.130212185252553.03::03'
 Backup Server: 6.28.1.1: Dumpfile name 'db11307110984 ' section number 1
 mounted on byte stream 'SybGalaxy:: -disk
 /MyAppFreeRestore/2141/1989-db1-4.DB.130212185252553.03::03'
 Backup Server: 6.28.1.1: Dumpfile name 'db11307110984 ' section number 1
 mounted on byte stream 'SybGalaxy:: -disk
 /MyAppFreeRestore/2141/1989-db1-4.DB.130212185252553.01::01'
 Backup Server: 6.28.1.1: Dumpfile name 'db11307110984 ' section number 1
 mounted on byte stream 'SybGalaxy:: -disk
 /MyAppFreeRestore/2141/1989-db1-4.DB.130212185252553.00::00'
 Backup Server: 6.28.1.1: Dumpfile name 'db11307110984 ' section number 1
 mounted on byte stream 'SybGalaxy:: -disk
 /MyAppFreeRestore/2141/1989-db1-4.DB.130212185252553.02::02'
 Backup Server: 4.188.1.1: Database db1: 1040 kilobytes (16%) LOADED.
 Backup Server: 4.188.1.1: Database db1: 1046 kilobytes (17%) LOADED.
 Backup Server: 4.188.1.1: Database db1: 2072 kilobytes (33%) LOADED.
 Backup Server: 4.188.1.1: Database db1: 4122 kilobytes (67%) LOADED.
 Backup Server: 4.188.1.1: Database db1: 6170 kilobytes (100%) LOADED.
 Backup Server: 4.188.1.1: Database db1: 6182 kilobytes (100%) LOADED.
 Backup Server: 3.42.1.1: LOAD is complete (database db1).
 Started estimating recovery log boundaries for database 'db1'.
 Database 'db1', checkpoint=(912, 18), first=(912, 18), last=(912, 18).
 Completed estimating recovery log boundaries for database 'db1'.
 Started ANALYSIS pass for database 'db1'.
 Completed ANALYSIS pass for database 'db1'.
 Started REDO pass for database 'db1'. The total number of log records to process
 is 1.
 Completed REDO pass for database 'db1'.
 Use the ONLINE DATABASE command to bring this database online; ASE will not bring it online automatically.
 Recovery of database 'db1' will undo incomplete nested top actions.
 Database db1 is now online.
×

Loading...