RE: Open read only after incomplete recovery?
- From: "Tanel Poder" <tanel.poder.003@xxxxxxx>
- To: <paul.baumgartel@xxxxxxxxxxxxxxxxx>, "'Radoulov, Dimitre'" <cichomitiko@xxxxxxxxx>
- Date: Sat, 10 Jun 2006 14:06:07 +0800
When doing a recover database using backup controlfile, then the time when
controlfile was backed up doesn't matter for recovery as long as the
physical structure in it represents current database structure. In other
words, checkpointing and file status info in controlfiles is ignored and
recovery process goes directly to the source - datafile headers.
So select fil#, checkpoint_change# from v$datafile_header after your
incomplete recovery and see if any files do still have higher
checkpoint_change#'s from the SCN where you recovered to.
Tanel.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Baumgartel, Paul
Sent: 02 June 2006 06:57
To: 'Radoulov, Dimitre'
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Open read only after incomplete recovery?
Yes, the control files are on one of the BCV volumes; i.e. they're part of
the copy.
Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
