RE: Open read only after incomplete recovery?

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Sat, 10 Jun 2006 14:06:07 +0800
Message-ID: <002101c68c53$faac5510$f004ff30$@poder.003@mail.ee>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Baumgartel, Paul
Sent: 02 June 2006 06:57
To: 'Radoulov, Dimitre'
Cc: oracle-l_at_Freelists.org
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_at_credit-suisse.com
www.credit-suisse.com

--

http://www.freelists.org/webpage/oracle-l Received on Sat Jun 10 2006 - 01:06:07 CDT