| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Recover Help Please - needs more recovery
Paul Kohlmiller wrote:
> 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.
Your problem is I think that you have done a recover until a particular SCN. That's an Incomplete Recovery. The first rule about incomplete recoveries you need to learn is this: EVERY single data file gets restored from backup, not just the one you think is a bit dodgy. The entire set of data files has to be restored from a prior backup and then rolled forward by applying redo. At some point you stop applying redo. You are left at that point with control files and redo logs at time X, and all datafiles beautifully synchronised to each other at time X-something. You force the controlfiles and the log files back into synch with the datafiles by then performing an open database resetlogs.
>
> 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.
Well it will do if you've bodged up the incomplete recovery procedure. Restore all data files (but NOT the control files or redo logs) from backup, get it to the mount stage. Issue the 'recover database until cancel' command. Type cancel.Type alter database open resetlogs.
(Incidentally, there's a Backup and Recovery book at my web site you might find useful in getting hang of the principles involved).
Regards
HJR
> Thanks,
> Paul K
Received on Wed Apr 03 2002 - 18:04:01 CST
 |
 |