Re: Restore rman-backup

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 15 May 2003 21:49:39 +1000
Message-ID: <e_Kwa.34811$1s1.506150@newsfeeds.bigpond.com>

"Detlef Jockheck" <djockheck_at_gauselmann.de> wrote in message news:e63ap-kl4.ln1_at_java.adp-entwicklung.gauselmann.de...
> Hi,
>
> In my Oracle 9i documentation I found a note that I can backup my database
> with the command:
>
> rman> backup database plus archivelog
>
> after that I truncated a table xy in sqlplus
>
> How can I restore using rman to get the result during backup?

With the database in MOUNT state, and with an RMAN connection already established to it:

restore database;
recover database until <time just prior to when you truncated the table; sql 'alter database open';

In other words, there's no magic. It's just an ordinary RMAN-based incomplete recovery until time.

Regards
HJR
>
> ciao
> Detlef
>
> --
> # Detlef Jockheck
>
Received on Thu May 15 2003 - 06:49:39 CDT