SAP ASE16.0 SAP SYBASE DB RESTORE
SAP SYBASE DB RESTORE
In `this blog we have explain the SAP ASE- SAP SYBASE DB RESTORE Activity details. SYBASE Database name has changed to SAP ASE and it is database server consists of the data server and Backup server.
SAP ASE – SAP Sybase DB Restore Process:
• Perform the SAP Application level pre-steps
• Take the full Backup from Source system
• Restore the full Backup to Target system.
• Perform the post steps on SAP Application level.
Pre-requisites:
• Source system and target system database pages must be same is required
Example:
Source system SYBASE DB Pages is 16K
Source system SYBASE DB Pages is 16K
Different type of pages is there in SAP ASE Sybase DB. SYBASE DB Pages: 2K, 4K, 8K & 16K.
• Source system and Target system DB versions should be same level is required.
Check SAP ASE DB version:
Command: SP_Version or
Login with sybsid
Go to /Sybase/SID/ASE_16/install
Execute the dataserver –v
• Compare to the Source system DB size, Target system DB size higher value is required.
Example:
Source system DB Size : 400GB Then Target System DB Size at least 401 GB is required.
How to resize data volume or log volume.
Example:
required to increase data value 10G
• Goto /Sybase/SID/ASE_16/install
• Execute the command: isql64 –U<user> -P<password> -SSID –X
Example:
isql64 –Usapsa –Pwelcome@1234 –SABC –X
• Execute
Data Volume: ABC_data_001
Increase Size : 10GB
Disk resize name=’ABC_data_001’, size = ‘10G’
Alter database ABC on ABC_data_001 = ‘10G’
• Make sure Backup server is running on SAP ASE.
Below command for how to start the Backup server
Command:
Go to /Sybase/SID/ASE_16/install
. /RUN_SID_BS
• Take source system full Backup and move to target system.
Apply the owner and permission to Full backup file.
Ownership : chown sybsid:sapsys filename
• Perform the SAP –Application level Pre-steps.
Please check below link for DB Restore SAP Application level Pre and Post steps details.
How to take Sybase DB backup:
• Login with sybsid
• Goto /Sybase/SID/ASE_16/install
• Before start the Backup , need to start the Backup server through command
Go to /Sybase/SID/ASE_16/install
Execute : ./RUN_SID_BS
• Once backup server has running , open the another session execute the below command.
• Login with sybsid
• Go to /Sybase/SID/ASE_16/install
• Execute the command: isql64 –U<user> -P<password> -SSID –X
Example: isql64 –Usapsa –Pwelcome@1234 –SABC –X
>use master
>go
>dump database SID to “<mention path><Backup name.DMP”
Example:
dump database SID to “/backup/media/Backup.DMP”
>go
• Dump database command for take the file level backup and backup has stored in mention location.
• Once Backup has been completed then backup has stored in above mention location.
How to restore the Sybase DB backup: SAP sybase db Restore
• Take full Backup of the Target system.
• Stop the sap application.
• Move sybase db Backup from source system to target system.
• Apply the permission and owner to the Backup files.
• Permission should be sybsid:sapsys
• Login with sybsid on target system.
• Goto /Sybase/SID/ASE_16/install
• Execute the command: isql64 –U<user> -P<password> -SSID –X
Example:
isql64 –Usapsa –Pwelcome@1234 –SABC –X
>use master
>go
>load database SID from “<mention path><Backup name.DMP”
Example:
>load database SID from “/backup/media/Backup.DMP”
>go
Load database command for load the data to the target db and it is Depending on DB size and CPU, db restore it will take time.
Once backup has restored successfully then execute the below command.
>online database <target database>
>go
Once sap ASE Sybase db restore is completed then start the application and check the SAP system.
Post steps:
• Restart the SAP ASE-Sybase Database.
• Start the SAP Application and perform the post steps.
• Please click link for DB restore PRE & Post Steps Activity details..
DB Level Post steps:
• Check top 10 large tables in Source system
• Check top 10 large tables in target system.
• Compare the Both source and target system large table details.
• Check the few tables no of record in source system and target system for verification.
Example tables: DD03L, DD02L, T001L, BALDAT, REPOSRC.
• Check all no of tables details in Source and Target system then check total no of the tables is equal or not in source system and target system.
Command:
exec sp_tables ‘%’
How to check the Sybase Database license:
• Login with sybsid on target system.
• Goto /Sybase/SID/ASE_16/install
• Execute the command: isql64 –U<user> -P<password> -SSID –X
Example: isql64 –Usapsa –Pwelcome@1234 –SABC –X
>sp_lmconfig
• Check SAP ASE DB license is Expiry date column
• License is permanent , status is showing Permanent.
• Please check below screenshot for reference.
Conclusion:
• We have Completed the SAP ASE- SAP SYBASE DB RESTORE Activity.
Other info:
• Please check below blogs for more learning
• SAP ASE SYBASE DB ADMIN TASKS
• SAP ASE – SYBASE DB UPGRADE
• SAP DB RESTORE PRE & POST STEPS.
FAQ for SAP ASE –SYBASE DB RESTORE Activity:
1. How to increase/resize Sybase db size?
using below command, increase/resize db size.
Data Volume: MQC_data_001
Disk resize name=’MQC_data_001’, size = ‘10G’
Alter database MQC on MQC_data_001 = ‘10G’
2. How to restore the Sybase db backup?
using load command , we can restore the data.
Commands:
load database SID from “<Backup name.DMP”
Example: load database SID from “/backup/media/Backup.DMP
3. How to take Sybase db backup?
using dump command, we can take the full file level backup.
dump database SID to “<Backup name.DMP”
