RE: rman centralized backup server
- From: <Paula_Stankus@xxxxxxxxxxxxxxx>
- To: <FREEMANR@xxxxxxxx>, <oracle-l-bounce@xxxxxxxxxxxxx>, <Graeme.Farmer@xxxxxxxxxx>
- Date: Wed, 15 Sep 2004 12:32:03 -0400
Robert,
I went back and looked and as a matter of fact I really do have the same =
binaries as my target database.
So -=20
my OS' are the same and at the same level (except for the new Linux =
system)
my catalogs are appropriate for the target databases and are housed in =
one database
my binaries match my targets
I do recovery tests every few months just to make sure everything is =
working smoothly
Without your book to get me started I wouldn't have set it up the right =
way in the first place. However, I did and it works so well I really =
haven't had problems except with Networker which I do not support (but =
that is another story).
Thanks,
Paula
-----Original Message-----
From: Freeman Robert - IL [mailto:FREEMANR@xxxxxxxx]
Sent: Wednesday, September 15, 2004 12:07 PM
To: Stankus, Paula G; 'oracle-l-bounce@xxxxxxxxxxxxx ';
'Graeme.Farmer@xxxxxxxxxx '
Cc: 'oracle-l@xxxxxxxxxxxxx '; 'thomas.mercadante@xxxxxxxxxxxxxxxxx '
Subject: RE: rman centralized backup server
A general thought/comment...
The binaries are different from the catalog in that you should *always* =
use
the same binary version as the version of the database. It might work, =
it
might appear to work, but someday you might try to do some type of =
recovery
and it will all come crashing down... :-)
Just because something appears to work does not mean that it actually
does.... :-)
RF
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
To: Graeme.Farmer@xxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx;
thomas.mercadante@xxxxxxxxxxxxxxxxx
Sent: 9/15/2004 10:52 AM
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:
=20
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. =20
=20
case $DBNAME in
"ods") INTERNAL=3Duser/pass
ORACLE_SID=3Dods
TARGET=3Duser/pass
ORACLE_HOME=3D/opt/oracle/product/9.2.0
RMANID=3D <mailto:RMANID=3Duser/pass@rmanconnectstring>
user/pass@rmanconnectstring
;;
"empidev") INTERNAL=3Duser/pass
ORACLE_SID=3Dempidev
TARGET=3Duser/pass
ORACLE_HOME=3D/opt/oracle/product/9.2.0
RMANID=3D <mailto:RMANID=3Duser/pass@rmanconnectstring>
user/pass@rmanconnectstring
;;
[Stankus, Paula G] -----Original Message-----
From: Graeme.Farmer@xxxxxxxxxx [mailto:Graeme.Farmer@xxxxxxxxxx]
Sent: Wednesday, September 15, 2004 11:09 AM
To: Stankus, Paula G
Cc: oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx;
thomas.mercadante@xxxxxxxxxxxxxxxxx
Subject: Re: rman centralized backup server
Hi Paula,=20
You can certainly use the (8i/9i?) database on your Solaris server to
house a 10G RMAN catalog, the database version used to house the catalog
is largely irrelevant. What IS relevant is that you have a version of
RMAN catalog that is compatible with the RMAN binary you are using on
the target database (which usually means the CATALOG must be at least
the same version as the executable).=20
Whether you can use the same catalog to house 8i/9i/10g databases I am
not sure, you'll have to check compatability for that but I have
combined 8i/9i databases in a 9i catalog with no problem.=20
Regards=20
Graeme
<Paula_Stankus@xxxxxxxxxxxxxxx>=20
Sent by: oracle-l-bounce@xxxxxxxxxxxxx=20
16/09/2004 12:52 AM=20
Please respond to
Paula_Stankus@xxxxxxxxxxxxxxx
To
<thomas.mercadante@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>=20
cc
Subject
rman centralized backup server
=09
Guys,
In order to manage and provide easier d/r for the oracle infrastructure
=3D
I have setup a centralized rman catalog and for redundancy another copy
=3D
of the same. Here is my concern:
We are going to be installing a new instance of 10G on Linux. I =3D
currently have my centralized RMAN running on Solaris - could I backup =
=3D
the 10G databases on Linux with RMAN on Solaris - would I need to have =
=3D
10G RMAN on Solaris to make that happen?
Thanks,
Paula
--
//www.freelists.org/webpage/oracle-l
--=20
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.
_____ =20
Teach CanIt if this mail (ID 10171046) is spam:
Spam
<https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D10171046&m=3D0ba=
f671c
86af>=20
Not
<https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D10171046&m=3D0ba=
f671c
86af> spam
Forget
<https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D10171046&m=3D0ba=
f671c
86af> previous vote
--
//www.freelists.org/webpage/oracle-l
BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 10178265) is spam:
Spam: =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D10178265&m=3Db4e1=
73af3b7d
Not spam: =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D10178265&m=3Db4e1=
73af3b7d
Forget vote: =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D10178265&m=3Db4e1=
73af3b7d
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS
--
//www.freelists.org/webpage/oracle-l
Other related posts:
