| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: gzip'ing rman backups
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 <mteehan_at_erggroup.com> 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: Deepak Thapliyal INET: deepakthapliyal_at_yahoo.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).Received on Mon Sep 03 2001 - 21:02:57 CDT
 |
 |