RE: rman centralized backup server

Excellent!! Now if we could just do something about those pesky hurricanes....

I'm actually heading down to Florida next week for a cruise.... I hope.

RF

-----Original Message-----
From: Paula_Stankus_at_doh.state.fl.us
To: Freeman Robert - IL; oracle-l-bounce_at_freelists.org; Graeme.Farmer_at_mincom.com
Cc: oracle-l_at_freelists.org; thomas.mercadante_at_labor.state.ny.us Sent: 9/15/2004 11:32 AM
Subject: RE: rman centralized backup server

Robert,

I went back and looked and as a matter of fact I really do have the same binaries as my target database.

So -

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_at_tusc.com] Sent: Wednesday, September 15, 2004 12:07 PM To: Stankus, Paula G; 'oracle-l-bounce_at_freelists.org '; 'Graeme.Farmer_at_mincom.com '
Cc: 'oracle-l_at_freelists.org '; 'thomas.mercadante_at_labor.state.ny.us ' 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_at_freelists.org
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
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:  

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----- From: Graeme.Farmer_at_mincom.com [mailto:Graeme.Farmer_at_mincom.com] Sent: Wednesday, September 15, 2004 11:09 AM To: Stankus, Paula G
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

Hi Paula,

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).

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.

Regards

Graeme

<Paula_Stankus_at_doh.state.fl.us>

Sent by: oracle-l-bounce_at_freelists.org

16/09/2004 12:52 AM

Please respond to
Paula_Stankus_at_doh.state.fl.us

To
<thomas.mercadante_at_labor.state.ny.us>, <oracle-l_at_freelists.org>

cc

Subject
rman centralized backup server         

Guys,

In order to manage and provide easier d/r for the oracle infrastructure =
I have setup a centralized rman catalog and for redundancy another copy =
of the same. Here is my concern:

We are going to be installing a new instance of 10G on Linux. I = currently have my centralized RMAN running on Solaris - could I backup = the 10G databases on Linux with RMAN on Solaris - would I need to have = 10G RMAN on Solaris to make that happen?

Thanks,
Paula

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



-- 
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.


  _____  

Teach CanIt if this mail (ID 10171046) is spam:
Spam


<https://dohsmsi01.doh.state.fl.us/canit/b.php?c=s&i=10171046&m=0baf671c

86af> 
Not


<https://dohsmsi01.doh.state.fl.us/canit/b.php?c=n&i=10171046&m=0baf671c

86af> spam
Forget


<https://dohsmsi01.doh.state.fl.us/canit/b.php?c=f&i=10171046&m=0baf671c

86af> previous vote



--
http://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=s&i=10178265&m=b4e173af3
b7d
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=n&i=10178265&m=b4e173af3
b7d
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=f&i=10178265&m=b4e173af3
b7d
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS
--
http://www.freelists.org/webpage/oracle-l