When i recover Oracle database....

From: ¹ÚÇü¼® <uxguru_at_becsolutions.com>
Date: Wed, 18 Aug 2004 11:11:22 +0900
Message-ID: <cfudot$5d$1@news1.kornet.net>

On Oracle 9i, I'm tried to recover database using rman. I know that i have to do next sequence.

1. shutdown database.
2. startup with mount option.
3. start rman with catalog database.
4. recover.
5. restore.

But, i have a problem.
When rman start, error occurred.
That is Oracle is "ORACLE initialization or shutdown in progress", or "not connected to ORACLE"

More detail message is....

---

---

[oracle_at_expr oracle]$ /oracle/product/9.2.0/bin/rman target sys/ukigima catalog rman_901/ukigima_at_ora9

Recovery Manager: Release 9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: ORA9 (DBID=298303666)

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

RMAN-00554: initialization of internal recovery manager package failed RMAN-04004: error from recovery catalog database: ORA-01033: ORACLE initialization or shutdown in progress

---

---

RMAN> shutdown immediate;

database closed
database dismounted
Oracle instance shut down

RMAN> startup mount;

connected to target database (not started) Oracle instance started
database mounted

Total System Global Area 236000356 bytes

Fixed Size                      451684 bytes
Variable Size                201326592 bytes
Database Buffers              33554432 bytes
Redo Buffers                    667648 bytes

RMAN> reset database to incarnation 2;

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

RMAN-03002: failure of reset command at 08/18/2004 10:32:21 RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLE

---

---


When i work something on RMAN, error occurred as mentioned above evertime.
How to solve this problem?



website  : www.becsolutions.com
Mail addr: uxguru_at_becsolutions.com

Received on Tue Aug 17 2004 - 21:11:22 CDT