Re: Incomplete Recovery of tablespace

"drops" <oliver_at_drobnik.com> wrote in
news:1141048789.773396.314560_at_v46g2000cwv.googlegroups.com:

> I am desperately trying to find out how to recover a single
> tablespace to a specified point in time.
>
> I got an scp from "list backup;"
>
> so I am trying
>
> RMAN> run {
> 2> set until scn 103835211;
> 3> shutdown immediate;
> 4> startup mount;
> 5> restore tablespace dwhva_dim;
> 6> recover tablespace dwhva_dim;
> 7> }
>
> RMAN> alter database open resetlogs;
>
> RMAN-00571:
> ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> =============== RMAN-00571:
> ===========================================================
> RMAN-03002: failure of alter db command at 02/27/2006 14:57:42
> ORA-01139: RESETLOGS option only valid after an incomplete database
> recovery
>
>
> if I only do "alter database open;" then the state of my tables will
> not be the one from the backup but from the time of shutdown.
>
> How is it done?
>
>
> I read somewhere that you can only make incomplete recoveries of the
> whole database. Is this true?
>
> kind regards
> Oliver Drobnik
>

What version of Oracle?

From at least 9i on (maybe 8i too) there's a very detailed section in the rman manual about TSPITR (tablespace point in time recovery). I could explain it here but it's already put down in step by step there. Received on Mon Feb 27 2006 - 09:04:57 CST