Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN question
Thanks again for the additional info.
The "plus archivelog" issue is something I have pending to check and
recheck. We have a install using HP Data Protector defaults "... backup
archive log all" for the nightly full backup, and "backup archivelog all
.. delete input" in another separate archivelogs-only backup. All of
this have to be checked.
best regards.
>No problem, and I wouldn't call the info you provided "bad", just
>slightly incomplete maybe - nothing to apologize for. The assumption I
>stated (that retention is set correctly) is a big one, and one that I
>would never make. I always verify the retention on my Netbackup tape
>backups with the bpclimagelist command - and I strongly recommend
>everyone else do the same if you value the ablility to restore your
>backups months or years down the road. And be sure to make sure that
>the retention is set correctly on ALL required backup pieces - that
>means the control file, data files and log files. I've seen some cases
>were these are split out into different backup pieces with different
>retentions and your hot data file backups aren't going to do much good
>w/o the archive logs or vice-versa. This ties into another recent
>discussion on the list where the general consensus was to run your hot
>database backups with the "plus archivelog" clause. I also recommend
>that anyone relying on control files only as their rman repository turn
>on controlfile autobackups - and test your restores of these (w/o using
>a catalog) so you are familiar with the process in advance.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 14 2007 - 16:16:46 CDT