Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
recovery of control file
2 views
Skip to first unread message
Phil Paxman
Apr 19, 2002, 2:32:09 PM4/19/02
to
Would anyone know why datafiles must be online before a control file can
be restored from backup? I have a situation where I might need to keep a
datafile offline. Can I still recover the controlfile from backup
be restored from backup? I have a situation where I might need to keep a
datafile offline. Can I still recover the controlfile from backup
Frank
Apr 19, 2002, 4:48:31 PM4/19/02
to
Phil Paxman wrote:
Are you referring to recover database using backup controlfile?
Information about to which point a recovery needs to be done in
order to get a consistent database is located in the controlfile(s).
If you have lost your controlfile(s) for whatever reason, it is possible
to recover with an old controlfile, using the above statement.
AFAIK, the data will then be used from the datafiles (which do contain
the same information), not the controlfile.
0 new messages