| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN:To use or not to use a recovery catalog
ak,
The majority of our database is, load in the AM and read all day. The
tables for the applications that are updated as the day progresses are
exported each day before the work day begins and then imported into my
test server as a form of standby.
Ron
>>> oramagic_at_hotmail.com 04/30/03 12:01PM >>>
Do you guys still use logical backup as one of the options . We are
not
using any export backup here . But sometime I think we I will have to
recover one table then an export /import can be helpful ? . But is it
good
for a db of size 50G ?
-ak
> Lizz,
> I use RMAN with a recovery catalog in this setup.
> Production and development servers OS = OpenVMS.
> RMAN control and schedule pc OS = LINUX.
> The production server "PROD" contains the data I want to protect.
> The development server "DEV" is my second server that contains 2
> instances DEV and RMAN.
> For ease of control and implementation I use the Linux pc to connect
to
> the target "PROD" and catalog "RMAN" instances and back the data up
to
> disk on the PROD server. The nightly tape backup copies the backup
data
> to tape for recovery purposes is needed. Each week the old backup is
> deleted from disk to free up space after the new full backup is
> completed by RMAN and backed up to tape.
> Weekly I also do a full export of the RMAN instance from the
> development server to the production server for the backup to tape.
With
> this method of using two servers, target and catalog, The recovery
info
> is on a different server reducing the chances of complete loss of
data
> in the event of a catastrofic event. The tapes are housed offsite
also.
> With using the recovery catalog option on a second server you are
> better protecting your recovery data.
> Of course the second server also requires an Oracle license as you
> have to have an Oracle instance to run it on. I never could quite
figure
> why you had to purchase an additional license just to use the data
> protection option that is supplied free.
> Ron
>
> >>> lizzpenaorclgrp_at_yahoo.com 04/29/03 07:51PM >>>
> All,I need some to use or not to use a recovery catalog via RMAN.
> Currently our system does not use a recovery catalog and backs up
via
> veritas netbackup using a script ( I supplied it ). I have little
RMAN
> experience and want to know if people are creating recovery catalog
on
> the same system as they are backing up. Any advised would be most
> welcomed. Thanks in advanced. Lizz
>
> ---------------------------------
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ron Rogers
> INET: RROGERS_at_galottery.org
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting
services
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: oramagic_at_hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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.net -- Author: Ron Rogers INET: RROGERS_at_galottery.org Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 Apr 30 2003 - 13:06:54 CDT
 |
 |