cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase Restoration

Former Member
0 Kudos

Hi All,

Anyone has any idea about Sybase restoration or any specific SAP note(For sybase backup/restore) to state the same. I have taken the production backup and restoring in the quality system at the moment.

However, unsure about the DB post activities before starting the sap instance. Any one has suggestion about it, please let me know

Thanks and Regards

Vijay Kumar G

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Vijay,

Information on backup and recovery of an SAP system on SAP Sybase ASE:

SAP Note 1611715 -SYB: How to restore an SAP Sybase ASE database server (Windows) and

SAP Note 1618817 -SYB: How to restore an SAP Sybase ASE database server (UNIX)

Thanks & Regards,

V Srinivasan

Former Member
0 Kudos

Hi Srini,

Thanks for the SAP note and I am wondering is there any specific activities has to be carried out (Because SID is going to be changed here).

Any insight / advise do you have for me?

Regards

Vijay Kumar G

Former Member

Answers (4)

Answers (4)

former_member186895
Participant
0 Kudos

HI VIJAY,

Can you please tell me what steps u followed for database restore from prd to qas.

and how you have changed database sid from prd tp qas.

please need urgently

Thanks

Ramesh

Former Member
0 Kudos

Hi Ramesh,

Below is the commands to restore  the PRD to Quality.

Run from source system

Load database SID from 'e:\sybase\SID\data\SID_012014.dmp'

go

the u will get the prompt showing message like 10%,20% loading

Finally u will get 100% loaded message after that you will get below message

Use the ONLINE DATABASE command to bring this database online; ASE will not

bring it online automatically.


Then u need bring database online

online database 'SID'

go

Database will come online.

There is no need to change sid ,I have followed the above procedure now system up and running fine.

Thanks

former_member186895
Participant
0 Kudos

Thanks for reply.

but question is that i have to directly restore database of prd to qas using below commond.

load database <SID>  from "path/sid.dmp".

As sid is different it will not give any error?

And what is a steps after restore to convert sid from prd to qas.

Thanks

Ramesh yadav

Former Member
0 Kudos

Hello

yes  . you have to create the QAS Database first in target with similar size PRD (datafiles and log as like PRD) then restore it using load database

load database QAS from "PRD.dmp"

Thanks ,Siva

Former Member
0 Kudos

No it will not give nay error ,I have done the same procedure only.

In sybase there is no need to change the sid ,while running online comand it will chnage internally sid

former_member186895
Participant
0 Kudos

hi siva,

thanks for quick reply

Any steps required after restore to change sid from prd to qas?

Thanks

Ramesh yadav

former_member186895
Participant
0 Kudos

okie.

Thanks expert for your valuable helps.

Former Member
0 Kudos

Hi

please find the steps

1. Get a current dump for your SAP database on the source system.

     $> isql -SPRD -Usapsa -DPRD

     1> dump database PRD to "/sybase/PRD/backups/PRD.dmp"

     2> go

2.Transfer the dump to the target system.

     copy the dump files to target system

3. Prepare the target database to match the source database's layout.

    use procedure sp_ddlgen to get the CREATE DATABASE COMMAND for this.

     The example below writes the DDL for database

     'PRD' to a file 'DDL_PRD.sql' in the current working directory.

     $> isql -SPRD -Usapsa -DPRD

     1> sp_ddlgen 'database', 'PRD'

     2> go > DDL_PRD.sql

     The DDL statements for the creation of the source database can look

     like this:

     CREATE DATABASE PRD

     ON dataPRD_1 = '200704M' -- 12845056 pages

     LOG ON logPRD_1 = '4096M' -- 262144 pages

     go

     ALTER DATABASE PRD on dataPRD_2 = '200704M' -- 12845056 pages'

     go

     The DDL statements for the creation of the target database can look

     like this:

     CREATE DATABASE QAS

     ON   dataQAS_1 = '200704M' -- 12845056 pages

     LOG ON logQAS_1 = '4096M' -- 262144 pages

     go

     Refer SAP note 1591387 or more details

*** It will create empty database QAS  then you can load the data from dump

4. Load the database dump from the source system into the target SAP database and set it online.

     load database QAS from "/sybase/QAS/backups/PRD.dmp"

5. Perform post-load activities in the database

former_member186895
Participant
0 Kudos

Dear siva,

Already database is present as QAS.

Then too i have to run commond sp_ddlgen on source system?

please clear my confusion.

Thanks

Ramesh yadav

former_member186895
Participant
0 Kudos

hi SIVA

Do you have screen short of same?

please share with me.

Ramesh

Former Member
0 Kudos

Hello

if you have QAS DB already then the below steps would be fine

1.Transfer the dump to the target system.

copy the dump files to target system ie /sybase/QAS/backups

2. Load the database dump from the source system into the target SAP database and set it online.

     isql -SQAS -Usapsa -Dmaster

     1>load database QAS from "/sybase/QAS/backups/PRD.dmp"

     2>GO

     isql -SQAS -Usapsa -Dmaster

     1> online database TST

     2> go

"Loading dumped data to an existing database overwrites all existing data"

QAS data will be replaced by PRD data.

make sure that QAS system is similar to PRD on SAP layout size(datafiles and logs)  to accommodate all the PRD datas

Thanks ,Siva

former_member186895
Participant
0 Kudos

Thanks master.

Former Member
0 Kudos

Hi Srini,

Thanks - It was really simple compared to other database which I have done so far. Need to explore further.

I am done with the database restoration followed by couple of activities as stated in the sap note and then brought the database to online.

ALl went well and done with the sap post activities too.

Thanks for the support and love sdn


Regards

Vijay Kumar

Former Member
0 Kudos

Hi Vijay,

sorry for the opening thread ,I am also starting the activity backup/restore from Production to Quality for system refresh activitiy.

I am bit confusion how can we chnage the SID in traget system ,in mssql we have scripts for this purpose.

PLease share teh step by step procedure to finish the activity.

Thanks advance

Former Member
0 Kudos

Hi Srini,

Thanks - It was really simple compared to other database which I have done so far. Need to explore further.

I am done with the database restoration followed by couple of activities as stated in the sap note and then brought the database to online.

ALl went well and done with the sap post activities too.

Thanks for the support and love sdn


Regards

Vijay Kumar

former_member188883
Active Contributor
0 Kudos

Hi Vijay,

Refer SAP Note 1591387 - SYB: Homogeneous Systemcopy Sybase ASE

for guidance.

Regards,

Deepak Kori