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 Wed Apr 03 2002 - 15:52:50 CST
