BRRECOVER Giving Error

[Former Member]

Dear Friends,

I am trying for a recovery on sap system through BRRECOVER tool.

we are using tivoli as a backup storage software.

step of brrecover

1 = Check the status of database files

2 * Select database backup

3 * Restore data files

on first step it said.

BR0758I Data file /oracle/SSM/sapdata1/ssm_1/ssm.data1 not found - it will be re

stored/recreated and recovered

BR0758I Data file /oracle/SSM/sapdata1/ssm_2/ssm.data2 not found - it will be re

stored/recreated and recovered

BR0758I Data file /oracle/SSM/sapdata1/ssm_3/ssm.data3 not found - it will be re

stored/recreated and recovered

BR0758I Data file /oracle/SSM/sapdata1/ssm_4/ssm.data4 not found - it will be re

stored/recreated and recovered

BR0758I Data file /oracle/SSM/sapdata1/ssm_5/ssm.data5 not found - it will be re

stored/recreated and recovered

BR0758I Data file /oracle/SSM/sapdata1/ssm_6/ssm.data6 not found - it will be re

stored/recreated and recovered

BR0758I Data file /oracle/SSM/sapdata1/ssm620_1/ssm620.data1 not found - it will

be restored/recreated and recovered

BR0758I Data file /oracle/SSM/sapdata1/ssm620_2/ssm620.data2 not found - it will

be restored/recreated and recovered

BR0758I Data file /oracle/SSM/sapdata1/ssm620_3/ssm620.data3 not found - it will

be restored/recreated and recovered

BR0758I Data file /oracle/SSM/sapdata1/ssmusr_1/ssmusr.data1 not found - it will

be restored/recreated and recovered

BR0758I Temporary file /oracle/SSM/sapdata1/temp_1/temp.data1 not found - it wil

l be recreated after recovery

BR0758I Data file /oracle/SSM/sapdata1/undo_1/undo.data1 not found - it will be

restored/recreated and recovered

BR0758I Data file /oracle/SSM/sapdata1/system_1/system.data1 not found - it will

be restored/recreated and recovered

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

But when it go for step 3 for recovering data files i got following error

BR0386E File /oracle/SSM/sapdata1/ssm_5/ssm.data5 reported as not found by backu

p utility

BR0386E File /oracle/SSM/sapdata1/ssm_1/ssm.data1 reported as not found by backu

p utility

BR0386E File /oracle/SSM/sapdata1/ssm_3/ssm.data3 reported as not found by backu

p utility

BR0386E File /oracle/SSM/sapdata1/ssm_4/ssm.data4 reported as not found by backu

p utility

BR0386E File /oracle/SSM/sapdata1/ssm620_2/ssm620.data2 reported as not found by

backup utility

BR0386E File /oracle/SSM/sapdata1/ssm620_1/ssm620.data1 reported as not found by

backup utility

BR0386E File /oracle/SSM/sapdata1/ssmusr_1/ssmusr.data1 reported as not found by

backup utility

BR0386E File /oracle/SSM/sapdata1/ssm620_3/ssm620.data3 reported as not found by

backup utility

BR0386E File /oracle/SSM/sapdata1/system_1/system.data1 reported as not found by

backup utility

BR0386E File /oracle/SSM/sapdata1/ssm_6/ssm.data6 reported as not found by backu

p utility

BR0386E File /oracle/SSM/sapdata1/ssm_2/ssm.data2 reported as not found by backu

p utility

BR0386E File /oracle/SSM/sapdata1/undo_1/undo.data1 reported as not found by bac

kup utility

BKI1215I: Average transmission rate was 0.000 GB/h (0.000 MB/sec).

BKI0020I: End of program at: Mon Apr 28 09:27:44 SAUST 2008 .

BKI0021I: Elapsed time: 01 sec .

BKI0024I: Return code is: 2.

BR0280I BRRESTORE time stamp: 2008-04-28 09.27.44

BR0279E Return code from '/usr/sap/SSM/SYS/exe/run/backint -u SSM -f restore -i

/oracle/SSM/sapbackup/.rdxulsci.lst -t file -p /oracle/SSM/920_64/dbs/initSSM.ut

l': 2

BR0374E 0 of 12 files restored by backup utility

BR0280I BRRESTORE time stamp: 2008-04-28 09.27.44

BR0231E Backup utility call failed

BR0406I End of file restore: rdxulsci.rsb 2008-04-28 09.27.44

BR0280I BRRESTORE time stamp: 2008-04-28 09.27.44

BR0404I BRRESTORE terminated with errors

any idea what's wrong with it. why its unable to locate data files from backup.

any help higly appricated.

regards,

Malik

[JPReyes]

Seems to me that your backup is incomplete... theres lots of tablespaces not found. what kind of backup you runned?

Regards

Juan

[Former Member]

Dear Juan,

THanks for the reply.

We are taking complete offline backup.

Then how its possible that backup dont have these files.

is there any possibility to check the backup manually.

one thing which i notice

in first step its saying these are the files which will be restored.

and in second phase its giving me the error with all that files.

this means all files are not availabe in the backup?

regards,

malik