RMAN doesn't allow me to perform a 2nd point in time recovery after the first 1

[TheSlob]

RMAN doesn't allow me to perform a 2nd point in time recovery after the first 1 i did 10 minutes ago. it's giving me an RMAN-20011:target database incarnation is not current in recovery catalog. I already did a "reset database to incarnation x", i only have 2 incarnations i tried them both already but rman's still giving me the same error msg. what are your advice?

[stmontgo]

so u ask rman to recover to PIT X and it does so?

what are you trying to do after that ? roll forward past X?

did u open the db after the first recovery pass?

[TheSlob]

I was trying to recover a dropped table using a time-based point in time recovery...but the table was dropped even before the time i specified in my rman script so i had to restore a more previous backup of the database, by specifying an earlier time than the time i specified in my first rman script...but rman is not allowing me to perfrom the 2nd recovery giving me the error msg i just specified.

[stmontgo]

are you using the method to do TSPITR whereby RMAN creates a 2nd instance on the fly , does recovery on the 2nd instance to the PIT

also which version are you using?

[TheSlob]

no im not doing a tspitr...version 8.1.7.

[pando]

how do you recover a table without doing tablespace point in time recovery?

[julian]

Originally posted by TheSlob
RMAN doesn't allow me to perform a 2nd point in time recovery after the first 1 i did 10 minutes ago. it's giving me an RMAN-20011:target database incarnation is not current in recovery catalog. I already did a "reset database to incarnation x", i only have 2 incarnations i tried them both already but rman's still giving me the same error msg. what are your advice?

First, after you opened with resetlogs, did you run RESET DATABASE? I guess no. If yes then:

Now, read carefully Note 1070453.6

All you have to do is:

rman catalog rman/rman@rcat
RMAN> list incarnation;
RMAN> Set dbid
RMAN> connect target un/pw@
RMAN> reset database to incarnation 2;

[TheSlob]

yes julian I did a "reset database".I'll try your suggestion thanks.