Question Re: Sybase restore doubt in Technology Q&A

Sybase restore doubt

former_member612721 — Sun, 12 Jan 2020 11:29:07 GMT

Hello SAP community,

I recently ran a system refresh on Sybase DB as follows:

I backed up the source DB with : dump database SID at ... with compression = 6

Then I restored the source DB on target DB with : load database, by typing the data backup location that I just performed above.

As I don't have much experience with sybase, I wanted to write this question to you

Haven't done any transaction log backup of the source DB and I don't intend to restore the transaction logs on the target DB.

I was very surprised to see that the restore was completed in 3 hours while the backup took almost 12 hours to complete... Didn't the restore suppose to take longer than the backup?

My questions are below:

1) I found that the restore progress jumped from 45% LOADED straight to 100% LOADED.. I haven;t seen this behaviour in none of all tutorials I viewed. Does this indicate a problem or is this normal ?

And then the Roll forward transaction lines were listed in the log, just as if I also restored any transaction log dump, but I didn't.

There are no errors shown in the log.

2) Is it normal the restore to finish 4 times faster than the backup ?

3) After the restore finished, I found the target DB data usage to be very low compared to the source DB data usage - I expected these to be equal.

And found the transaction log to be 100% full - Does this indicate that the restore actually crashed because of transaction log full ?

After I've set the database to online , Log got cleared and data was equal to source DB

Can someone with a little bit more experience on Sybase advise if the above "symptoms" indicate there could of been problems in the restore process, or are all these normal behaviours?

Thank you

Re: Sybase restore doubt

former_member612721 — Sun, 12 Jan 2020 16:20:00 GMT

Hello,

Should I worry about the above messages ?

Any advise please?

Re: Sybase restore doubt

former_member612721 — Mon, 13 Jan 2020 08:18:22 GMT

Hello Mark,

Thank you for the comprehensive answer 🙂 I was very worried about it .

Below you can see my ASE version.

1> select @@version
2> go

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Adaptive Server Enterprise/16.0 SP03 PL06/EBF 28334 SMP/P/x86_64/SLES 11.1/ase160sp03pl06x/3457/64-bit/FBO/Mon Nov 26 04:33:30 2018

Thanks again

Re: Sybase restore doubt

hrollizo — Mon, 13 Jan 2020 12:45:26 GMT

Hi colls,

Mark have the right answer.

You can also check this SAP Notes:

1585981 SYB: Ensuring Recoverability for Sybase ASE
1588316 SYB: Configure automatic database and log backups
1611715 SYB: How to restore a Sybase ASE database server (Windows)
1618817 SYB: How to restore a Sybase ASE database server (UNIX)

More information about ASE DB:

https://wiki.scn.sap.com/wiki/display/SYBASE/SAP+ASE+Home

https://support.sap.com/en/product/support-by-product/67837800100800005166.html

https://help.sap.com/doc/a6121aa4bc2b1014973595b879fce7fd/16.0.3.7/en-US/SAP_ASE_System_Administration_Guide_Volume_2_en.pdf (chap.13 Developing a Backup and Recovery Plan)

Regards

Re: Sybase restore doubt

Former Member — Mon, 07 Dec 2020 20:35:25 GMT

A bit late to the party, but this old note might help explain.
Says it's "non-business suite" but I bet it's the same reason...
2409827 - Backup load percentage progress incorrect - ASE

Darryl