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

Printable View

01-01-2003, 01:14 AM
TheSlob

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

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?
01-01-2003, 01:43 AM
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?
01-01-2003, 05:57 PM
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.
01-01-2003, 11:53 PM
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?
01-02-2003, 01:56 AM
TheSlob

no im not doing a tspitr...version 8.1.7.
01-02-2003, 05:35 AM
pando

how do you recover a table without doing tablespace point in time recovery?
01-02-2003, 06:31 AM
julian

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

Quote:

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;
01-02-2003, 12:57 PM
TheSlob

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