If you wan to restore SAP sybase DB into the Same host using the backup dump, please follow below steps:
1. First make sure the dump is available to the file system level.
2. Stop SAP system
stopsap
3. Then start only Sybase database
startdb
4. Now Switch use to syb<sid> then connect tot he DB
su - syb<sid>
isql64 -Usapsa -P<password> -S<SID> -X
5. Now trigger restore command:
use master
go
load database <SDI> from '<path of the file/<filename>'
go
6. After processing the load, it will ask run bring online command.
online database <SID>
go
7. Exit from sybase level and stop and start the SAP.
1. First make sure the dump is available to the file system level.
2. Stop SAP system
stopsap
3. Then start only Sybase database
startdb
4. Now Switch use to syb<sid> then connect tot he DB
su - syb<sid>
isql64 -Usapsa -P<password> -S<SID> -X
5. Now trigger restore command:
use master
go
load database <SDI> from '<path of the file/<filename>'
go
6. After processing the load, it will ask run bring online command.
online database <SID>
go
7. Exit from sybase level and stop and start the SAP.
No comments:
Post a Comment