SAP DB Restore/Refresh

SAP System refresh | SAP DB Refresh/Restore

System/DB Restore Procedure:

Make a note of SAPLICENSE of the target system.

Check for the kernel version of target system is same as the source system. Other wise

Upgrade the kernel in target system to the same level of source system.

Check that the directory structure of the target system must be same as the source system Source system

Target system:

Copy the .aft, .tib and backPRD.log files from source system to destination system. These .aft& .tib files must be of the same date and time when the backup was taken. .aft file is the offline backup file-it contains all the information regarding offline backup .tib file contains information regarding tape initialization. BackPRD.log contains the entire l the backups log information.

In  .aft ,.tib files replace Source system SID<PRD> with target system SID<DEM>

Copy the trace file from source system to destination system.This trace must be of the same date and time when the backup was taken.

Connect to ERPDBA to restore   and follow the below screenshots.

Now the restoration process will start.

After Successful restore Shut down the database to create the control file.

Rename the present control files in target system. Control file is located n four locations

H:oracleDEMsaparchcntrl

G:ORACLEDEMSAPDATA1cntrl

L:oracleDEMsaparchcntrl

I:oracleDEMoriglogAcntrl

Create the control file with the old trace file copied from source system with RESETLOGS option In the trace file copy the text from

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE “PRD” NORESETLOGS ARCHIVELOG

to

CHARACTER SET WE8DEC

In a text file and change the Create command as follows.

CREATE CONTROLFILE SET DATABASE “PRD” RESETLOGS ARCHIVELOG

Connect to Sqlplus /”as sysdba” and then paste the entire text then control file will be created.

Open the database with reset logs.

Initialize SAPconnet for this follow the screenshots.

 Change the Environmental variable of  DBS_ORA_SCHEMA to SAPR3.

Then restart the system and up the MMC.

Apply the sap license of the target system that was noted before restore…