| diff between until time and until cancel [message #240477] |
Fri, 25 May 2007 00:31  |
bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad
|
Member |
|
|
when iam taking backup using following command recover database until time "---" it is going to point at that time and it is recovering the database, the same process when iam giving recover database using backup controlfile until cancel it is doing the same job, can any one tell me what is the main difference betwween these two
thanks
with regards
kiran..
|
|
|
|
| Re: diff between until time and until cancel [message #240489 is a reply to message #240477] |
Fri, 25 May 2007 01:06  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
In the first case you have to use the current control file and Oracle will not recover past the current SCN recorded in it.
In the second case you notify Oracle that you use a backup control file and it has to ignore the SCN data in it.
In the first case you tell Oracle at which time it will stop applying the archived logs and the recover.
In the second case you tell Oracle to ask you for each archived log to apply and you will cancel the recover at the one you want.
Regards
Michel
[Updated on: Fri, 25 May 2007 01:08] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
