on 04-29-2013 7:00 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vijay,
Refer SAP Note 1591387 - SYB: Homogeneous Systemcopy Sybase ASE
for guidance.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.