Oracle-L: Re: RMAN error registering database

From: Danny Hughes <DHUGHES_at_knobias.com>
Date: Fri, 31 May 2002 05:43:28 -0800
Message-ID: <F001.00470B61.20020531054328@fatcity.com>

Thanks Cherie I saw that one too...I was hoping that there was another fix rather than having to shut our production database down, but after many hours on the phone with oracle and getting nowhere, I just recrreated the control file and it did solve my problem.

>>> Cherie_Machler_at_gelco.com 05/31/02 07:48AM >>>

Danny,

Many RMAN errors will show a hit when searching Metalink. I found the following related document on Metalink when I searched with the RMAN-10031 error:

fact: Oracle Enterprise Edtion 8.1.7

fact: Recovery Manager (RMAN)

symptom: Unable to register a database

symptom: RMAN-10035: exception raised in RPC: ORA-01403: no data found

     symptom: RMAN-10031: ORA-1403 occurred during call to DBMS_RCVCAT.
     CHECKBACKUPPIECE

     symptom: RMAN-03008: error while performing automatic resync of
     recovery
     catalog

     change: Upgrade to Oracle Server - Enterprise Edition 8.1.7

     cause: <Bug:1467871>
     Dummy records with status ¿D¿ inserted into BS table
     during backup.
     RMAN mishandles these records during sync of the recovery of the
     catalog.

fix:

Upgrade to Oracle Server 9i

Or use following workaround:

Rebuild the target database control file

References:
<Note:1012929.6>
How to Recreate the Controlfile

Hope this helped.

Cherie

                                                                                                                 
                    "Danny Hughes"                                                                               
                    <DHUGHES_at_knobi       To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>     
                    as.com>              cc:                                                                     
                    Sent by:             Subject:     RMAN error registering database                            
                    root_at_fatcity.c                                                                               
                    om                                                                                           
                                                                                                                 
                                                                                                                 
                    05/30/02 06:43                                                                               
                    PM                                                                                           
                    Please respond                                                                               
                    to ORACLE-L

when I try to register my database in RMAN, I get the following error..

RMAN-08002: starting full resync of recovery catalog
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03008: error while performing automatic resync of recovery catalog
RMAN-07004: unhandled exception during command execution on channel default
RMAN-10035: exception raised in RPC: ORA-01403: no data found
RMAN-10031: ORA-1403 occurred during call to DBMS_RCVCAT.CHECKBACKUPPIECE

does anyone know how to get around this problem...I have an ITAR open with oracle right now and wanted to try this forum while I am waiting on a resolution.

TIA Danny Hughes
DBA
Knobias.com
601-978-3399 x103
dhughes_at_knobias.com
www.knobias.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Danny Hughes
  INET: DHUGHES_at_knobias.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author:
  INET: Cherie_Machler_at_gelco.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danny Hughes
  INET: DHUGHES_at_knobias.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri May 31 2002 - 08:43:28 CDT

Re: RMAN error registering database - solved