| Point in time recovery [message #53528] |
Wed, 25 September 2002 14:13  |
sheela
Messages: 66
Registered: March 2002
|
Member |
|
|
hello,
I did some recovery testing by deleting some data from a table (A).
The database is running in archivelog mode.
All rows deleted from tableA at 14.53pm
I shutdown the database with 'shutdown immediate'
I did a 'startup mount' and issued the following:
ALTER DATABASE
RECOVER AUTOMATIC UNTIL TIME '2002-09-25:14:52:00'
ALTER DATABASE OPEN RESETLOGS;
I didn't get the data back. What am I doing wrong? Should I use RMAN instead?
Roy
|
|
|
|
| Re: Point in time recovery [message #53536 is a reply to message #53528] |
Thu, 26 September 2002 00:05  |
zeeshan
Messages: 6
Registered: May 2002
|
Junior Member |
|
|
You need to first restore latest backup image of database (backup which taken any time before '2002-09-25:14:53:00') and then perform
recover database until time '2002-09-25:14:52:00'.
and then
alter database open resetlogs.
hope this helps.
-Zee.
|
|
|
|
| Re: Point in time recovery [message #53540 is a reply to message #53528] |
Thu, 26 September 2002 00:20 |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
Make a hot or cold backup ( at 12h00 )
Destroy data ( at 13h00 )
U should restore the datafiles first ( backup at 12h00 ).. issue the recover ( until time 13h00 )... And U've Got IT !
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
