Video Screencast Help

i can't restore an oracle database 11g R2 installed on Linux

Created: 23 Oct 2012 | 2 comments

hello ...

i have a full physical backup of the database... ( flat files ) .. and a Full logical backup ( table spaces and logs )

i had a problem.. so.. i have restored the flat files of the database.. and hence the database is up and running

i want now to restore the logical backup.. but the restore job finishes successfully after a very short time without restoring anything and it displays the following log messages ..

this is the RMAN output

SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 23 15:04:59 2012

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

 Connected.
 Database closed.
Database dismounted.
ORACLE instance shut down.
ORA-03113: end-of-file on communication channel
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Recovery Manager: Release 11.2.0.2.0 - Production on Tue Oct 23 15:05:11 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01033: ORACLE initialization or shutdown in progress

 
 
 # -----------------------------------------------------------------
 # RMAN command section
 # -----------------------------------------------------------------
 
 RUN {
 ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=10.224.0.72,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={26BBBD99-AEFB-4A35-8D13-08F48D6CDE94},NBBSA_DB_DEVICE_NAME=Oracle-Linux::\\dbprod.sinotharwa.net\PROD';
 
 RESTORE
     DATABASE;
 
 RECOVER
     DATABASE;
 
 RELEASE CHANNEL ch0;
 alter database open;
 }
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 10/23/2012 15:05:12
RMAN-06171: not connected to target database

 EXIT

Recovery Manager complete.

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

so.. i want to know why i can't restore the logical backup

Comments 2 CommentsJump to latest comment

Satish Pahlajani's picture

From the logs, it seems that RMAN is not able to connect to target database since Oracle initializtion or shutdown is in progress.

Since you have replaced the flat files I hope Oracle instance service is restarted. Request you to please restart all the services again of that Oracle instance (e.g. instance service, ASM service ).

After that can you please check whether you are manually able to start / shutdown the oracle instance from the sqlplus command prompt.

If you are able to start/shut the database successfully then it should now also work with BE.

Hope this helps.

vjuhola's picture

"ORA-01033: ORACLE initialization or shutdown in progress" that indicates that Oracle shutdown is still going on. Alternately you can issue shutdown abort to bring the database down.

"RMAN-06171: not connected to target database" says that you are not connected to the target database (the database you wish to restore to). Connect with following argument:

rman target username/password@target_database nocatalog

-v