cancel
Showing results for 
Search instead for 
Did you mean: 

Backup - Sybase ASE

former_member183829
Participant
0 Kudos

Hello,

I have query on backup concept for Sybase ASE 16.0.

I have SAP ECC 6.0 installed on Sybase ASE 16.0/Linux.

I have tested backups successfully via dump database/dump transaction commands and with DBA Cockpit.

Couple of queries:

1) Is there concept of offline backup in Sybase? (Similar to oracle's)

2) Is Sybase online backup always consistent? (Unlike Oracle's and similar to SQL)

Basically, if I restore online backup of Sybase (and if I do not want any point in time recovery), can I start database without applying any transaction logs? (v/s Oracle: where we need to apply at least archive logs generated while online backup was running)

I have read some other blogs but was not able to get clarity on these queries.

Cheers.

Accepted Solutions (0)

Answers (3)

Answers (3)

Johan_sapbasis
Active Contributor
0 Kudos

Hi,

Please review the following notes:

1585981 - SYB Ensuring Recoverability for SAP ASE

1588316 - SYB Configure automatic database and log backups

1611715 - SYB How to restore an SAP ASE database server (Windows)

1618817  SYB How to restore a Sybase ASE database server (UNIX)

Example.

1> sp_config_dump @config_name='SIDDB',

2> @stripe_dir ='D:\Backup\Database',

3> @compression = '101',

4> @verify = 'header'

5> go

The change is completed. The option is dynamic and ASE need not be rebooted for

the change to take effect.

(return status = 0)

1> sp_config_dump @config_name='SIDLOG',

2> @stripe_dir ='B:\Log_Archives',

3> @compression = '101',

4> @verify = 'header'

5> go

The change is completed. The option is dynamic and ASE need not be rebooted for

the change to take effect.

(return status = 0)

For the this to take effect it will also be required to switch of the truncate log settings.

Depening on what you need to do, but please refer to the notes aforementioned.

J

crisnormand
Active Participant
0 Kudos

Hello,

You may want also to check this recent thread, where it is explained how work the SAP ASE dump database and dump transaction :

http://scn.sap.com/thread/3753005

Regards,

Cris

jayrijnbergen
Active Participant
0 Kudos

Offline backups is typical for Oracle, not needed for Sybase ASE

Sybase ASE performs database backups in 3 phases, this you can also see in your backupserver logfile. It tries to get as much as possible the latest changes in the backup file.

There might be some open transactions while the backup is made (that is the transaction is not completed when the 3rd phase of the backup finished), these open transactions will be rolled back when the database is put back online. If you would have additional transaction log backups, these should be applied before the database is put back online.

Because open transactions are rolled back when the database is put online, your database will always be in a consistent state.

Note: In latest Sybase versions there's an extra config option 'optimize dump for faster load' to add extra iterations to the backup. This reduces the time needed for the restore, but requires more time for the backup.

Alternative way is to quiesce your database and make external backup of your data files.