Ora-19906 when restoring user managed backup - stumped! - Oracle Server
This is a discussion on Ora-19906 when restoring user managed backup - stumped! - Oracle Server ; I have a test database I often restore from an online user managed backup (not rman), the procedure is simple: shut test database down copy files from last online backup on prod to test db locations, along with any archived ...
![]() |
| | LinkBack | Thread Tools | Display Modes |
|
#1
| |||
| |||
| backup (not rman), the procedure is simple: shut test database down copy files from last online backup on prod to test db locations, along with any archived logs since backup startup mount the test db, rebuild the controlfile renaming database and new file locations etc. recover database until cancel using backup controlfile, then apply redo etc. cancel and open database with resetlogs, create a tempfile and I'm good to go Usually goes without a hitch, but for some reason after I hit enter to have it apply the archived log it is looking for, I am getting: ================================================== ================= ORA-00283: recovery session canceled due to errors ORA-19906: recovery target incarnation changed during recovery ORA-01112: media recovery not started ================================================== ================= Looking up the 19906 error says its an rman incantation setting, but I am not using rman at all for this, and I'm stumped why this is happening now. I even re-ran the online backup and recopied the files over, with no success. Any ideas what I'm missing here? thanks |
|
#2
| |||
| |||
|
ps. database is 10.2.0.4 on windows 64 bit server. |
|
#3
| |||
| |||
| Check if you rebuilt the controlfile properly and that the newly created controlfile IS in use for the Recovery, not an older controlfile. Hemant K Chitale http://hemantoracledba.blogspot.com |
|
#4
| |||
| |||
|
Hemant K Chitale wrote: > Check if you rebuilt the controlfile properly and that the newly > created controlfile IS in use for the Recovery, not an older > controlfile. > > > Hemant K Chitale > http://hemantoracledba.blogspot.com checked all that, all was ok, done this process many times, just this time I was getting error. Finally was able to apply redo and open database with resetlogs, but only after I set the database incarnation to 1 with and RMAN command. Not sure why this was necessary this particular time though. Opened an SR and uploaded alert logs etc.. from prod and test db's, will see if they come up with any useful info.. |
![]() |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
| |
All times are GMT -4. The time now is 02:22 PM.



Linear Mode