| Rman backup using recovery catalog fails [message #180217] |
Fri, 30 June 2006 17:03  |
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 #186057 is a reply to message #180941] |
Sat, 05 August 2006 06:53  |
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 |
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 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
