restore Backup throught BRtools

[Former Member]

hi all,

we took successfully full database online + redolog backup of DEV server on disk

DEV server detail

ID=DEV

HOST=SAPDEV

DB=Oracle

OS=Solaris 5.10

want to restore on test server

test Server

ID=PRD

HOST=SAPPRD

DB=oracle

OS=Solaris 5.10

on test server we copied /oracle/DEV/sapbackup .......> /oracle/PRD/sapbackup

rename log file restDEV.log to restPRD.log

1. su - oraprd

oraprd> brrestore

BR0401I BRRESTORE 7.00 (32)

BR0405I Start of file restore: rebcwxzj.rsb 2009-07-29 14.55.11

BR0484I BRRESTORE log file: /oracle/PRD/sapbackup/rebcwxzj.rsb

BR0454W Values of oracle_sid are different: current 'PRD', backup bebbrids.fnd 'DEV'

BR0455W Value 'PRD' of oracle_sid will be used for restore

BR0454W Values of oracle_home are different: current '/oracle/PRD/102_64', backup bebbrids.fnd '/oracle/DEV/102_64'

BR0455W Value '/oracle/PRD/102_64' of oracle_home will be used for restore

BR0454W Values of sapdata_home are different: current '/oracle/PRD', backup bebbrids.fnd '/oracle/DEV'

BR0455W Value '/oracle/PRD' of sapdata_home will be used for restore

BR0280I BRRESTORE time stamp: 2009-07-29 14.55.11

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

c

BR0280I BRRESTORE time stamp: 2009-07-29 14.55.30

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3.data1' to be restored not foundBR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3.data10' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3.data11' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3.data12' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3.data2' to be restored not foundBR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3.data3' to be restored not foundBR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3.data4' to be restored not foundBR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3.data5' to be restored not foundBR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3.data6' to be restored not foundBR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3.data7' to be restored not foundBR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3.data8' to be restored not foundBR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3.data9' to be restored not foundBR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3700.data1' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3700.data10' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3700.data11' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3700.data12' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3700.data2' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3700.data3' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3700.data4' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3700.data5' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3700.data6' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3700.data7' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3700.data8' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3700.data9' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3usr.data1' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3usr.data2' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/undo.data1' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/sysaux.data1' to be restored not found

BR0443W File '/oracle/DEV/sapbackup/bebbrids/system.data1' to be restored not found

BR0427I Files from the old sapdata_home /oracle/DEV will be restored into the new sapdata_home /oracle/PRD

BR0280I BRRESTORE time stamp: 2009-07-29 14.55.30

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

c

BR0280I BRRESTORE time stamp: 2009-07-29 14.57.20

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0417W No files found for restore/verification

BR0406I End of file restore: rebcwxzj.rsb 2009-07-29 14.57.20

BR0280I BRRESTORE time stamp: 2009-07-29 14.57.20

BR0403I BRRESTORE completed successfully with warnings

plz guide

[markus_doehr2 · Accepted solution]

> BR0401I BRRESTORE 7.00 (32)

I'd also update the tools (patchlevel 42 is actual)

> BR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3.data1' to be restored not foundBR0443W File '/oracle/DEV/sapbackup/bebbrids/sr3.data10' to be restored not found

and all those files are there - physically?

Markus

[Former Member · Accepted solution]

I'd also update the tools (patchlevel 42 is actual)

u mean oracle patchlevel ?

all those files are there - physically?

to resolve that remove data from datafile ?

[markus_doehr2 · Accepted solution]

> > I'd also update the tools (patchlevel 42 is actual)

>

> u mean oracle patchlevel ?

No - the BRTOOLS patchlevel (DBATL file in the database dependent directory for your release on the service marketplace).

> to resolve that remove data from datafile ?

Check "Note 1003028 - Enhanced support for database copy in BR*Tools" what you need to do in order to use brrestore to do system copies.

Markus

[anindya_bose · Accepted solution]

> BR0455W Value '/oracle/PRD' of sapdata_home will be used for restore

did you change Oracle_home? copy backSID.log and archSID.log to your test server?

What you are doning is basically database copy.. So please follow system copy guide.

[Former Member · Accepted solution]

we took backup daily through DB13 full online + redolog , but never restore it through BRtools. so just wnat to restore it on newly install test server

[markus_doehr2 · Accepted solution]

I understand what you're trying to do - but you need to follow the note I gave you. Using brrestore/brrecover to do system copies is not really that straighforward and needs a bit tweaking (all mentioned in the note).

Markus

[Former Member · Accepted solution]

did you change Oracle_home? copy backSID.log and archSID.log to your test server?

how i change Oracle_home?

i have copied complete sapbackup folder from DEV to test server

[Former Member · Accepted solution]

Hi master ,

we have read the SAP not , and done the following,

copy /oracle/DEV/sapbackup/ to test in (/oracle/<NEW-SID>/sapbackup)

rename backdev.log according to test server in /oracle/NEW-SID/sapbackup

rename archDEV.log according to test server in /oracle/NEW-SID/sapbackup/DEV/

parameter in init<NEWSID>.ora is same as describe in Note

log_archive_format = %t_%s_%r.dbf is not set both in DEV and test server 's initSID.ora

so that why not change init<SID>.ora in test server

brrecover [-c force] -t dbpit -b <brb_log>|-last -f <NEW_DBSID> {-seq <seq_nr>|last | -pit <time> | -scn <scn>}

i am not understanding about

NEW_BDSID =?

{-seq <seq_nr>|last | -pit <time> | -scn <scn>}=?

my NEW-BDSID is PRD on test server

1st archive is DEVarch1_885_692529587and last archive is DEVarch1_1399_692529587

plz guide how we successfully execuite brrecover command

regards

Imran

[Former Member · Accepted solution]

oraprd> brrecover -c -t dbpit -b backPRD.log|last -f PRD -seq 692529587|last -pit 2009-07-22 18.13.00

usage: last [-n number] [-f filename] [-a ] [name | tty] ...

usage: last [-n number] [-f filename] [-a ] [name | tty] ...

what is missing?

[markus_doehr2 · Accepted solution]

> oraprd> brrecover -c -t dbpit -b backPRD.log|last -f PRD -seq 692529587|last -pit 2009-07-22 18.13.00

> usage: last [-n number] [-f filename] [-a ] [name | tty] ...

> usage: last [-n number] [-f filename] [-a ] [name | tty] ...

your syntax is wrong.

NEW_BDSID =?

{-seq <seq_nr>|last | -pit <time> | -scn <scn>}=?

So you

either use

-seq 692529587 *or*
-seq last *or*
-pit <time> *or*
-scn <scn>

The pipe | is a sign for "or".

Markus

[Former Member · Accepted solution]

now it showing this

oraprd> brrecover -c -t dbpit -b backPRD.log|last -f PRD -seq last

usage: last [-n number] [-f filename] [-a ] [name | tty]

[markus_doehr2 · Accepted solution]

> oraprd> brrecover -c -t dbpit -b backPRD.log|last -f PRD -seq last

> usage: last [-n number] [-f filename] [-a ] [name | tty]

You syntax is still wrong. I wonder why you use the pipe in the command - as I said before, it means "or" in the syntax. Try

brrecover -c -t dbpit -b backPRD.log -seq last

Markus

[markus_doehr2 · Accepted solution]

Typo - sorry, try

brrecover -c -t dbpit -b backPRD.log -f PRD -seq last

Markus

[Former Member · Accepted solution]

oraprd> brrecover -c -t dbpit -b backPRD.log -seq last

BR0701I BRRECOVER 7.00 (32)

BR0156E Illegal value 'backPRD.log' found for option '-b'

BR0156E Illegal value 'last' found for option '-seq'

BR0280I BRRECOVER time stamp: 2009-07-30 17.59.48

BR0700E Fatal errors occurred - terminating processing...

BR0797I Number of restored/recovered database files: 0/0

BR0798I Number of restored/applied incremental files: 0/0

BR0799I Number of restored/applied archivelog files: 0/0

BR0706I End of database recovery: vebdcmem.log 2009-07-30 17.59.48

BR0280I BRRECOVER time stamp: 2009-07-30 17.59.48

BR0704I BRRECOVER terminated with errors

[Former Member · Accepted solution]

oraprd> brrecover -c -t dbpit -b backPRD.log -f PRD -seq last

BR0701I BRRECOVER 7.00 (32)

BR0156E Illegal value 'backPRD.log' found for option '-b'

BR0156E Illegal value 'last' found for option '-seq'

BR0280I BRRECOVER time stamp: 2009-07-30 18.10.01

BR0700E Fatal errors occurred - terminating processing...

BR0797I Number of restored/recovered database files: 0/0

BR0798I Number of restored/applied incremental files: 0/0

BR0799I Number of restored/applied archivelog files: 0/0

BR0706I End of database recovery: vebdcncb.log 2009-07-30 18.10.01

BR0280I BRRECOVER time stamp: 2009-07-30 18.10.01

BR0704I BRRECOVER terminated with errors

error is same

[Former Member · Accepted solution]

this is working

oraprd> brrecover -c -t dbpit -b last -f PRD -seq 1399

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Database point-in-time recovery main menu

1 + Set point-in-time for recovery

2 + Select database backup

3 + Check the status of database files

4 + Restore control files

5 = Restore data files

6 # Restore split control files

7 # Restore and apply incremental backup

8 * Restore and apply archivelog files

9 * Open database and post-processing

10 * Exit program

11 - Reset program status

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0617I Database instance PRD is started

BR0750I Database instance PRD will be mounted now

BR0280I BRRECOVER time stamp: 2009-07-31 12.21.03

BR0307I Shutting down database instance PRD ...

BR0280I BRRECOVER time stamp: 2009-07-31 12.21.10

BR0308I Shutdown of database instance PRD successful

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

BR0280I BRRECOVER time stamp: 2009-07-31 12.21.10

BR0330I Starting and mounting database instance PRD ...

BR0278E Command output of '/oracle/PRD/102_64/bin/sqlplus /nolog < /oracle/PRD/sapbackup/.vebdgdtu.spi':

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jul 31 12:21:10 2009

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

SQL> Connected to an idle instance.

SQL>

SQL> ORACLE instance started.

Total System Global Area 7029653504 bytes

Fixed Size 2192976 bytes

Variable Size 3536718256 bytes

Database Buffers 3489660928 bytes

Redo Buffers 1081344 bytes

ORA-00205: error in identifying control file, check alert log for more info

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production

With the Partitioning, Data Mining and Real Application Testing options

BR0280I BRRECOVER time stamp: 2009-07-31 12.21.17

BR0279E Return code from '/oracle/PRD/102_64/bin/sqlplus /nolog < /oracle/PRD/sapbackup/.vebdgdtu.spi': 0

BR0302E SQLPLUS call for database instance PRD failed

BR0332E Start and mount of database instance PRD failed

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

BR0280I BRRECOVER time stamp: 2009-07-31 12.21.17

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

[Former Member · Accepted solution]

hi Markus

we have restored the backup successfully in different SID's ,

1-- Now we want to restore backup on targert system which have same SID liike source system ....

2-- Secondly tell me that for doing this which options we have to use BRRECOVER or BRRESTORE.

3-- Tell us the sap note for that thing...

regards

imran

[markus_doehr2 · Accepted solution]

> 1-- Now we want to restore backup on targert system which have same SID liike source system ....

No difference.

> 2-- Secondly tell me that for doing this which options we have to use BRRECOVER or BRRESTORE.

read the note I posted

> 3-- Tell us the sap note for that thing...

There is no different note for "same <SID>" vs. "different <SID>".

Markus