Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01190: controlfile or data file 33 is from before last RESETLOGS
Hello,
You have a big problem.
After a open resetlogs, you have to do a cold backup ( database closed ) : it's very very very recommended, mandatory !
The procedure you have to do now is very complex, and perhaps you can not do it.
Call the Oracle Support, it's the best solution.
Good luck
"Pawel Madziar" <pilot_at_mielonka.polbox.pl> a écrit dans le message news:
91kmmp$h1m$1_at_orfika.office.polbox.pl...
> I've oracle 8.0.5 database running with archive log mode.
> There is little summary of my problem:
>
> I've made cold backup of database
> Because some previous actions I had to reset logs on the database (alter
> database open resetlogs)
> . Some more actions that caused the restoring of the previously backed up
> database
>
> And there begins my problems. When I tried to restore database, I've got
> error:
>
> ORA-00283: recovery session canceled due to errors
> ORA-01190: controlfile or data file 33 is from before last RESETLOGS
> ORA-01110: data file 33: 'XXXX.dbf'
>
> I've found that my backup utility (Alexandria) due to system errors
doesn't
> backup one of data files (XXXX.dbf). Now I have such situation: all files
in
> the database are from before RESETLOGS (made just before RESETLOGS
command)
> and one from after (I have a copy made just after RESETLOGS command). I
have
> not any backup of this one wrong file, so I need some other solution. I
> think that there is possibility to manually correct header of wrong file
to
> have information about redologs as just before RESETLOGS. To do it (if
it's
> possible) I need information about DBF file (header especially) format. Or
> maybe there is any other solution?
>
> I would be very appreciated any help.
>
> Regards
> Pilot
> --
> Pilot pilot_at_pilot.cc
Received on Mon Dec 18 2000 - 18:43:47 CST