Restore/backup of PROD to QA ...

[Former Member]

Dear all,

ECC 6.0 , AIX and Oracle 10G.

We are tried already Client export /Import but imports can take more time to complete ....

so we will plan another alternate option to copy data from PROD to QA .

We have full file level backup , Whole DB Online backup with redolog and Whole DB OFFline backup with redolog.

Can we use Backup/Restore the latest data from PROD to QA ?

Kindly provide any link ....

[Former Member · Accepted solution]

Homogenous System copy guide tells you the step by step process

FYI: here I am pointing out the main steps:

1) Take a controlfile backup from source system

2) Take a full Offline/Online backup of source system

3) Stop Apps+DB on target system (Where you want to restore)

4) Delete all SAPDATA files (Its contents) from the target server

5) Restore the Online/Offline backup into target server

6) Perform the recovery of DB on target using archivelogs (If you restored Online backup) with backed up control file of source

7) Startup SAP application

😎 Perform post installation steps (Licensing, STMS, RFCs,Post restore activities from SE06, Profile imports from RZ10,Interface rebuids if you have any other apps connected to it)

Regards,

Nick Loy

[Former Member · Accepted solution]

Dear All,

I have successfully restored on Target server with help of source system online backup ..

after i tried to login database through sqlplus i got below error ..

D:\oracle\IXP\sapbackup>brrestore -m full -b befgowul.and -c

BR0401I BRRESTORE 7.00 (48)

BR0405I Start of file restore: refhdycw.rsb 2011-02-21 17.24.02

BR0484I BRRESTORE log file: D:\oracle\IXP\sapbackup\refhdycw.rsb

BR0370I Directory D:\ORACLE\IXP\SAPDATA2\SR3_1 created

BR0370I Directory D:\ORACLE\IXP\SAPDATA2\SR3_2 created

..................................................................................................................

...............................................................................................

.BR0370I Directory D:\ORACLE\IXP\SAPDATA1\SYSTEM_1 created

BR0252E Function _mkdir() failed for 'C:\oracle\IXP\origlogA\cntrl' at location

BrDirCreate-1

BR0253E errno 2: No such file or directory

BR0252E Function _mkdir() failed for 'C:\oracle\IXP\origlogB\cntrl' at location

BrDirCreate-1

BR0253E errno 2: No such file or directory

BR0406I End of file restore: refhdycw.rsb 2011-02-21 17.24.02

BR0280I BRRESTORE time stamp: 2011-02-21 17.24.02

BR0404I BRRESTORE terminated with errors

D:\oracle\IXP\sapbackup>brrestore -m full -b befgowul.and -c

BR0401I BRRESTORE 7.00 (48)

BR0405I Start of file restore: refhdyqq.rsb 2011-02-21 17.30.00

BR0484I BRRESTORE log file: D:\oracle\IXP\sapbackup\refhdyqq.rsb

BR0370I Directory C:\oracle\IXP\origlogA\cntrl created

BR0370I Directory C:\oracle\IXP\origlogB\cntrl created

BR0456I Probably the database must be recovered due to restore from online backu

p

BR0280I BRRESTORE time stamp: 2011-02-21 17.30.00

BR0407I Restore of database: IXP

BR0408I BRRESTORE action ID: refhdyqq

BR0409I BRRESTORE function ID: rsb

BR0449I Restore mode: FULL

BR0411I Database files for restore:

C:\oracle\IXP\origlogA\cntrl\cntlrIXP.dbf

C:\oracle\IXP\origlogB\cntrl\cntrlIXP.dbf

D:\oracle\IXP\sapdata1\cntrl\cntrlIXP.dbf

BR0419I Files will be restored from backup: befgowul.and 2011-02-18 15.55.07

BR0416I 16 files found to restore, total size 23212.195 MB

BR0424I Files will not be decompressed

BR0421I Restore device type: disk

BR0420I Files will be restored from directory: D:\oracle\IXP\sapbackup\befgowul

BR0280I BRRESTORE time stamp: 2011-02-21 17.30.00

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

c

BR0280I BRRESTORE time stamp: 2011-02-21 17.30.01

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0126I Unattended mode active - no operator confirmation required

BR0351I Restoring D:\ORACLE\IXP\SAPDATA2\SR3_1\SR3.DATA1

BR0355I from D:\oracle\IXP\sapbackup\befgowul\SR3.DATA1 ...

.....................

BR0351I Restoring C:\oracle\IXP\origlogB\cntrl\cntrlIXP.dbf

BR0355I from D:\oracle\IXP\sapbackup\CNTRLIXP.DBF ...

BR0351I Restoring D:\oracle\IXP\sapdata1\cntrl\cntrlIXP.dbf

BR0355I from D:\oracle\IXP\sapbackup\CNTRLIXP.DBF ...

BR0406I End of file restore: refhdyqq.rsb 2011-02-21 17.39.30

BR0280I BRRESTORE time stamp: 2011-02-21 17.39.30

BR0402I BRRESTORE completed successfully

D:\oracle\IXP\sapbackup>

C:\Documents and Settings\ixpadm.SAPPRD>cd D:\oracle\IXP\102\RDBMS\ADMIN

C:\Documents and Settings\ixpadm.SAPPRD>d:

D:\oracle\IXP\102\RDBMS\ADMIN>sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Feb 22 13:10:37 2011

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> connect /as sysdba

Connected to an idle instance.

SQL> startup nomount

ORA-02778: Name given for the log directory is invalid

SQL> @controlfile.sql

CREATE CONTROLFILE SET DATABASE "IXP" RESETLOGS ARCHIVELOG

*

ERROR at line 1:

ORA-01034: ORACLE not available

ORA-01034: ORACLE not available

ALTER DATABASE OPEN RESETLOGS

*

ERROR at line 1:

ORA-01034: ORACLE not available

ALTER TABLESPACE PSAPTEMP ADD TEMPFILE 'D:\ORACLE\IXP\SAPDATA1\TEMP_1\TEMP.DATA1

'

*

ERROR at line 1:

ORA-01034: ORACLE not available

Kindly advise

Edited by: satheesh0812 on Feb 22, 2011 8:50 AM

[Former Member · Accepted solution]

This message was moderated.

[Former Member]

Answered

[Former Member]

Always read the full content of the ERROR before going for Search/Google

Always Search/Google with the exact Keyword before going to post your query on SDN

Always close all the threads and open a new thread for new queries, Do not follow one thread

Always Read and Follow the Forum Rules before logging into SDN

ORA-00308: cannot open archived log

'D:\ORACLE\IXP\ORAARCH\IXPARCHARC00255_0966944193.001'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

Above error is clearly saying that "Unable to open the file" Check whether that file is there at 'D:\ORACLE\IXP\ORAARCH or not?

Check the permissions whether user is able to read or not?

Regards,

Nick Loy

[Former Member]

Hi Satheesh,

If you are restoring an offline backup you wont need redo logs.but if you are restoring online backuo then you would be requiring the redo logs.Depending on the backup software you use you can restore the data from prod to queality or else the unix guys can do a storage level copy for the file systems required for refresh.Once you have restored an offline backup to the quality system then you can need to create the controlfile.you can do it by generating the trace file in production and copyign it across and recreating th controlfile.Please let us know if you have any questions.

[Former Member]

backup restore would only work if you have homogenous environment.Thanks.

[Former Member]

Dear Ambarish annapureddy ,

Now i am working on system copy (Backup/Restore) method .

Both QA and PROD have same OS , DB (Oracle 10.2.0.2 patch set both).

Note : now Both QA and PROD are working , before restore we should delete the exiting data in mentioned below directory on Target system ?

I have already taken file level offline backup of Oracle directory on Source system.

\oracle\<DBSID>\sapdata<x>

\oracle\<DBSID>\origlog<x>

\oracle\<DBSID>\mirrlog<x>

CONTROL.SQL

init<TARGET_DBSID>.ora

============

let me how to create control file on source system DB oracle ?

Edited by: satheesh0812 on Feb 16, 2011 6:40 AM

[Former Member]

Steps to do system copy using backup/restore , I have given a outline not a detailed one.

1. Take online backup of source system

2. Restore the Source online backup to Target System

3. Create controlfile from source system

sqlplus> alter database backup controlfile to trace;

You can find the tracefile in /oracle/SID/saptrace/usertrace

Modify this file, change the source SID to target SID and rename the file to control.sql and execute it

3. Recover Database

sqlplus > recover database until time '2011:02:16:00:15:00' using backup controlfile;

It will ask for the redo logs , copy the required redologs from the source system and rename the SID to target sid

eg ORA-00279: change 107866316 generated at 10/16/2010 01:00:48 needed for thread 1

ORA-00289: suggestion : /oracle/DEV/oraarch/DEVarch1_7931_712108107.dbf

ORA-00280: change 107866316 for thread 1 is in sequence #7931

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

-Give Auto or give the full path of the logfile.

Once recovery is succeeded.

sqlplus > alter database open resetlogs;

Database will open, you can shutdown and start once.

4. Create the ops$ user and check R3trans -d .Once its fine.

5. Start the SAP and do the post steps.

If you need any help. You can contact me.

Regards,

Maheswaran

[nirmal_konchada]

Regards

Nirmal.k

Edited by: nirmal konchada on Feb 16, 2011 11:43 AM

[Former Member]

Dear Mahesh,

I had executed below command on Source system .

SQL> alter database backup controlfile to trace;

Database altered.

now how can we find exact trace file in /oracle/SID/saptrace/usertrace ? bcoz so many trace file are there in user trace dir...

Kindly help ...

Regards

[Former Member]

check for the latest file generated based on the time while you execute the command.

Regards,

Maheswaran

[Former Member]

Dear Mahesh,

there are any steps we need to do before restore the database in qa ?

Note : bcoz QA all the testing work are going on ...

Regards

[Former Member]

Satheesh,

You can export the data which you want to save using sap tools or else oracle tools.We use R3trans.You can export the data from the tables.Please check with the functional and development team before exporting the data so that you get a consistent data imported into the QA system after the restore.Thanks.

[Former Member]

HI Satheesh,

You can use alter database backup controlfile to trace as 'location';

[Former Member]

Dear All,

Pls confirm what are steps i have to work before backup on Source system side and also before restore on QA as well as after restore on QA ?

Kindly advise ....

Regards

[Former Member]

u can tak screen shots of sm37,scc4,smlg.rz04.rz12.rz70,sale,db13, before backup on source systm these are pre steps

[Former Member]

HI,

you can read the homogenous system copy manual. You can found it in service.sap.com -> Release & upgrade info ->Installation and Upgrades guides -> SAP Netweaver -> SAP Netweaver 7.0 -> Maintenance.

kind regards

[Former Member]

Thanks for valuable reply ...

pls confirm can we use netweaver system copy docu to ECC6.0 ?

Regards

[markus_doehr2]

ERP 6.0 is based on Netweaver 7.0 so you can use that documentation.

Markus