So, I have scoured documentation but before I deem this not possible, I thought
I better ask the experts here. I have a specific RMAN backup issue I am trying
to solve. I know I can get around it with a bit of clever shell scripting
(which I already have), but, want I really want to know is if this
functionality exists natively in RMAN commands.
My backup flow pretty much looks like this:
Sunday LEVEL0 including archivelogs to FRA
- After backup to FRA completes, an SBT backup copies FRA backup
pieces to tape with a command like:
backup backupset all;
- After backup to SBT completes, I clean up any files from the prior
week, or not needed for a COMPLETE recovery with:
delete noprompt obsolete redundancy 1 device type disk;
Monday LEVEL1 DIFFERENTIAL including archivelogs to FRA
- All other commands above are the same
Tuesday LEVEL1 DIFFERENTIAL including archivelogs to FRA
- All other commands above are the same
Wednesday LEVEL1 CUMULATIVE including archivelogs to FRA
- All other commands above are the same
...and so on
So, what I want to happen, to save space, is for any LEVEL1 DIFFERENTIALS and
archivelogs to get cleaned up out of the FRA after the SBT backup completes
when they are no longer needed. So, the L1D's get cleaned up after the
Wednesday L1C and the archive log backups get cleaned up after any backup. The
end goal is to only have on disk enough backups to do a COMPLETE recovery. If
I have to do incomplete, I can go to tape. That is a sacrifice we are making.
The problem I run into is that if for some reason the SBT backup fails, my
archive logs or L1D's might still get deleted. This happened and has caused us
some pain. I know, it was a bad design I did not see until it bit me.
What I really want, is to find out if RMAN has a way to check if SBT backups
are available before I delete obsolete. I envision the command would look
something like this:
delete obsolete redundancy 1 device type disk backed up 1 times to SBT;
I hope I explained this clearly enough. For now, I have simply coded into my
shell script an exit code check before the delete runs. That should work ok,
but, again, I was wondering if I am overlooking some built in feature to RMAN
that would simplify things.
Thanks in advance,
Chris..
_____________________________________________________________________
Chris Ruel * Oracle Database Administrator * Lincoln Financial Group
cruel@xxxxxxx<mailto:cruel@xxxxxxx> * Desk:317.759.2172 * Cell 317.523.8482
Notice of Confidentiality: **This E-mail and any of its attachments may contain
Lincoln National Corporation proprietary information, which is privileged,
confidential,
or subject to copyright belonging to the Lincoln National Corporation family of
companies. This E-mail is intended solely for the use of the individual or
entity to
which it is addressed. If you are not the intended recipient of this E-mail,
you are
hereby notified that any dissemination, distribution, copying, or action taken
in
relation to the contents of and attachments to this E-mail is strictly
prohibited
and may be unlawful. If you have received this E-mail in error, please notify
the
sender immediately and permanently delete the original and any copy of this
E-mail
and any printout. Thank You.**
