Home » RDBMS Server » Backup & Recovery » RMAN incarnation issus (merged)
RMAN incarnation issus (merged) [message #402863] Tue, 12 May 2009 21:28 Go to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
On one of my databases, the reset log has happned about a couple of months ago. But my team has not registetered the new incarnation in the catalog and have been backing up the databases.

Please let me know if those backups that have been taken till date are useful or not?

I think we can use it if we can set the database to a certain incanation key. But I am not sure.

Pls advice.
KV

Report message to a moderator

RMAN incarnation issus [message #402865 is a reply to message #402863] Tue, 12 May 2009 21:30 Go to previous messageGo to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
On one of my databases, the reset log has happned about a couple of months ago. But my team has not registetered the new incarnation in the catalog and have been backing up the databases.

Please let me know if those backups that have been taken till date are useful or not?

I think we can use it if we can set the database to a certain incanation key. But I am not sure.

Pls advice.
KV

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 05/13/2009 03:17:59
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20003: target database incarnation not found in recovery catalog

Report message to a moderator

Re: RMAN incarnation issus [message #402866 is a reply to message #402865] Tue, 12 May 2009 21:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> But my team has not registetered the new incarnation in the catalog
Perhaps you should immediately register the current incarnation & do a fullbackup.

>Please let me know if those backups that have been taken till date are useful or not?
You should get a copy of your tested Recovery Procedure, grab a copy of most recent full backup and do a test DB restoration.
Then you'll know for sure exactly what you have.

Report message to a moderator

Re: RMAN incarnation issus [message #402867 is a reply to message #402865] Tue, 12 May 2009 21:57 Go to previous messageGo to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
I think reset database should do the job.

Report message to a moderator

Re: RMAN incarnation issus [message #402868 is a reply to message #402867] Tue, 12 May 2009 21:58 Go to previous messageGo to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
Thankyou.

I was just about to do a restoration that is when I 'discovered' that the production database incarnation is not the current one on the recovery catalog.

Report message to a moderator

Re: RMAN incarnation issus [message #402869 is a reply to message #402865] Tue, 12 May 2009 22:16 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I think reset database should do the job.
The choice to bet your job on "should do the job" rather than actually testing only impacts you (for now).

I'd know that I would sleep more soundly if I knew I had a documented & tested Recovery Plan that the junior night operator could follow & succeed.

You should be able to had the Recovery Plan to your mother & she would have a 100% success rate for completing the DB recovery.

The decision for future actions are all yours & so are the consequences (both good or bad).

Report message to a moderator

Re: RMAN incarnation issus [message #402870 is a reply to message #402869] Tue, 12 May 2009 22:19 Go to previous message
kudur_kv
Messages: 75
Registered: February 2005
Member
Cheers Mate!

Thanks for the advice.

Will do the needful to ensure I will have peaceful nights! Smile

Report message to a moderator

Previous Topic: How to Recover Data From redo files in oracle 8.1.5 (merged)
Next Topic: Validation failed for archived log
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 16:52:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.