Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: rman question
On Feb 8, 1:25 am, "jerni..._at_kochind.com" <jerni..._at_kochind.com>
wrote:
> DB version 9.2.0.7
> Windows Server 2003
>
> I have a question about deleteing obsolete copies with RMAN. The
> recovery window is set to 1 week. The backup files are stored to
> disk. The RMAN script deletes the obsolete copies. Then each night
> the files are copied to tape using the server backup software and not
> using RMAN. If I restore a backup file from tape that is 10 days
> old, can I restore the database to that point in time? Is it
> possible to restore to a time prior to the recovery period?
Yes, but you will need to copy all required backup pieces back from
the
tape to disk and CATALOG them so that RMAN knows they are available.
It will show them as obsolete, because they are outside the retention
window, but it will use them for recovery if necessary. You can also
CHANGE KEEP them to exempt them from retention policy.
Hth,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Thu Feb 08 2007 - 00:01:26 CST