Re: Backup strategy using RMAN

I will give these questions a shot. See my replies inline. Ruth ----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, September 04, 2001 10:02 AM

> Hi all,
>
> I have been given an assignment to formulate different backup
> strategies for OLTP (24X7) and Datawarehouse applications using RMAN.
>
> Could you please help me on these factors i have considered....
>
> 1)what type of backup should i take ?
> Incremental,cumulative or full and on what all days should i take it
> (level of backup) w.r.t to these applications.
>
> We do a level 0 backup each morning before the users get on and a level
one each evening before batch. We backup the archivelogs each time and delete them. We put a complete set, level 0 and level 1 incremental and the corresponding archivelog backups on tape each day.

We keep the tapes for a week and them write over them. We would never be able to go back farther than a week anyway.

> 2)A backup solution for the RMAN catalog database.
I have my rman catalog in a small database which also hold my OEM repositoryl. I shut this down on Friday and do a cold OS backup.

> 3)what else needs to be considered for the same?
>
> You might want to have your rman catalog in a completely separate
database but I don't really think that it is necessary to use rman to back it up.

> Thanx in Advance,
> kind regards,
> Jothish
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: K. JOTHISH
> INET: jothish.k_at_tatainfotech.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: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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