Brrestore error

[Former Member]

Dear Experts,

I am trying to dp, backup restoration. My brbackup was successfully completed.

I copied the files aeeerwgo.sve, backPRD.log, beeerfdg.and, and initPRD.sap into "/oracle/PRD/sapbackup/"

Stop SAP, Oracle, and Listener control. Logged in as ORA user.

Then execute the restoration command, "brrestore -c -p initPRD.sap" got an error.

Can any one suggest where i made an mistake.

Regads,

santhose

Process

**********

prdtest:oraprd 2> brrestore -c -p initPRD.sap

BR0401I BRRESTORE 7.00 (32)

BR0405I Start of file restore: reeeuqev.rsb 2010-09-24 21.42.53

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

BR0049W Last BRRESTORE run was probably killed

BR0460W Termination message not found in /oracle/PRD/sapbackup/beeerfdg.and - log file incomplete (this is OK if the log file was restored)

BR0280I BRRESTORE time stamp: 2010-09-24 21.42.54

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

c

BR0280I BRRESTORE time stamp: 2010-09-24 21.42.55

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0428W File /oracle/PRD/sapdata4/prd_1/prd.data1 will be overwritten

BR0428W File /oracle/PRD/sapdata4/prd_11/prd.data11 will be overwritten

BR0428W File /oracle/PRD/sapdata1/system_1/system.data1 will be overwritten

BR0280I BRRESTORE time stamp: 2010-09-24 21.42.55

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

c

BR0280I BRRESTORE time stamp: 2010-09-24 21.43.21

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

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

BR0280I BRRESTORE time stamp: 2010-09-24 21.43.21

BR0407I Restore of database: PRD

BR0408I BRRESTORE action ID: reeeuqev

BR0409I BRRESTORE function ID: rsb

BR0449I Restore mode: ALL

BR0419I Files will be restored from backup: beeerfdg.and 2010-09-24 04.59.28

BR0416I 49 files found to restore, total size 104690.383 MB

BR0423I Files will be decompressed

BR0421I Restore device type: disk

BR0420I Files will be restored from directory: /backup/beeerfdg

BR0280I BRRESTORE time stamp: 2010-09-24 21.43.21

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

c

BR0280I BRRESTORE time stamp: 2010-09-24 21.43.39

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0126I Unattended mode active - no operator confirmation required

BR0352I Decompressing /oracle/PRD/sapdata4/prd_1/prd.data1

BR0355I from /backup/beeerfdg/prd.data1.Z ...

#FILE..... /oracle/PRD/sapdata4/prd_1/prd.data1

#RESTORED. /backup/beeerfdg/prd.data1.Z #1/1

BR0280I BRRESTORE time stamp: 2010-09-24 21.51.07

BR0418I 1 of 49 files restored - 2000.008 MB of 104690.383 MB done

BR0204I Percentage done: 1.91%, estimated end time: 4:14

BR0001I *_________________________________________________

BR0352I Decompressing /oracle/PRD/sapdata4/prd_10/prd.data10

BR0355I from /backup/beeerfdg/prd.data10.Z ...

[root@prdtest sapbackup]# BR0280I BRRESTORE time stamp: 2010-09-24 22.09.08

BR0266E Program 'LANG=C gunzip -c /backup/beeerfdg/prd.data10.Z > /oracle/PRD/sapdata4/prd_10/prd.data10' interrupted, exit status: 9

BR0272E Execution of program 'LANG=C gunzip -c /backup/beeerfdg/prd.data10.Z > /oracle/PRD/sapdata4/prd_10/prd.data10' through pipe failed

BR0359E Restore of /oracle/PRD/sapdata4/prd_10/prd.data10 from /backup/beeerfdg/prd.data10.Z failed due to previous errors

BR0406I End of file restore: reeeuqev.rsb 2010-09-24 22.09.10

BR0280I BRRESTORE time stamp: 2010-09-24 22.09.17

BR0404I BRRESTORE terminated with errors

[Former Member · Accepted solution]

Dear volker,

Even if i enter the option f as you said its asking for over writting the files already restored.... i've pasted the message i got.

**************************************************

[root@prdtest ~]# su - oraprd

prdtest:oraprd 1> brrestore -c -p initPRD.sap -f reeeyvwa.rsb

BR0401I BRRESTORE 7.00 (32)

BR0405I Start of file restore: reefeczj.rsb 2010-09-26 20.03.23

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

BR0460W Termination message not found in /oracle/PRD/sapbackup/beeerfdg.and - log file incomplete (this is OK if the log file was restored)

BR0280I BRRESTORE time stamp: 2010-09-26 20.03.23

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

c

BR0280I BRRESTORE time stamp: 2010-09-26 20.03.41

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0460W Termination message not found in /oracle/PRD/sapbackup/reeeyvwa.rsb - log file incomplete (this is OK if the log file was restored)

BR0428W File /oracle/PRD/sapdata4/prd_1/prd.data1 will be overwritten

BR0428W File /oracle/PRD/sapdata4/prd_10/prd.data10 will be overwritten

BR0428W File /oracle/PRD/sapdata4/prd_11/prd.data11 will be overwritten

BR0428W File /oracle/PRD/sapdata4/prd_12/prd.data12 will be overwritten

BR0428W File /oracle/PRD/sapdata4/prd_13/prd.data13 will be overwritten

BR0428W File /oracle/PRD/sapdata1/system_1/system.data1 will be overwritten

BR0280I BRRESTORE time stamp: 2010-09-26 20.03.41

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

************************************************

What should i do??

Regards,

Santhosh Kumar.

[volker_borowski2 · Accepted solution]

Hmm, that is weird and may be buggy.

According to this

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/02/9f90e318689043b22134dafc8e46ac/frameset.htm

it should work this way, and I already used it, but that was quite a couple of months ago.

Anyway, if you do not manage to get the entire run in a single one, because it is

allways aborting, you might need to do it one by one or manually.

Check this log

/oracle/PRD/sapbackup/beeerfdg.and

for all messages of datafiles being backed up. "Grep" what you need and you can make a script

grep "#SAVED" /oracle/PRD/sapbackup/beeerfdg.and

might be something to start with.

brrestore -c -p initSID.sap -b beeerfdg.and -m /oracle/PRD/sapdata1/system_1/system.data1

brrestore -c -p initSID.sap -b beeerfdg.and -m /oracle/PRD/sapdata1/undo_1/undo.data1

:

:

This way, you get a single brrestore run for each datafile.

The ones that go ok, leave them alone.

The ones that abort, repeat and try again until successfull.

Be very sure about a file being restored ok is not being written to later again by another run,

that aborts. This will garble the datafile.

Sounds ugly and it definately does not have to go this way,

but if you can't get it to work otherwise, it might be a way to work around it.

In the end you might need to restore the controlfile as well (to all three mirror locations)

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/02/9f90e318689043b22134dafc8e46ac/frameset.htm

brrestore -m 0 ...

and then start to get the archivelogs you need.

You might need to do the actual recovery manualy from sqlplus.

Volker

Just thinkinig about something diffrent...

As you restored the backup protokoll, you are either restoring to a new box or to new filesystems...???

Did you enable to use large files on those?

The ones that succedd, are not only those smaller that 2G and when something has to be grow bigger than that .. bonce ?

Edited by: Volker Borowski on Sep 26, 2010 5:02 PM

[Former Member]

please help me out guys..

Regards,

santhosh Kumar.

[Former Member]

have you tried solution give by Varadhu

[Former Member]

opened another thread for this later issue..

[Former Member]

Hi guys,,,,

i done the restoration. now i can't able to open the database..when i tried to open the database it shows the following error.

ORA-01110: data file 1: '/oracle/PRD/sapdata1/system_1/system.data1'

ORA-01202: wrong incarnation of this file - wrong creation time.

i've checked the locations of the control files. nothing wrong in that.. then i searched. all advised to take a fresh database and archieve backup and restore that. so i took a fresh backup and restored that. now i tried to start the database. now also its not opening stating the same..

this is what i've done after restoration.

************************

SQL> conn /as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 331350016 bytes

Fixed Size 1260684 bytes

Variable Size 318767988 bytes

Database Buffers 8388608 bytes

Redo Buffers 2932736 bytes

Database mounted.

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> select OPEN_RESETLOGS from v$database;

OPEN_RESETL

-

---

ALLOWED

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01122: database file 1 failed verification check

ORA-01110: data file 1: '/oracle/PRD/sapdata1/system_1/system.data1'

ORA-01202: wrong incarnation of this file - wrong creation time

********************************************

getting same error as before while altering database..

please help me guys..

what will be the problem..

Thanks and Regards,

Santhosh Kumar.

[Former Member]

are you restoring from online or offline backup? If this is a online backup then you also need to apply redo logs created during the backup.

Startup mount

recover automatic database until cancel using backup controlfile;

[Former Member]

Hi,

How to restore the Redo logs. please help me. am new to SAP.

i've executed the command as you given. getting the same error..

********************************

SQL> startup mount

ORACLE instance started.

Total System Global Area 331350016 bytes

Fixed Size 1260684 bytes

Variable Size 318767988 bytes

Database Buffers 8388608 bytes

Redo Buffers 2932736 bytes

Database mounted.

SQL> recover automatic database until cancel using backup controlfile;

ORA-00283: recovery session canceled due to errors

ORA-01110: data file 1: '/oracle/PRD/sapdata1/system_1/system.data1'

ORA-01122: database file 1 failed verification check

ORA-01110: data file 1: '/oracle/PRD/sapdata1/system_1/system.data1'

ORA-01202: wrong incarnation of this file - wrong creation time

******************************************

Thanks and regards,

Santhosh Kumar.

[Former Member]

Hi,

How to restore the Redo logs. please help me. am new to SAP.

i've executed the command as you given. getting the same error..

********************************

SQL> startup mount

ORACLE instance started.

Total System Global Area 331350016 bytes

Fixed Size 1260684 bytes

Variable Size 318767988 bytes

Database Buffers 8388608 bytes

Redo Buffers 2932736 bytes

Database mounted.

SQL> recover automatic database until cancel using backup controlfile;

ORA-00283: recovery session canceled due to errors

ORA-01110: data file 1: '/oracle/PRD/sapdata1/system_1/system.data1'

ORA-01122: database file 1 failed verification check

ORA-01110: data file 1: '/oracle/PRD/sapdata1/system_1/system.data1'

ORA-01202: wrong incarnation of this file - wrong creation time

******************************************

Thanks and regards,

Santhosh Kumar.

[volker_borowski2]

> i done the restoration. now i can't able to open the database..when i tried to open the database it shows the following error.

HOW did you do it?

Obviously the current controlfile does not belong to the database restored...

Volker

[Former Member]

Hi volker,

i've taken the online backup and restored the database by "brrestore -c -p initPRD.sap" and restored the archieve logs by the "brrestore -a 1182-11115". and both the restoration completed successfully. the error is while starting the database. the database is mounted but not opened.. i've checked the control files in the locations mentioned in initPRD.ora file. all files are created at same time of restoration only..

Regards,

Santhosh Kumar.

[volker_borowski2]

Hi,

check the *.rsb log for the section, where it did restore the controlfiles.

Esp. where it took the source from and if the traget corresponds to your expected locations.

If everything fails, you still can create new controlfiles, but it would be better to get

the correct binary ones to work.

Volker

[volker_borowski2]

OK, I just see you opened another thread for this, so I'll stop writing here.

Looking in the other thread it looks like you already tried an OPEN RESETLOGS without

doing a recovery before ....

Volker

[Former Member]

HI guys,

i've created a new control file and that issue is solved now.. now the database is mounted and opened..

now i can't able to start SAP. when i start SAP, its giving error messages as,

**************************************

prdtest:prdadm 1> startsap

Checking PRD Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

23:52:01 08.10.2010 LOG: Effective User Id is root

***********************************************************************

• This is Saposcol Version COLL 20.95 700 - v2.12, Intel x86 with Linux, 2008/01/02

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 11053) is already running .....

************************************************************************

saposcol already running

Running /usr/sap/PRD/SYS/exe/run/startdb

Trying to start PRD database ...

Log file: /home/prdadm/startdb.log

/usr/sap/PRD/SYS/exe/run/startdb: Terminating with error code 12

DB startup failed

************************************************

but the database is mounted and opened now..

what should i do now??

Thanks and Regards,

Santhosh Kumar.

[Former Member]

Hi varudhu, its my R3 trans log. its telling invalid username/password. login denied. tell me clearly how to change password or create OPS user. ****************************************************************************************************************************************************** 4 ETW000 R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00). 4 ETW000 =============================================== 4 ETW000 4 ETW000 date&time : 09.10.2010 - 03:52:28 4 ETW000 control file: 4 ETW000 R3trans was called as follows: R3trans -x 4 ETW000 trace at level 2 opened for a given file pointer 4 ETW000 [dev trc ,00000] Sat Oct 9 03:52:28 2010 131 0.000131 4 ETW000 [dev trc ,00000] db_con_init called 26 0.000157 4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 48 0.000205 4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' ... 4 ETW000 57 0.000262 4 ETW000 [dev trc ,00000] load shared library (/usr/sap/PRD/SYS/exe/run/dboraslib.so), hdl 0 4 ETW000 14728 0.014990 4 ETW000 [dev trc ,00000] Library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' loaded 4 ETW000 34 0.015024 4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so 4 ETW000 47 0.015071 4 ETW000 [dev trc ,00000] Version of '/usr/sap/PRD/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.144) 4 ETW000 85 0.015156 4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so 4 ETW000 34 0.015190 4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.so 4 ETW000 53 0.015243 4 ETW000 [dev trc ,00000] New connection 0 created 34 0.015277 4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO 4 ETW000 41 0.015318 4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 39 0.015357 4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse: 4 ETW000 35 0.015392 4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO 4 ETW000 34 0.015426 4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 344 0.015770 4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 38 0.015808 4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 3176 0.018984 4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 48 0.019032 4 ETW000 [dev trc ,00000] Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 250407) 4 ETW000 33 0.019065 4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch 4 ETW000 41 0.019106 4 ETW000 [dev trc ,00000] 0 WE8DEC 1 0x8eb2468 0x8eb7ad4 0x8eb735c 4 ETW000 34 0.019140 4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 39 0.019179 4 ETW000 [dev trc ,00000] Allocating server context handle 52 0.019231 4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=0x8eb72e8,srvhp=0x8ebbcfc) 4 ETW000 80 0.019311 4 ETW000 [dev trc ,00000] Assigning server context 0x8ebbcfc to service context 0x8eb72e8 4 ETW000 33165 0.052476 4 ETW000 [dev trc ,00000] Allocating user session handle 66 0.052542 4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x8eb72e8,srvhp=0x8ebbcfc,usrhp=0x8ee6a7c) 4 ETW000 64 0.052606 4 ETW000 [dev trc ,00000] Assigning user session 0x8ee6a7c to service context 0x8eb72e8 4 ETW000 12328 0.064934 4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END; 4 ETW000 82 0.065016 4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END; 4 ETW000 153 0.065169 4 ETW000 [dev trc ,00000] Now '/@PRD' is connected (con_hdl 0, nls_hdl 0). 4 ETW000 5795 0.070964 4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY 4 ETW000 54 0.071018 4 ETW000 [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1) 4 ETW000 566 0.071584 4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-1403 when accessing table SAPUSER 4 ETW000 2356 0.073940 4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1403 28 0.073968 4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 51 0.074019 4 ETW000 [dev trc ,00000] Rolling back transaction ... 37 0.074056 4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x8eb72e8,usrhp=0x8ee6a7c) 4 ETW000 304 0.074360 4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 832 0.075192 4 ETW000 [dev trc ,00000] Try to connect with default password 38 0.075230 4 ETW000 [dev trc ,00000] Connecting as SAPSR3/@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 250407) 4 ETW000 35 0.075265 4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch 4 ETW000 42 0.075307 4 ETW000 [dev trc ,00000] 0 WE8DEC 1 0x8eb2468 0x8eb7ad4 0x8eb735c 4 ETW000 34 0.075341 4 ETW000 [dev trc ,00000] Assigning username to user session 0x8ee6a7c 26 0.075367 4 ETW000 [dev trc ,00000] Assigning password to user session 0x8ee6a7c 36 0.075403 4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x8eb72e8,srvhp=0x8ebbcfc,usrhp=0x8ee6a7c) 4 ETW000 62 0.075465 4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017 4 ETW000 2611 0.078076 4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017' 4 ETW000 39 0.078115 4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 25 0.078140 4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1017 performing CON [dblink#5 @ 431] 4 ETW000 84 0.078224 4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#5 @ 431] 4 ETW000 35 0.078259 2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PRD'" ********************************************************************************************************************************************************** Thanks and Regards, Santhosh Kumar.

[Former Member]

Hi,

As per the note 400241, try to reset the password of the SAPOWNER with the following command at the OS level.

brconnect -u system/<password> -f chpass -o <sapowner> -p <password>

If this doesn't solve the issue, try to set the standard password to the SAPOWNER at the SQL prompt as follows.

ALTER USER <sapowner> IDENTIFIED BY sap;

NB: The above command will bypass the OPS$ mechanism.

I guess the same issue is duplicated in other thread also. Please close one of the threads to avoid it getting locked.

-Varadhu...

[Former Member]

not solved..facing another problem.. help me out guys.

[Former Member]

its solved..

[volker_borowski2]

Hi,

mind to say how you did it ?

Did you try one by one, or did you finally got a all-in-one run runing successfully?

If yes, what did you do to bypass the gunzip error?

Volker

[Former Member]

Hi...

No..

i tried one by one also, but its not working...there was some other issue with the system itself.. i raised the RAM from 3gb to 4gb.. then also it din work.. then i uninstalled and installed linux oly and tried to copy the media files of nearly 20GB. even that process also killed out of memory. so i changed the system.. that was with just 2gb ram. it was working good now.. now i finished restoration in that system... so, there was some problem with the hardware of the system..

Thank you all guys for your help..

Regards,

Santhosh Kumar.

[Former Member]

Dear varadhu,

Ii've checked...backup is successfully completed..i can see the time stamps.. but i can't find consecutive lines as u instructed..

Regards,

Santhosh Kumar.

[Former Member]

Dear Volker..

This is the message i got in uname -a.

**************************

[root@prdtest ~]# ulimit -a oraprd

core file size (blocks, -c) 0

data seg size (kbytes, -d) unlimited

file size (blocks, -f) unlimited

pending signals (-i) 1024

max locked memory (kbytes, -l) 32

max memory size (kbytes, -m) unlimited

open files (-n) 1024

pipe size (512 bytes, -p) 8

POSIX message queues (bytes, -q) 819200

stack size (kbytes, -s) 10240

cpu time (seconds, -t) unlimited

max user processes (-u) 44920

virtual memory (kbytes, -v) unlimited

file locks (-x) unlimited

********************************

should i change anything in this??

Regards,

Santhosh Kumar.

[volker_borowski2]

> [root@prdtest ~]# ulimit -a oraprd

> :

> :

> cpu time (seconds, -t) unlimited

Hi,

no, this looks ok !

Volker

[Former Member]

Hi,

BR0460W Termination message not found in /oracle/PRD/sapbackup/beeerfdg.and - log file incomplete (this is OK if the log file was restored)

The backup log file has not been terminated with the success message. This may be the issue. Can you check whether ur backup log beeerfdg.and has the entries as below.

BR0115I Compression rate for all files <compression rate>
BR0056I End of database backup: beeerfdg.and <date and time>
BR0280I BRBACKUP time stamp: <date and time>
BR0052I BRBACKUP completed successfully

regards,

Varadharajan M

[Former Member]

Dear Volker,

As u said i checked the quotas.. there is no quotas set in the system.. am using linux with oracle 10g.

then i used -f in the command, but its overwritting the previous restore but its not continuuing. here i've pasted the response..again its terminated for the same reason..

**************************************************

[root@prdtest ~]# edquota -u oraprd

No filesystems with quota detected.

[root@prdtest ~]# su - oraprd

prdtest:oraprd 1> brrestore -c -p -f initPRD.sap

BR0401I BRRESTORE 7.00 (32)

BR0155E No value found for option '-p'

BR0156E Illegal value 'initPRD.sap' found for option '-f'

BR0406I End of file restore: reefaifu.log 2010-09-26 01.30.46

BR0280I BRRESTORE time stamp: 2010-09-26 01.30.46

BR0404I BRRESTORE terminated with errors

prdtest:oraprd 2> brrestore -f -p initPRD.sap

BR0401I BRRESTORE 7.00 (32)

BR0405I Start of file restore: reefaihe.rsb 2010-09-26 01.31.22

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

BR0049W Last BRRESTORE run was probably killed

BR0280I BRRESTORE time stamp: 2010-09-26 01.31.22

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

c

BR0280I BRRESTORE time stamp: 2010-09-26 01.32.36

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0460W Termination message not found in /oracle/PRD/sapbackup/beeerfdg.and - log file incomplete (this is OK if the log file was restored)

BR0280I BRRESTORE time stamp: 2010-09-26 01.32.36

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

c

BR0280I BRRESTORE time stamp: 2010-09-26 01.32.46

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0460W Termination message not found in /oracle/PRD/sapbackup/reeeyvwa.rsb - log file incomplete (this is OK if the log file was restored)

BR0428W File /oracle/PRD/sapdata4/prd_1/prd.data1 will be overwritten

BR0428W File /oracle/PRD/sapdata4/prd_10/prd.data10 will be overwritten

BR0428W File /oracle/PRD/sapdata4/prd_11/prd.data11 will be overwritten

BR0428W File /oracle/PRD/sapdata4/prd_12/prd.data12 will be overwritten

BR0428W File /oracle/PRD/sapdata1/system_1/system.data1 will be overwritten

BR0280I BRRESTORE time stamp: 2010-09-26 01.32.46

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

c

BR0280I BRRESTORE time stamp: 2010-09-26 01.32.53

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

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

BR0280I BRRESTORE time stamp: 2010-09-26 01.32.53

BR0407I Restore of database: PRD

BR0408I BRRESTORE action ID: reefaihe

BR0409I BRRESTORE function ID: rsb

BR0449I Restore mode: ALL

BR0419I Files will be restored from backup: beeerfdg.and 2010-09-24 04.59.28

BR0416I 49 files found to restore, total size 104690.383 MB

BR0445I 0 files were already restored in the following run: reeeyvwa.rsb

BR0423I Files will be decompressed

BR0421I Restore device type: disk

BR0420I Files will be restored from directory: /backup/beeerfdg

BR0280I BRRESTORE time stamp: 2010-09-26 01.32.53

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

c

BR0280I BRRESTORE time stamp: 2010-09-26 01.32.56

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0352I Decompressing /oracle/PRD/sapdata4/prd_1/prd.data1

BR0355I from /backup/beeerfdg/prd.data1.Z ...

#FILE..... /oracle/PRD/sapdata4/prd_1/prd.data1

#RESTORED. /backup/beeerfdg/prd.data1.Z #1/1

BR0280I BRRESTORE time stamp: 2010-09-26 01.41.58

BR0418I 1 of 49 files restored - 2000.008 MB of 104690.383 MB done

BR0204I Percentage done: 1.91%, estimated end time: 9:25

BR0001I *_________________________________________________

BR0352I Decompressing /oracle/PRD/sapdata4/prd_10/prd.data10

BR0355I from /backup/beeerfdg/prd.data10.Z ...

#FILE..... /oracle/PRD/sapdata4/prd_10/prd.data10

#RESTORED. /backup/beeerfdg/prd.data10.Z #1/2

BR0280I BRRESTORE time stamp: 2010-09-26 01.57.14

BR0418I 2 of 49 files restored - 5260.016 MB of 104690.383 MB done

BR0204I Percentage done: 5.02%, estimated end time: 9:36

BR0001I ***_______________________________________________

BR0352I Decompressing /oracle/PRD/sapdata4/prd_11/prd.data11

BR0355I from /backup/beeerfdg/prd.data11.Z ...

#FILE..... /oracle/PRD/sapdata4/prd_11/prd.data11

#RESTORED. /backup/beeerfdg/prd.data11.Z #1/3

BR0280I BRRESTORE time stamp: 2010-09-26 02.08.08

BR0418I 3 of 49 files restored - 7260.023 MB of 104690.383 MB done

BR0204I Percentage done: 6.93%, estimated end time: 10:00

BR0001I ***_______________________________________________

BR0352I Decompressing /oracle/PRD/sapdata4/prd_12/prd.data12

BR0355I from /backup/beeerfdg/prd.data12.Z ...

#FILE..... /oracle/PRD/sapdata4/prd_12/prd.data12

#RESTORED. /backup/beeerfdg/prd.data12.Z #1/4

BR0280I BRRESTORE time stamp: 2010-09-26 02.19.29

BR0418I 4 of 49 files restored - 9260.031 MB of 104690.383 MB done

BR0204I Percentage done: 8.85%, estimated end time: 10:19

BR0001I ****______________________________________________

BR0352I Decompressing /oracle/PRD/sapdata4/prd_13/prd.data13

BR0355I from /backup/beeerfdg/prd.data13.Z ...

[root@prdtest ~]#

• . Tell me what to do??

Thanks and Regards,

Santhosh Kumar.

Edited by: santhoshkumarvellore on Sep 25, 2010 11:06 PM

[volker_borowski2]

Hi,

the exit code 9 refers to cpu, not filesystem quota. They might be user specific.

So what is "ulimit -a" as oraprd telling you ?

> prdtest:oraprd 1> brrestore -c -p -f initPRD.sap

Humm, at least I thought you would crosscheck the "-f" option and not simply typing it in.

BTW this is always a good advice for anything you get from any forum.

Alway crosscheck, otherwise you might get things worse.

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/0d/d30df04a0c11d182b80000e829fbfe/content.htm

So the correct use would be:

brrestore -c -p initPRD.sap -f logfilename of your aborted restore run

It analyzes the log for what has to be restored and what has already been restored and

does a restore only for the rest. If it fails again, you might need to switch the parameter to the

next aborted run, as some parts may be now restored from the first and some form the second run.

As for the message about the backup being incomplete...

This is normal, if you did restore the backup logfile itself as well.

(... because at the moment when it is saved, the backup is not yet "completed succesfully")

but it contains everything that is needed for a successfull restore.

Volker

[Former Member]

Thank you Volker and varadharajan.

Dear Varadharajan,

As u said i executed the cmd u said. i got the following response..

************************

prdtest:oraprd 1> brrestore -k yes -b beerfdg.and

BR0401I BRRESTORE 7.00 (32)

BR0156E Illegal value 'beerfdg.and' found for option '-b'

BR0406I End of file restore: reefahmt.log 2010-09-26 01.22.31

BR0280I BRRESTORE time stamp: 2010-09-26 01.22.31

BR0404I BRRESTORE terminated with errors

****************************************

tell me what to do\????

Thanks and regards,

Santhosh Kumar.

Edited by: santhoshkumarvellore on Sep 25, 2010 11:03 PM

[Former Member]

Hi,

Try with the following command.

brrestore -k yes -b beeerfdg.and

Regards,

Varadharajan M

[volker_borowski2]

Hm,

what OS are you on?

Gunzip ended with exit code 9 ...

exit code 9 means shortage of CPU quota on several linux versions.

See, if you have those in place and disable the quotas.

Decompressing is a high CPU activity.

When you configure to abort if a certain CPU level is reached, no wonder it terminates.

Volker

[volker_borowski2]

Oh,

and while you are fighting this, since you already restored parts successfully,

do try to do the repeats with the -f ( fillup ) option of brrestore.

No need to overwrite the already successfully restored datafile prd.data1 again, once it had been restored ok.

Volker

[Former Member]

hi guys,

This is the message i got in /var/log/messages.

message:

***************

Sep 24 20:47:10 prdtest kernel: 106438 bounce buffer pages

Sep 24 20:47:10 prdtest kernel: Free swap: 20423400kB

Sep 24 20:47:10 prdtest kernel: 718720 pages of RAM

Sep 24 20:47:10 prdtest kernel: 489344 pages of HIGHMEM

Sep 24 20:47:10 prdtest kernel: 7070 reserved pages

Sep 24 20:47:10 prdtest kernel: 359683 pages shared

Sep 24 20:47:10 prdtest kernel: 48 pages swap cached

Sep 24 20:47:10 prdtest kernel: Out of Memory: Killed process 12793 (brrestore).

Sep 24 21:00:28 prdtest su(pam_unix)[12680]: session closed for user oraprd

Sep 24 21:02:50 prdtest sshd(pam_unix)[12822]: session opened for user root by root(uid=0)

*********************************

It seems to be like memory issue.. but am running with 3gb od RAm and 20gb os swap memory..

Please guys, give me some suggestions....

Regards,

Santhosh Kumar.