bcjm wrote:
Easiest way would just be to do a "list backup" and look at the
completion time.

%t is the number of seconds elapsed since a fixed reference time hard
coded in RMAN. So theoretically, you can just do a test to figure out
what that fixed reference time is, and from then on, you can use that
same number to calculate the date from the %t value.

Take a look at $ORACLE_HOME/rdbms/demo/rman1.sh

In your case, you might want to change the report obsolete line to:

report obsolete until time 'SYSDATE-7'


Cheers,
Dave

"bcjm" <oldcar (AT) hotmail (DOT) com> wrote


It's been a while since I looked at RMAN on 8i, but is there no 'delete
obsolete;'??

There is in 9i, just so you know.

;-^

Have a look at the following files:

$ORACLE_HOME/rdbms/demo/rman1.sh
$ORACLE_HOME/rdbms/demo/rman2.sh

HTH,
Brian

bcjm wrote:
--
================================================== =================

Brian Peasland
oracle_dba (AT) remove_spam (DOT) peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

"bcjm" <oldcar (AT) hotmail (DOT) com> wrote

Take a look at the script I quoted in my original reply. Again, it's

$ORACLE_HOME/rdbms/demo/rman1.sh

Cheers,
Dave




Take a look at $ORACLE_HOME/rdbms/demo/rman1.sh

In your case, you might want to change the report obsolete line to:

report obsolete until time 'SYSDATE-7'

Brian Peasland <oracle_dba (AT) remove_spam (DOT) peasland.com> wrote

You would think Oracle should have the command available to delete the
backuppiece instead of making us to build it on the fly. Not everyone
is running on Unix. Window DOS scripting does not take "<<" command
if I am not mistaken.

bcjm wrote:
You're right. That's why in 9i, Oracle added the command DELETE
OBSOLETE to rman. You only need to use the above scripts in 8i, not 9i.

Cheers,
Dave

Unfortunately, the DELETE OBSOLETE commands in 9i require you to
configure a retention policy of which I personally don't like. We use
RMAN in conjunction with Legato and the Legato Module for Oracle so that
we can back up to an automated tape library system. In our Legato tape
library system, we have a retention period of 90 days. After 90 days,
the file is no longer available in the system. RMAN's retention policy
doesn't exactly work the same way. About the closest one can come to,
IIRC, is to specify that one needs no more than 90 days of archived redo
logs to apply recovery (by specifying the RECOVERY WINDOW). The other
retention policy is to specify the REDUDANCY. Personally, I wish that
they'd just let me remove stuff that is 90 days or older. And why do I
have to perform a crosscheck? Shouldn't I have to power to just remove a
backup set if I deem it is no longer necessary?

Just my troubles....
Brian

Dave Hau wrote:
--
================================================== =================

Brian Peasland
oracle_dba (AT) remove_spam (DOT) peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

I agree that 30 days is fine, for most circumstances. And in my systems,
the entire database gets backed up in 30 days. But we like to keep
multiple generations of backups around, just in case. You can call it
the "old-school ways" if you like from back in my mainframe days. And
sprinkle in some paranoia. What if I for some reason, the tape holding
my last backup has a bad spot? Then it would be nice to be able to go
back to the previous backup, or the one before that. Which is why we
have a 90 day retention policy in place.

But even if it wasn't 90 days, then substitute "30" instead of "90" in
my previous post. The concerns are still the same from my point of view.

Cheers,
Brian

Sybrand Bakker wrote:
--
================================================== =================

Brian Peasland
oracle_dba (AT) remove_spam (DOT) peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"