Hi Sir
I am new and i am facing a problem in 11g database. error was
'UNTIL CHANGE is before RESETLOGS change'
i follow the undermentioned steps
RMAN>> list backup;
i found a lot of backups and i note the scn no of last full backupset which is 6521286872.
then i check
list incarnation of database.
there are total 5 incarnation points.
RESET DATABASE TO INCARNATION 4
then i issue the command
RMAN> run {
2> set until scn 6521286872;
3> restore datafile 1;
4> restore datafile 2;
5> restore datafile 3;
6> }
All the datafiles are restored successfully.
Then i issue the command
RECOVER DATABASE UNTIL SCN 6521286872
I GOT THE ERROR
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
HOW I CAN RESOLVE THE ISSUE PLEASE . HELP ME . THANKS