Re: rman oddities

When you have finished the restore and open the database with resetlogs, all of the old archivelogs are toast anyway. Just delete them!

You can manually delete any orphaned backupsets. If a backup fails then you need to redo it until in completes so that it will be recorded in the catalog and be usable for restore/recovery.

It really is that easy. Just a little getting used to, like being pregnant, not bad but different.( I hope your pregnancy is going well.) Any discomfort will be forgotten when you see the results.

Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, December 03, 2001 2:26 PM

> Hi Ruth, thanks so much for responding.
>
> Yes, I wrote the scripts to do an arclog backup delete. I'm concerned
about
> the arclogs hanging around after a restore and taking up disk space, along
> with unnecessarily inflating the size of my backup files. (I'm testing
> backup to disk right now)
>
> It's more of a nice to know, not necessary. I'm seeing some weird stuff
> that I didn't expect and the monkey in me wants to know why... No, not
the
> baby :) Here's some other odd behavior I've seen:
>
> 1. Instance failure during a backup leaves the rman files intact but the
> backup itself is not reflected in the catalog. The database recovers
nicely
> from this since no tablespaces are in hotbackup mode (yesssssssss) The
end
> result is "orphan" rman files that the catalog knows nothing about.
>
> 2. Initially these files are created the size of all datafiles combined.
> As the backup progresses, the size of the files shrink down considerably.
> For example, I allocate 3 channels to disk and setsize to 2GB, but the
files
> start out at 1.5GB and shrink down to ~500 MB. I wonder if that behavior
> happens on tape? Anyone? I'll be able to test this later this week.
>
> 3. Can restore and recovery really be this easy? Sheesh
>
> Thanks again for your response. And list, please correct me if I am wrong
> on any of this.
>
> yours in Monkeying Around,
> Lisa
>
> > -----Original Message-----
> > From: Ruth Gramolini [SMTP:rgramolini_at_tax.state.vt.us]
> > Sent: Monday, December 03, 2001 1:17 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: rman restore & arclogs
> >
> > Lisa,
> >
> > We backup all archivlogs with the backup set and delete them. Delete is
an
> > rman option when you backup archivelogs. We don't have room to keep
them.
> > It is a bit of a pain to restore them but you learn to live with it.
> >
> > Have a look at rman's tables and views. You should be able to query them
> > and
> > get what you want.
> >
> > Yours in rman,
> > Ruth
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Monday, December 03, 2001 10:30 AM
> >
> >
> > > Good morning all -
> > >
> > > I've been practicing rman restores. It's a lot easier than I
originally
> > > thought. I've noticed that when you restore and the arclogs are
needed,
> > it
> > > restores them. Which is expected. However, when I take another
backup,
> > > these arclogs are included in the backup set. This is unnecessary in
my
> > > opinion and makes my backup files larger than they need to be.
> > >
> > > Is it standard practice to just delete the arclogs that were already
in
> > a
> > > backup set prior to taking the immediate backup after a recovery? I
can
> > > verify what arclogs are where in the backup sets with a report.
> > >
> > > Any comments are appreciated. Thanks
> > >
> > > Lisa Koivu
> > > Oracle Database Monkey
> > > Fairfield Resorts, Inc.
> > > 954-935-4117
> > >
> > >
> >
> > --
> > 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).
>

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