Re: RMAN:To use or not to use a recovery catalog

We do no-rows exports (rows=n) of our large databases. It has come in useful for recreating objects (procedures, users, etc.). It isn't practical to export the data on these larger databases.

Jay

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

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, April 30, 2003 7:06 AM

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





**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay Hostetter
  INET: jhostetter_at_decommunications.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).