Re: Incomplete Recovery

Stan,

I must be missing something here...

To me the easiest way to revert to a state right before your test is to perform a cold backup of that system before you do the test. After the test, just restore everything from your cold backup. No worrying about complete/incomplete recovery and all that.

HTH,
Brian  

si_bendovi_at_hotmail.com wrote:
>
> 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
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================