dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

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 ...


Home > Database Forum > Oracle Database > Oracle Server > Ora-19906 when restoring user managed backup - stumped!

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 09-08-2009, 06:05 PM
usenet
Guest
 
Posts: n/a
Default Ora-19906 when restoring user managed backup - stumped!

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 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





Reply With Quote
  #2  
Old 09-08-2009, 10:06 PM
usenet
Guest
 
Posts: n/a
Default Re: Ora-19906 when restoring user managed backup - stumped!

ps. database is 10.2.0.4 on windows 64 bit server.
Reply With Quote
  #3  
Old 09-10-2009, 03:30 AM
usenet
Guest
 
Posts: n/a
Default Re: Ora-19906 when restoring user managed backup - stumped!


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
Reply With Quote
  #4  
Old 09-10-2009, 10:04 AM
usenet
Guest
 
Posts: n/a
Default Re: Ora-19906 when restoring user managed backup - stumped!

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..
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 02:22 PM.