Re: RMAN Quick clean-up

We do a level 0 and 1 or 2 or 3 level 1's during batch processing at night or on the weekend. We back up the archivelogs and delete them. We put the whole thing on tape the next morning and delete the ones on disk. We keept the tapes for a week and the write over. The old backups aren't really of much use to use after that since we couldn't really go back more than a couple of days without losing a lot of work which would be unacceptable.

I keep the previous days' backups compress on disk until noon the next day and then delete them and compress the previous nights' which makes room for the upcoming nights' work. When they get too big too keep two we will not. It really isn't necessary, but overkill in our business never hurts.

Ruth B. Gramolini
ORACLE DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
rgramolini_at_tax.state.vt.us
----- Original Message -----
From: James Howerton <jhowerton_at_uabmc.edu> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, May 09, 2000 1:14 PM
Subject: Re: RMAN Quick clean-up

Both,

I'm using

RMAN> report obsolete;

I take the output from this and generate by hand a line for each file.

RMAN> change backuppiece '/BACKUP/FILENAME/FILENAME_L2-DEMO-395269203-21-1' delete;

I then use rm to delete all archlog backups dated prior to my level 0 backup.

...JIM...
>>> rgramolini_at_tax.state.vt.us 5/9/00 10:26:36 AM >>>
Do you want to remove them from the recovery catalog or from the server? RBG
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, May 09, 2000 10:27 AM

DBA's,

Does anyone have a quick method for removing obsolete backup sets and archivelogs? I'm spending way too much time doing this each week.

Thanks

...JIM...

--
Author: James Howerton
  INET: jhowerton_at_uabmc.edu

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


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

--
Author: James Howerton
  INET: jhowerton_at_uabmc.edu

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