Oracle-L: RE: Legato oracle module.

From: Jenner Mike <M.Jenner_at_southampton.gov.uk>
Date: Wed, 29 May 2002 02:09:11 -0800
Message-ID: <F001.0046DBE9.20020529020911@fatcity.com>

Thanks to all tips,

I'll think about it. I may chose to do my own, as per Sujatha's suggestion. At least I know where I stand, should disaster hit the machine.

Mike Jenner
Database Administrator
C.P.S.
Southampton City Council.
m.jenner_at_southampton.gov.uk
02380 833985

-----Original Message-----
Sent: 29 May 2002 01:23
To: Multiple recipients of list ORACLE-L

Hi Mike,

I've been using the Legato/RMAN combination for a couple of years now. The recovery catalog resides on the Legato Backup server. Once all the database backups finish, we then do a cold backup of the recovery catalog database straight to tape.

I don't know what others do, but this if you can afford downtime for your recovery catalog db this is probably the best way to do it.

If you have enough disk space on your server, you actually don't need the Legato plugin. Just dump the backups to disk and get the normal Legato Networker server backup pick them up onto tape.

Regards,

Sujatha

-----Original Message-----
Sent: Wednesday, 29 May 2002 12:23 AM
To: Multiple recipients of list ORACLE-L

Hi everybody,

I've taken responsibility of a couple of Oracle systems on NT (in addition to my nice Solaris DBs). I'm setting up Legato to do the backups online using the Legato Networker Oracle Module. After checking the Legato docs, it seems that the only way of using this module is by integrating it with RMAN. is this right?

Now, I'm sure that RMAN can do a good and flexible job. I've played with it a little but I don't like the meeesssyyy way of backing up the RMAN catalog.
In the Legato docs , there's a section that warns you :

" Preparing For Disaster
.
Ensure that your RMAN Recovery catalog is being backed up regularly. ."

Doesn't this imply that you need to perform the catalog backup outside legato yourself?, so why did we buy it in the first place? I know you could create another catalog to perform cross catalog backups but that all sounds far to complicated and error prone.

Anyone have any tips for me?

[I'm much happier with my online backup scripts on Unix that I've been using and tweeking for years.]

Mike.
Database Administrator

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jenner Mike
INET: M.Jenner_at_southampton.gov.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sujatha Madan
INET: Sujatha.Madan_at_cmc.cwo.net.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jenner Mike
INET: M.Jenner_at_southampton.gov.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------