hi mark,
>does rman ever check existing backup
> files - will it look for
> the last full backup before backing up todays
> archive logs etc
RMAN simply backs up whatever u ask it to back up
(db/tblspace, etc) .. it does not do any sanity
checks.. note that it records all entries for
succesfull backups in the catalog db (& most of it in
the target control file also)
> back it up as a datafile
> using rman, and back
> up rbs & system, then I can can discard all archive
> logs for that day -
> right?
after every full db backup, u no longer need the
archives. but folks still kep em to ensure that in
case restore using current full backup fails, then
they could restore using the "not current" full db
backup. ur method will work assuming that all other
tablespaces other than ur transaction tablespaces do
not change and are static .. so u will be able to
restore 100% even if u deleted ur archives at the end
of the day. (its a risky approach all the same .. i
feel)
hth
deepak
--- Mark Teehan <[EMAIL PROTECTED]> wrote:
> Hi folks,
> I want to gzip up my rman backups, which are to
> disk. I do a full at the
> weekend, and archive logs daily. I know that rman
> cant cope with zipped
> files, and I will have to unzip them myself before
> attempting a restore. My
> question is - does rman ever check existing backup
> files - will it look for
> the last full backup before backing up todays
> archive logs etc - or once
> backed up, does it ignore backup files until I ask
> for a restore?
>
> My databases's are OLTP, with a datafile |
> tablespace containing each days
> partitions. Apart from system, rbs there are only
> transaction tablespaces
> (one per day) in the database. Assuming I can switch
> each transaction table
> to read only at end of day, back it up as a datafile
> using rman, and back
> up rbs & system, then I can can discard all archive
> logs for that day -
> right? So a typical scenario will have 14 datafiles
> backed up (the DB keeps
> 2 weeks data), each with RBS & system from that day,
> and archivelogs for
> the last day only for PIT recovery. Im about to
> spend a few days testing
> this out - anyone know if it will work/fail?
>
> Thanks
> Mark Teehan
> Singapore.
>
> ---------------------------- ERG Group
> --------------------------
> The contents of this email and any attachments are
> confidential
> and may only be read by the intended recipient.
>
-----------------------------------------------------------------
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Mark Teehan
> 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).
__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deepak Thapliyal
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).
