Error DB restore in SAP

[Former Member]

I have Full DB Backup File, how can i use this backup file to install fresh sap to recover my data

plz suggest me the steps

[Former Member]

Hi Mukund,

Please use the below procedure

1. Execute the below command at source...

Alter database backup controlfile to trace resetlogs; then the control file will be created at /oracle/<SID>/saptrace/usertrace

Rename the control file to control.trc

2. Move the control file (control.trc) to the target system (fresh system)

2.5) Copy the full data as per the backup fileu2026on the target system.

3. Create the control file

SQL>control.trc (Resolve the errors if you get any.....)

4. Once the control file is created

5. Rollforward and open the database.

i) SQL> recover automatic database until cancel using backup controlfile;

ii) SQL> alter database open resetlogs;

Then perform the Post Installation activities....

For more information -> http://help.sap.com/saphelp_nw04s/helpdata/en/a2/2f0c173a5e43d19585724239ff4de7/frameset.htm

*Collect full information before proceeding.

With Regards,

Krishna.

[Former Member]

thanks for reply,

But my DB is Sql Server how can i proceed for same