Open read only after incomplete recovery?

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Thu, 1 Jun 2006 20:56:03 +0100
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC0F40E263@ENYC11P32005.corpny.csfb.com>

Oracle 9.2.0.6 on 64-bit Solaris 5.8.

We have a BCV setup to maintain a copy of a production database on another server. The BCV is updated every night. Tablespaces are placed in backup mode beforehand and taken out after.

I am told by other DBAs that they have successfully performed the following:

startup mount
recover database using backup controlfile until cancel

...apply a few logs
... cancel

alter database open read only;

We do NOT want to open resetlogs. The purpose of this exercise is to see if we can use the BCV copy for reporting, but still be able to recover it further if need be.

My attempts to do this always end with

	Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
	cancel
	ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
	ORA-01194: file 1 needs more recovery to be consistent
	ORA-01110: data file 1: '/data/oracle/XXX/u01/system_01.dbf'


	ORA-01112: media recovery not started


	SQL> alter database open read only;
	alter database open read only
	*
	ERROR at line 1:
	ORA-16004: backup database requires recovery
	ORA-01194: file 1 needs more recovery to be consistent
	ORA-01110: data file 1: '/data/oracle/XXX/u01/system_01.dbf'

Is this even possible? The docs say that it is not, but two of my colleagues claim otherwise.

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

---

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

---

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 01 2006 - 14:56:03 CDT