RE: rman centralized backup server

Hi Paula,
I created a 10G catalog and successfully registered an 8i, 9i and a 10G database in the same catalog so backwards compatability is likely to be OK (haven't checked the compat matrix, but this makes sense anyway).

Interestingly, compared with previous catalog versions, the list incarnation command shows only the currently selected database instead of showing all incarnations for all databases as it does in 8i/9i catalog. Makes it easier to see relevant information if you have a central RMAN catalog with many databases accessing it.

oracle_at_ora817.braveheart: /oracle/dba
> r rman

rman target / catalog rman/********@recman

Recovery Manager: Release 8.1.7.0.0 - Production

RMAN-06005: connected to target database: ORA817 (DBID=1647840552) RMAN-06008: connected to recovery catalog database

RMAN> list incarnation;

RMAN-03022: compiling command: list

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

------- ------- -------- ---------------- --- ---------- ----------
2956    2957    ORA817   1647840552       YES 1          30-DEC-02

RMAN> exit

Recovery Manager complete.
oracle_at_ora817.braveheart: /oracle/dba
> gfprd

oracle_at_gfprd.braveheart: /oracle/dba
> r rman

rman target / catalog rman/********@recman

Recovery Manager: Release 9.2.0.5.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: GFPRD (DBID=3426791695) connected to recovery catalog database
list in
RMAN> carnation;

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

------- ------- -------- ---------------- --- ---------- ----------
25      26      GFPRD    3426791695       YES 16911605   08-MAY-04

RMAN> exit

Graeme Farmer

<Paula_Stankus_at_doh.state.fl.us>
Sent by: oracle-l-bounce_at_freelists.org
16/09/2004 01:52 AM
Please respond to
Paula_Stankus_at_doh.state.fl.us

To
<Graeme.Farmer_at_mincom.com>
cc
<oracle-l_at_freelists.org>, <oracle-l-bounce_at_freelists.org>, <thomas.mercadante_at_labor.state.ny.us>
Subject
RE: rman centralized backup server

Me too Graeme. It is the Oracle rman binaries which sometimes required the same (and not a higher version). So I have the following:  

In fact, what I do is call this in all my KSHELL scripts for backups and recoveries and based on the database it handles the Oracle homes and (if necessary) catalog with a different RMANID string. It works and once I set it up for the databases (at initial install) I don't have to modify. I just copy my backup script and change the $DBNAME variable and I am done.  

case $DBNAME in
"ods") INTERNAL=user/pass

ORACLE_SID=ods

TARGET=user/pass

ORACLE_HOME=/opt/oracle/product/9.2.0

RMANID= <mailto:RMANID=user/pass_at_rmanconnectstring> user/pass_at_rmanconnectstring

;;

"empidev") INTERNAL=user/pass

ORACLE_SID=empidev

TARGET=user/pass

ORACLE_HOME=/opt/oracle/product/9.2.0

RMANID= <mailto:RMANID=user/pass_at_rmanconnectstring> user/pass_at_rmanconnectstring

;;

[Stankus, Paula G] -----Original Message-----

-- 
This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.



--
http://www.freelists.org/webpage/oracle-l