RE: Need Suggestion for RMAN

I agree with you, if you loose controlfile you loose all information about your backup. Besides that, using recovery catalog you can use stored scripts to make your backups.

It is a wise decision to have one.

Ramon E. Estevez
com.banilejas_at_codetel.net.do <mailto:com.banilejas_at_codetel.net.do> 809-565-3121

-----Mensaje original-----
De: root_at_fatcity.com [mailto:root_at_fatcity.com]En nombre de Ron Yount Enviado el: Monday, 22 October, 2001 6:41 AM Para: Multiple recipients of list ORACLE-L Asunto: RE: Need Suggestion for RMAN

Oracle and I would advise using the rman catalog database. The 8.1.6 manual will detail for you the limitations of using the control file approach. One issue that stands out is... if you lose the control file (all copies), then you also lose all of the backup info stored in it... this could create a situation where automated recovery is not possible.

I have been using RMAN for over a year to backup 60 plus dev and prod databases. If there is anything I can do to assist you, feel free to send e-mail to ronwy_at_swbell.net.

-Ron-

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of C.S.Venkata
> Subramanian
> Sent: Monday, October 22, 2001 2:00 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Need Suggestion for RMAN
>
>
> Dear List,
> I need some suggestions for RMAN. For a quite sometime I have
> seen numerous mails regarding RMAN.
>
> We have 2 Production Databases located at different sites. We use
> RMAN to backup the databases. Daily incremental
> backups(Archivelogs, ControlFiles,parameter files, password file)
> Weekly Full backup(Datafiles,Archivelogs, ControlFiles,parameter
> files, password file). the backup are successfully tested in a
> development m/c and till date we didn't face any probs till date.
> But we are not using "Catalog Database" for storing the
> information. Instead we are using the target database's control
> file. We have also stimulated the recoveries based on the above.
>
> I want to know whether it is "mandatory" or "advisble" to use
> RMAN with or without a catalog database.
>
> Any views, suggestions are welcome.
>
> TIA
>
> Venkat
>
>
> Make a difference, help support the relief efforts in the U.S.
> http://clubs.lycos.com/live/events/september11.asp
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: C.S.Venkata Subramanian
> INET: csvenkata_at_lycos.com
>
> 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: Ron  Yount
  INET: ronwy_at_swbell.net

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: Ramon Estevez
  INET: com.banilejas_at_codetel.net.do

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