Highlighted
Contributor.
Contributor.
90 views

Restore Sybase Database

Jump to solution

Hi all. 

I´m working with the integration of Data Protector and a SAP Sybase database and HP StoreOnce. 

DP Manager is installed on a Windows Server OS, and the Sybase in Linux Sles Server. 

The integration between DP and Sybase was sucessfully configured, the backup is running fine.

I take a full backup of the target DB, and now I´m triyng to run a restore process to a sandbox server, to validate the solution, but I´m receiveing error when executing the syb_tool command, as per described in the Integration Guide.

I ran the command on the target server, on the source server, and in the DP Server, and the result is always the same:

syb_tool <databaseSID> <databasesourceserver> -date 2020/05/18.12:00:00 -media

No full backup available.
Try with 'load database from "ob2syb::latest"'

I can see the backup in gue DPM GUI, at the Internal Database -> Objects/Sessions and looks like its Ok.

Any hint on it? 

Thank you,

MAlves. 

0 Likes
1 Solution

Accepted Solutions
Highlighted
Contributor.
Contributor.

Re: Restore Sybase Database

Jump to solution

The restore process was sucessfully completed, ignoring the tool provided by the Dataprotector, and using the load database command from isql interface:

load database <SID> from "ob2syb::2020/05/21-1", where 2020/05/21-1 is the session identified in Data Protector Manager. 

 

Best Regards,

Marcos. 

 

View solution in original post

0 Likes
4 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Restore Sybase Database

Jump to solution

Hello @Basis_BA

The syntaxis of the command appears like: 

syb_tool database Sybase_instance -date YYYY/MM/DD.hh:mm:ss -media

I assume that Sybase_instance is the databasesourceserver as you indicate. 

But, also check this note in the documentation: 

Important To restore a database to a new database, first create a new database. The new database should have the same structure as the database to be restored.

To restore a database to a different Sybase instance on another client system, set the OB2HOSTNAME variable on the target client: add the OB2HOSTNAME=BackupClient.company.com variable entry to the Sybase_TargetInstance.cfg configuration file, located in the default Data Protector temporary files directory.

Andres Fallas Salazar
Customer Support Engineer

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a LIKE by clicking on the bottom at the left of the post and show your appreciation.
0 Likes
Highlighted
Contributor.
Contributor.

Re: Restore Sybase Database

Jump to solution

Hello Andres, thank you for your hint. 

I already had configured the cfg file. Now I´m restoring the database directly from ISQL, without the assistance of syb_tool, and is running fine. 

Best Regards.

0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Restore Sybase Database

Jump to solution
Good to know.
If works, consider to mark this as solved.
Andres Fallas Salazar
Customer Support Engineer

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a LIKE by clicking on the bottom at the left of the post and show your appreciation.
Highlighted
Contributor.
Contributor.

Re: Restore Sybase Database

Jump to solution

The restore process was sucessfully completed, ignoring the tool provided by the Dataprotector, and using the load database command from isql interface:

load database <SID> from "ob2syb::2020/05/21-1", where 2020/05/21-1 is the session identified in Data Protector Manager. 

 

Best Regards,

Marcos. 

 

View solution in original post

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.