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

Try the following:

*)  Down your database and perform a cold back up.
*)  Start your database in archive log mode.
*)  Modify your data
*)  Force a log switch
*)  Down your database
*)  Restore the old files
*)  Restore to point in time.

Point time recovery means nothing unless you restore from old files. You can only recover forward from your last cold backup. If the data files are current, you cannot restore back to a point in time. It only works rolling forward.

Good Luck!

--

~~~~~~~~~~~~~~~~
Chris Weiss
www.hpdbe.com
High Performance Database Engineering
~~~~~~~~~~~~~~~~
"Sergey Adamenko" <adamenko_at_i.com.ua> wrote in message
news:aaf5kp$2m3t$4_at_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

>

>