Home » RDBMS Server » Backup & Recovery » using backup control file
using backup control file [message #185315] Tue, 01 August 2006 03:23 Go to next message
Messages: 312
Registered: May 2005
Senior Member
i have oracle 10g on windows xp,
the database is runing in archivelog mode,
if i need to recover my database using a backup control file
it will be recovered till the time of failure -complete recovery-
or only till the time when the control file backup was token ?
thanks in advance
Re: using backup control file [message #185364 is a reply to message #185315] Tue, 01 August 2006 06:35 Go to previous message
Messages: 2794
Registered: April 2006
Senior Member
If the online redo logs are available, then you will be able to recover up to the point of failure. However, if you actually recreate the controlfile, then you won't have to OPEN RESETLOGS. If you recover using a backup controlfile, then you'll have to OPEN RESETLOGS.

Either way, you'll be able to recover to point of failure.
Previous Topic: Help with a restore...
Next Topic: cold backup in archivelog mode
Goto Forum:

Current Time: Wed Aug 16 21:01:10 CDT 2017

Total time taken to generate the page: 1.36696 seconds