Re: gzip'ing rman backups

Hi,

if you want to check the file consistency, you will have to do it by hand. RMAN doesn't do it for you.
But, assuming you know the file structure to be backed up, do the following:
Write the file structure with ls to a file. Then, after you have your tared-gzipped files, apply a check with the gzips "t" option. Then, check for the contents of the file with the gzips "l" and tars "t" option and verify, that all the files in there are the same as in the file to which you wrote the contents of the filesystem you spooled in the beginning.

| Regards,                   |
| Stefan Jahnke              |
| BOV AG                     |
| @:D2 Vodafone, Abt.: FBOM  |
| Tel.: 0211/533-4893        |
 ----------------------------

Mark Teehan schrieb:
>
> 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: mteehan_at_erggroup.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).
>
> ---------------------------------------------------------
> This Mail has been checked for Viruses
> Attention: Encrypted mails can NOT be checked!
>
> **
>
> Diese Mail wurde auf Viren geprueft
> Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden!
> ---------------------------------------------------------

--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stefan Jahnke
  INET: stefan.jahnke_at_d2vodafone.de

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