Home » RDBMS Server » Backup & Recovery » Rman backup using recovery catalog fails
Rman backup using recovery catalog fails [message #180217] Fri, 30 June 2006 17:03 Go to next message
Natraj
Messages: 53
Registered: March 2003
Member
Hi,
While doing RMAN backup with recovery catalog database it fails. We receive the below error.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/30/2006 16:37:52
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20011: target database incarnation is not current in recovery catalog

Recovery Manager complete.
When i connect to the recovery catalog and try to list the incarnation it showed the below message once.but later on it just gave a blank message which is weird!! i believe i understood why it behaves wierd sometimes i connect with no catalog and sometimes i connect with catalog database ...when i connect with no catalog this is below output.. however i still don't understand why backups fail when database appears good!!
RMAN> connect target system

target database Password:
connected to target database: ESRCSTG (DBID=3939219323)
using target database control file instead of recovery catalog

RMAN> list incarnation of database;


List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 ESRCSTG 3939219323 CURRENT 18116585 27-OCT-05

When i try to do resync catalog it failes with the RMAN-20011 error.target database incarnation is not current in the recovery catalog.
The database is up and running and everything seems to be fine!! just the backups atre failing which is causing concern for me.
Thanks!!!

[Updated on: Fri, 30 June 2006 17:05]

Report message to a moderator

Re: Rman backup using recovery catalog fails [message #180223 is a reply to message #180217] Fri, 30 June 2006 19:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Try
rman> reset database to incarnation Your_KEY;

Before executing , do a little research about this. The above command has consequences. Was the datbase recently restored?
When was the last time it has full valid backup?

[Updated on: Fri, 30 June 2006 19:36]

Report message to a moderator

Re: Rman backup using recovery catalog fails [message #180941 is a reply to message #180217] Wed, 05 July 2006 22:59 Go to previous messageGo to next message
lakher
Messages: 14
Registered: April 2006
Junior Member


reset database
Re: Rman backup using recovery catalog fails [message #186057 is a reply to message #180941] Sat, 05 August 2006 06:53 Go to previous messageGo to next message
rcoleman
Messages: 1
Registered: August 2006
Junior Member
I've got a similiar issue, but have already used the dbnewid utility. Now I have two databases with the same DB Key, i.e. prd1 and rel12. My backups are failing on prd1. See incarnation list below.

List of Database Incarnations
DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 2 PRD1 803717335 NO 1 04-JAN-03
1 238541 PRD1 803717335 NO 117901836 30-JUN-05
1 422279 REL12 803717335 YES 175330268 02-AUG-06

From my understanding, the DB Key is supposed to be unique so know what do I do?
Re: Rman backup using recovery catalog fails [message #187665 is a reply to message #186057] Mon, 14 August 2006 17:55 Go to previous messageGo to next message
Natraj
Messages: 53
Registered: March 2003
Member
i still continue to get this error, when i unregister and re-register the database the error goes and i can run the script manually, but when veritas net backup calls it the second time i get the error.
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20011: target database incarnation is not current in recovery catalog
also mahesh could you please mention if i reset database to your_key ,what is Your_key is it the db key, or inc key please let me know the exact column name.
Thanks raj
Re: Rman backup using recovery catalog fails [message #187666 is a reply to message #180217] Mon, 14 August 2006 18:08 Go to previous message
Natraj
Messages: 53
Registered: March 2003
Member
i did the following. please let me know to which key i must reset my database now.
RMAN> list incarnation of database;


RMAN> reset database;

database incarnation already registered

RMAN> list incarnation of database;


RMAN> unregister database;

database name is "NATSBX" and DBID is 3467697222

Do you really want to unregister the database (enter YES or NO)? yes
database unregistered from the recovery catalog

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN> list incarnation of database;


List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
4296446 4296455 NATSBX 3467697222 PARENT 1 Oct 14 2005 15:07:50
4296446 4296447 NATSBX 3467697222 CURRENT 1095086 Feb 17 2006 02:03:55

when i do a select from the recovery catalog database's dbinc table i get no rows.

select dbinc_key,db_key,db_name ,reset_scn,reset_time,parent_dbinc_key from dbinc where db_name='NATSBX';
No rows selected.
Previous Topic: recover tablespace gets RMAN-06054: media recovery requesting unknown log: thread 1 seq 27059 lowscn
Next Topic: backup a table!
Goto Forum:
  


Current Time: Mon Dec 05 09:15:27 CST 2016

Total time taken to generate the page: 0.14539 seconds