I will give these questions a shot. See my replies inline. Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
