Incomplete Recovery

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 Tue Jan 23 2001 - 23:35:34 CST