Database point-in-time recovery: no errors during recobvery and no changes visible

From: Sergey Adamenko <adamenko_at_i.com.ua>
Date: Sun, 28 Apr 2002 00:34:26 +0300
Message-ID: <aaf5kp$2m3t$4@news.dg.net.ua>

Hi, ALL!
Did someone get used of such thing as DSPITR (Database point-in-time recovery)?
My base works with ARCHIVELOG mode.
I'm trying to rollback an hour ago. Using SRVMAN, I do the following:

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production JServer Release 8.1.7.0.0 - Production

SVRMGR> connect
Username: internal
Connected.
SVRMGR> ALTER SYSTEM ARCHIVE LOG CURRENT; Statement processed.
SVRMGR> ALTER database close immediate;
Statement processed.
SVRMGR> ALTER DATABASE RECOVER AUTOMATIC UNTIL TIME '2002-04-27:23:30:00';
Statement processed.
SVRMGR> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SVRMGR> startup nomount
ORACLE instance started.

Total System Global Area                         43501596 bytes
Fixed Size                                          75804 bytes
Variable Size                                    34959360 bytes
Database Buffers                                  8388608 bytes
Redo Buffers                                        77824 bytes

SVRMGR> alter database mount;
Statement processed.
SVRMGR> alter database open resetlogs;
Statement processed.
SVRMGR> alter database open resetlogs;

Now the database in open, but I see no changes: none of my operations is rolled back until the specified time.
What did I wrong being so naive?

With respect,
Sergey Adamenko Received on Sat Apr 27 2002 - 16:34:26 CDT