BRBackup Finished with errors

[Former Member]

Hi,

I have scheduled an offline backup on my QA database. BRBackup finished the comression of all the datafiles and while starting the database it has returned errors.

Error log is

BR0280I BRBACKUP time stamp: 2009-06-12 20.39.40

BR0063I 51 of 51 files processed - 147385.814 MB of 147385.814 MB done

BR0204I Percentage done: 100.00%, estimated end time: 20:39

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2009-06-12 20.39.42

BR0304I Starting and opening database instance IR1 ...

BR0278E Command output of '/oracle/IR1/102_64/bin/sqlplus':

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Jun 12 20:39:42 2009

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

SQL> Connected to an idle instance.

SQL>

SQL> ORACLE instance started.

Database mounted.

ORA-01157: cannot identify/lock data file 2 - see DBWR trace file

ORA-01110: data file 2: '/oracle/IR1/sapdata2/undo_1/undo.data1'

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

BR0280I BRBACKUP time stamp: 2009-06-12 20.39.50

BR0279E Return code from '/oracle/IR1/102_64/bin/sqlplus': 0

BR0302E SQLPLUS call for database instance IR1 failed

BR0306E Start and open of database instance IR1 failed

BR0280I BRBACKUP time stamp: 2009-06-12 20.39.50

BR0301E SQL error -1033 at location BrDbConnect-2, SQL statement:

'CONNECT /'

ORA-01033: ORACLE initialization or shutdown in progress

BR0310E Connect to database instance IR1 failed

BR0115I Compression rate for all files 3.3472:1

BR0056I End of database backup: beaubled.afd 2009-06-12 20.39.50

BR0280I BRBACKUP time stamp: 2009-06-12 20.39.50

BR0054I BRBACKUP terminated with errors

I am just wondering; will it be able to restore this database? Will BRRESTORE allows us to restore this?

Please help me in understanding this

Many Thanks

[former_member204746]

/oracle/IR1/sapdata2/undo_1/undo.data1 has bad permission.

or, you did not start brbackup with user ora[sid]

[Former Member]

Thanks for your answers.

I have already checked permissions and everything.

Issue is solved by 948294 SAP Notes.

My Database files are not mounted with 'cio' options.

[sunny_pahuja2]

Hi,

this error generally occurs when database is trying to restart and it does not find all files to open...

have you checked this file is present or not oracle/IR1/sapdata2/undo_1/undo.data1 ??

Please run below command the you will get to know which data file is missing ..

ALTER SYSTEM CHECK DATAFILES.

Also, please go thorugh below links:

http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/ora01157-cannot-identifylock-dat...

http://blog.vpire.com/?p=872

Hope it will work..

Thanks

Sunny