| Time based Recovery: Urgent [message #63401] |
Fri, 01 October 2004 23:11  |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
I have a 9i database running on Solaris. If i do a Time based recover (say 5:21 pm yesterday) , then at that given point of time sum of the transactions may not be commited so wat will b the status of my database after recovery....
(A) Will it be the same ie some transactions commited or sum uncomitted or ..
(B) It will give the status as per the latest SCN before 5:21 pm????
Thanks in advance
Vivek
|
|
|
|
| Re: Time based Recovery: Urgent [message #63404 is a reply to message #63401] |
Sat, 02 October 2004 22:07  |
Sujit Sarkar
Messages: 40
Registered: September 2003
|
Member |
|
|
Dear Vivek,
When you go for Time based recovery, then oracle recovers all the transactions which are commited at that point of time.If any transaction is commited after that point then those transactions will be rolled back.
Sujit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
