Oracle-L: RE: rman

From: Mandal, Ashoke <ashoke.k.mandal_at_medtronic.com>
Date: Mon, 20 May 2002 07:18:25 -0800
Message-ID: <F001.00464890.20020520071825@fatcity.com>

Hi Fawzia,

It looks like the logs have been reset in the database. Either controlfile has been rebuilt or incomplete media recovery was done on the database.

My feeling is that at this point you need to reset the database and have new incarnation. Then you can change the incarnation to the old one and recover the database up to the point just before the resetlog was done.

You should be able to see the date from v$database when last time the resetlog was done on the database.

Good luck,
Ashoke

-----Original Message-----
Sent: Monday, May 20, 2002 8:58 AM
To: Multiple recipients of list ORACLE-L

Please can you help/advise with an rman problem we are having. We are getting the following error when trying to backup a database:

RMAN-20011: target database incarnation is not current in recovery catalog

If I look in the rman logs I see that our last valid backup was 16th May. The rman database shows that the rc_backup_file has an entry for that date- anything after that is blank.

Metalink has provided a solution to zero the dbid- what are the implications of this- it gives no information on that. The additional aspect is that I need to restore the 16th's backup onto our ref box so if zeroing the dbid will hose that backup..I'd rather avoid that??!!! : )

Any help would be REALLY appreciated!!!

Rgds

Fawzia

Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone.
Thank you for your co-operation.

--

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

Author: Mandal, Ashoke
INET: ashoke.k.mandal_at_medtronic.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 Mon May 20 2002 - 10:18:25 CDT