Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Legato oracle module.
Hi Ron,
If you are deciding to do incremental backups you ideally need to do a incremental level 0 backup before proceeding. RMAN doesn't like doing incrementals if you don't.
Also, the size of the RMAN backup dump is actually a lot smaller than you think because it only ever backs up the blocks used.
Another way that you could try and possibly save the costs is to just get new disks for your database machine. Create the recovery catalog database so that all the files reside on those disks (ie the target database should not be on those disks at all). Another disk seperate from the above can be used for dumping the database images. That way at least your recovery catalog database has some degree of seperation from the target database (you're at least covered for disk corruption - not a total machine crash). Depending on what you're restricted by you can try that.
Regs,
Sujatha
-----Original Message-----
Sent: Wednesday, 29 May 2002 10:58 PM
To: Multiple recipients of list ORACLE-L
RMAN Users,
I am just getting started in RMAN and have a question about the
recovery catalog that RMAN uses.
Does it have to be an Oracle database that stores the information
about the backup if you do not use the controlfile as the source of
backup information? For safety and disaster recovery purposes it should
reside on a different server than the database being backed up by RMAN.
Does that not mean that the recovery catalog server should also be
licensed by Oracle because you are using Oracle on another box? In the
case where you have 1 server for Oracle and one for recovery then should
you not have 2 licenses?
I am looking for the reliable and cheap way to use RMAN for backups?
Thanks,
Ron
ROR mª¿ªm
>>> Sujatha.Madan_at_cmc.cwo.net.au 05/28/02 08:23PM >>> 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).
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).
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).
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). Received on Wed May 29 2002 - 19:38:18 CDT