SAP DB 7.3 backup and restore
Does anybody has any doc or steps to follow for backup and restore of the SAP DB?
I have the backup of the data and trying to restore it, but could not do so as the Restore--> Database option is not highlighted. Also I was facing the problem while backup to Disk as the location mentioned was not identifying. But that got resolved when given D:\ ( Upper case) instead of lower case
Also I want to know about the pipe funda, no theory, but if somebody has done any practical work on it.
Please share some information.
Bernd Vorsprach replied
> I had taken the backup online with Recovery( without
> Checkpoint). What is the difference with the 2
> 1. Recovery( without Checkpoint)
> 2. Migration ( with checkpoint)
This question will be answered in this document
> Also the parameter " Recovery with Initialization".
> That option is not present in 7.4 DBM GUI. Nor with
> the dbmcli commands.
Please use the Installation Wizard and enter the name of your existing database. During the steps choose "reinstall" and and "install instance for recovery".
> Also what I have done now is, I have 2 servers to do
> R&D for the restore. At present I am making the same
> datafiles and logfiles( size and on the same drive
> letter ) on both the server. Because what I have
> found that the restore will take the source db drive
> letter and folder to put the data and log files?
> Am I doing the right thing????? Please suggest
If you choose in the Installation Wizard "Restore parameters from existing backup" the database gets the same configuration (including drive letters and pathes) than the source of the backup. "Restore parameters" reads only the configuration of an instance from the backup. To restore the content of an instance you have to use a data recovery.
The link above contains some information about the different kinds of backup and recovery too.
At this server there is also a lot of other documentation matching to the 7.3 release