Re: Recover Help Please - needs more recovery

From: koert54 <koert54_at_nospam.com>
Date: Thu, 04 Apr 2002 20:58:52 GMT
Message-ID: <g83r8.52049$DE4.6765@afrodite.telenet-ops.be>

in short ...

1. you fiddled around not having clue how recovery works
2. somehow you managed to create a new controlfile
3. the new controlfile bit you in the ass because now you have to do an

incomplete recovery
4. incomplete recovery implies that you restore *all* datafiles from backup - this is necessary because a recovery can only bring datafiles forward into time and not back into time 5. you do not have a full hot backup
6. no full hot backup means no restore of all datafiles means no recovery possible
7. take a course on backup & recovery

anyhow - try setting the parameter of the last hope :

- shutdown abort your database
- open your parameter file
- add _allow_resetlogs_corruption = true
- save your parameter file
- startup mount
- recover database until cancel using backup controlfile ;
- cancel
- alter database open resetlogs
- pray the DB opens
- if it opens - export the DB, drop the DB, create the DB, import the DB

...
oh and don't forget to remove the parameter "_allow_resetlogs_corruption = true" in your parameter file or we'll see more of these postings in the future

"Paul Kohlmiller" <pkohlmil_at_best.com> wrote in message news:SQKq8.3782$Yb1.16845_at_sea-read.news.verio.net...
> To prevent excessive laughter I won't tell you what I did to the system
> tablespace datafile. Let's just say it was missing for a while and then
> replaced and Oracle did not like that one little bit. I'm surprised it let
> me do that while the database was running but "root" can indeed do
anything.
> I have tried various recover options including "backup controlfile". Now
it
> insists that I say that all the time. I do have have redo logs and recover
> says it must use on of those file to get change X. I do this but then it
> says it needs more recovery. So I do a recover until change X+y. Again it
> says it needs a certain file which I give it but it still needs more
> recovery. I can do this up to some number Z. When I try to recover to
change
> Z+1 or I say recover without specifying a change, Oracle gives error 283 -
> some internal error.
>
> Any advice? Here are some more details.
> 1. I don't care if it only recovers to a point 2 years ago. This was an
> "abandoned" database and has been treating as read only for about two
years.
> 2. No, I don't have any actual backups.
> 3. This is version 8.0.3 and we just want to get a few users off of this
> database and unto a new system running a much more recent version.
> 4. The actual data that I want to get out of this database is probably not
> in the system tablespace.
> 5. Performing a recover until a particular time, say a year ago, doesn't
> help because it claims it needs a recent change.
> Thanks,
> Paul K
>
>
Received on Thu Apr 04 2002 - 14:58:52 CST