KEMBAR78
Step by Step System Copy (Backup Restore) : Pre - Requisites | PDF | Backup | Computer File
Scribd
Upload
98 views2 pages

Step by Step System Copy (Backup Restore) : Pre - Requisites

The document provides step-by-step instructions for copying an Oracle database system from a source server to a target server using BRRESTORE. It details deleting directories, placing backup files, running commands to start the restoration process, modifying control files, and recovering the database before opening with new redo logs.

Uploaded by

Prasanta Kumar Nanda
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
98 views2 pages

Step by Step System Copy (Backup Restore) : Pre - Requisites

The document provides step-by-step instructions for copying an Oracle database system from a source server to a target server using BRRESTORE. It details deleting directories, placing backup files, running commands to start the restoration process, modifying control files, and recovering the database before opening with new redo logs.

Uploaded by

Prasanta Kumar Nanda
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

STEP BY STEP SYSTEM COPY ( Backup

Restore)
FollowRSS feedLike
25 Likes 60,355 Views 13 Comments

1. Pre – Requisites :
 No of Drives should be same in both Source Server & Target Server. (Not Mandatory)
 Drive Names should be same in both Source Server & Target Server. (Not Mandatory)
 Installation of Database & SAP should be same in both Source Server & Target Server.
1. STOP SAP & Oracle SERVICES AND EMPTY FOLLOWING  DIRECTORIES :

Go to Target Server & Stop all services (oracle & SAP both).

Now Delete the All files inside the following Directories.

SAPDATA_HOME\sapdata1\sysaux

SAPDATA_HOME\sapdata1\system

SAPDATA_HOME\sapdata1\temp

SAPDATA_HOME\sapdata1\undo

SAPDATA_HOME\sapdata1\cntrl

SAPDATA_HOME\sapdata2\ sr3_1 ………sr3_n

SAPDATA_HOME\sapdata3\ sr3702_1 ……… sr3702_n

SAPDATA_HOME\sapdata4\sr3usr_1

SAPDATA_HOME\origlogA\cntrl

SAPDATA_HOME\origlogB\cntrl

SAPDATA_HOME\sapdata1\cntrl

1. PLACE BACKUP FILE IN SAPBACKUP DIRECTORY

Place the xxxxxxxx.and File In Sap backup Folder

SAPDATA_HOME \sapbackup

The File Name Will Be Like This belerzpm.and

1. Open Cmd Prompt And Run This Command

BRRESTORE –m full –b  xxxxxxxx.and  –d disk –c

Now The Restoration Process Has Started

1. Again Delete Oracle Control Files under these directories that comes after restoration  
SAPDATA_HOME \origlogA\cntrl

SAPDATA_HOME \origlogB\cntrl

SAPDATA_HOME \sapdata1\cntrl

1. Create trace file in source server using this command:

SQL>Alter database backup controlfile to trace;

Copy this trace file to target server and rename to control.sql.

Now modify this control.sql

Delete all before “startup mount” & after “CHARACTER SET UTF8;” in control.sql

Change

 <source SID> to <target SID> 


 REUSE –> SET
 NORESETLOGS –> RESETLOGS

            Now, Put this Control.sql to C drive on <TARGET SID>   SYSTEM.        

              Start Oracle Services

             SQL> @C:\CONTROL.SQL;   

1. Copy all archive logs to SAPDATA_HOME\oraarch & Run these commands

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;       

SQL>ALTER DATABASE OPEN RESETLOGS;

1. Create Users as per note 50088.


1. Start SAP Services.

You might also like