Restore steps

[former_member182034]

Hi All,

if my system did not recover then there was last option of Restore DB. So, if i restore DB then which steps are necessitate for restore.

here i m working on DR and performing these steps:

this is for Testing Purpose

i have copied the DATAFILEs from PRD to DR and i have changed the trace file and create controlfile with SQL>@ C:\filename.txt

1. copy and paste daily Oraarch from PRD to DR

2. SQL> startup mount

3. SQL> recover database using backup controlfile;

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

AUTO

when recovery completed then run following command.

4. SQL> recover database using backup controlfile;

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

CANCEL

Media recovery cancelled.

IF PRD will be down then run below command after recover database.

5. SQL> alter database open resetlogs

when i start the the sap from SAPMMC then disp+work.exe stopped while i have run above commands,

if i login to DR then what will i do for further proceeding?

cheers,

majamil

[Former Member]

Hi Majamil,

Why you are not proceeding with below method:

1) Copy all the datafiles from source to target server

2) Create a standby controlfile on your source system

3) Mount your standby database with newly created standby controlfile.

4) Then copy all the archive logs from source to target server

5) Recover database using below command:

recover standby database

It automatically pick your newly copied archivelogs and start applying to database.

Whenever you want to open the database on standby server just activate the database or make a copy of controlfile from source to target and open.

Regards

Nick Loy

[former_member603052]

Hi,

Have u created OPS$users in the DRsite ? For this u need to run oradbusr.sql script.

Have u done these on the DR?

Also send the error logs of dev_w0

Regards,

Kalyan

[markus_doehr2]

> when i start the the sap from SAPMMC then disp+work.exe stopped while i have run above commands,

Did you check the logs (dev_disp, dev_w0?) to find out why it stopped?

Also created OPS$-Users?

Markus

[former_member182034]

Hi all,

now once again i m trying to make DR server . i have two system with same name and same partitions. i have copied the DATA Files

sapdata1

sapdata2

sapdata3

sapdata4

what are the next steps for DR?????

regards,

[Former Member]

Hi

1. First check whether all the filesystem has been copied correctly or not.

2. If you DB and CI is on different server please check the same as well.

3. Please check the mount points for TMS

4. Please make sure uid & Groupid are same ( You can check the same by typing 'id' or 'id ora<sid>', and '<sidadm>'

5. Please check whether you are having correct permission for file systems.

6. Please also check uname -a

7. Please check the permission of each and everyfilesystem

Please check all the above .

Hope it helps.

Cheers

Deepanshu

[Former Member]

Hi

Is your problem resolved.

Cheers

Deepanshu