Re: Incomplete Recovery

Yes, well... best to learn about what's involved in an incomplete recovery, I suspect. For starters, you need to restore ALL datafiles from a backup taken before your test -but most definitely NOT the Controlfiles or Online Redo Logs. The entire database is then rolled forward to a given time, or until it's cancelled, or until a given SCN. Then you can do an open resetlogs.

The commonest error encountered when performing incomplete recoveries is something along the lines of "Media recovery complete, but attempt to open with a restlogs will generate the error 'File 1 needs more recovery to be consistent'.... and every time, it's because the person doing the recovery has only restored the datafile they thought was relevant, not all DBFs without exception.

Regards
HJR <si_bendovi_at_hotmail.com> wrote in message news:3A6E69A6.14DEA570_at_hotmail.com...
> I am trying to have database running in backup mode to be
> able to 'rollback' all transactions after backup mode was
> started. Goal is to be able to put database to the same
> state as it was before certain test. But I could not make
> recovery done without complaining that system tablespace
> needs more recovery. I am putting all tablespaces into
> backup mode, running my tests and after that doing 'shutdown
> abort'.
>
> recover until change (last change from v$backup);
>
> finish with warning, that system tablespace needs more
> recovery. I could not figure out what it means more :-). Any
> idea? Of course 'alter database open resetlogs' fails.
>
> Stan
>
Received on Wed Jan 24 2001 - 01:28:30 CST