Home » RDBMS Server » Server Administration » diff between until time and until cancel
diff between until time and until cancel [message #240477] Fri, 25 May 2007 00:31 Go to next message
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 Go to previous messageGo to next message
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

Re: diff between until time and until cancel [message #240606 is a reply to message #240489] Fri, 25 May 2007 05:24 Go to previous message
bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad
Member

thanks a lot,
Previous Topic: user to user grant
Next Topic: How can i known...
Goto Forum:
  


Current Time: Thu Dec 05 07:59:36 CST 2024