on 06-10-2015 10:42 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.