| RMAN Backup for two identically named databases [message #409832] |
Wed, 24 June 2009 03:53  |
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 |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
