Unable to Restore Oracle Database from RMAN Backup file

[Former Member]

Dear Gurus,

We are in process of building a new system with backup/restore method. The source system is backed up using RMAN and while we try to restore the Database we get the following error

Did anyone come across this kind of situation, any guidance on this will be really helpful.

BR0280I BRRESTORE time stamp: 2011-01-16 08.50.12

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0351I Restoring /oracle/QBI/sapdata1/sr3_19/sr3.data19

BR0355I from /temporary_back/PBI/dbbackup/beekmpoz/sr3.data19.S ...

BR0278E Command output of 'SHELL=/bin/sh /oracle/QBI/102_64/bin/rman nocatalog':

Recovery Manager: Release 10.2.0.4.0 - Production on Sun Jan 16 08:50:12 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN>

RMAN> connect target *

connected to target database (not started)

RMAN> *end-of-file*

RMAN>

host command complete

RMAN>

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of allocate command at 01/16/2011 08:50:12

RMAN-06403: could not obtain a fully authorized session

ORA-01034: ORACLE not available

RMAN> 2> 3> 4>

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of allocate command at 01/16/2011 08:50:12

RMAN-06403: could not obtain a fully authorized session

ORA-01034: ORACLE not available

RMAN>

Recovery Manager complete.

BR0280I BRRESTORE time stamp: 2011-01-16 08.50.12

BR0279E Return code from 'SHELL=/bin/sh /oracle/QBI/102_64/bin/rman nocatalog': 1

BR0536E RMAN call for database instance QBI failed

BR0280I BRRESTORE time stamp: 2011-01-16 08.50.12

BR0556E Restore from full database backup using RMAN failed

BR0359E Restore of /oracle/PBI/sapdata1/sr3_19/sr3.data19 from /temporary_back/PBI/dbbackup/beekmpoz/sr3.data19.S failed due to previous errors

BR0406I End of file restore: refafoou.rsb 2011-01-16 08.50.12

BR0280I BRRESTORE time stamp: 2011-01-16 08.50.12

BR0404I BRRESTORE terminated with errors

Thanks in advance!

Sudhir

[audunlea_hansen]

Hi!

You need to start your database in nomount:

As ora<SID>:

sqlplus /nolog

connect / as sysdba

startup nomount;

exit; <- Important!

Then try again with your restore.

Regards

Audun

DBA