Home » RDBMS Server » Backup & Recovery » RMAN Backup for two identically named databases (Oracle 10.2.0.4 AIX 5.3L ML7)
RMAN Backup for two identically named databases [message #409832] Wed, 24 June 2009 03:53 Go to next message
andriesb
Messages: 2
Registered: June 2009
Location: South Africa
Junior Member

Hi

I have a situation where six identically named databases (three each hosted on seperate servers) were registered with the same RMAN catalog.

I need to backup each of these databases, and restore from the catalog as well.

From my interaction with the catalog this morning when I found the 'problem':

$ rman target / catalog rman@sndoracat

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Jun 24 08:50:39 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: C012BAND (DBID=2513140596)
recovery catalog database Password:
connected to recovery catalog database

RMAN> run {
allocate channel c1 type sbt;
backup database tag "20090624 full RMAN backup";
release channel c1;
}
2> 3> 4> 5>
allocated channel: c1
channel c1: sid=120 devtype=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

Starting backup at 24-JUN-09
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/24/2009 08:50:55
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20020: database incarnation not set

RMAN> list incarnation of database c012band;


List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
295 302 C012BAND 2501569853 PARENT 1 10-MAY-08
295 296 C012BAND 2501569853 CURRENT 538113 12-FEB-09
304659 304666 C012BAND 2513140596 PARENT 1 10-MAY-08
304659 304660 C012BAND 2513140596 CURRENT 538113 22-JUN-09

DB Key 295 is the c012band database for the Code Drop 1 installation - which is being used and tested on (has been running for two months). DB Key 304659 is the c012band database for Code Drop 2 -- which is used and being tested on. (Installed in the last week)

CD1 c012band is on a different host from CD2 c012band.

Any advice. The project can't be stopped to resolve this by renaming the databases. Would cause delays in excess of two weeks due to the complexity of the installations on top of these databases. Aside from RMAN, everything is fine (even the backup of the c012band CD1 database using NetBackup was fine - no problems reported...)

How do I backup them -- is there a way to 'switch' between the incarnations for backup and restore (RESET DATABASE is not an option -- as far as I know this will 'merge' the incarnation of the two distinct databases into one on RMAN... not what I want)

Any and all advice/help gladly accepted.

====
I've tested the backup from both databases (c012band) connecting with 'rman target / catalog rman@sndoracat' and both backs up fine. Can't explain why I got the error this morning when executing the normal run block.

[Updated on: Wed, 24 June 2009 04:20]

Report message to a moderator

Re: RMAN Backup for two identically named databases [message #409849 is a reply to message #409832] Wed, 24 June 2009 04:25 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:

Oracle Error :: RMAN-20020

database incarnation not set
Cause

This an internal error.
Action

Contact Oracle Support Services.

Re: RMAN Backup for two identically named databases [message #409868 is a reply to message #409832] Wed, 24 June 2009 04:59 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What is the output while connected to the target and the recovery catalog and simply issuing the following:

RMAN> list incarnation;
Re: RMAN Backup for two identically named databases [message #409890 is a reply to message #409868] Wed, 24 June 2009 06:40 Go to previous messageGo to next message
andriesb
Messages: 2
Registered: June 2009
Location: South Africa
Junior Member

Thanks for the reply:

RMAN> list incarnation;

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------

304659 304666 C012BAND 2513140596 PARENT 1 10-MAY-08
304659 304660 C012BAND 2513140596 CURRENT 538113 22-JUN-09


--------------
RMAN appears to work fine with the backup of the individual databases when connecting with:

rman target / catalog rman@sndoracat

I've received advise that it would be best to create a different RMAN schema for each of the code-drops that are installed, so I'm looking into that to prevent me getting any more heart attackes from outputs like the one in my original post.
Re: RMAN Backup for two identically named databases [message #409894 is a reply to message #409890] Wed, 24 June 2009 06:53 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Since it appears that you recently did a OPEN RESETLOGS, doing a RESET DATABASE should be expected.
Previous Topic: Need a procedure to restore ASM RAC instance on to FileSystem.
Next Topic: Cold backup from windows to Unix
Goto Forum:
  


Current Time: Thu Dec 08 02:35:56 CST 2016

Total time taken to generate the page: 0.11219 seconds