No, not RAC. Here's the transcript of my latest attempt. Any suggestions/corrections welcomed.
Note that I have also tried this without specifying "using backup controlfile"--same result.
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
-----Original Message-----yes it is possible, can be used to see how far down a recovery process you are. Is this a RAC database?
From: David Sharples [mailto:email@example.com]
Sent: Thursday, June 01, 2006 4:05 PM
Subject: Re: Open read only after incomplete recovery?
On 01/06/06, Baumgartel, Paul <firstname.lastname@example.org> wrote:Oracle 126.96.36.199 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:
recover database using backup controlfile until cancel
...apply a few logs
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.
Please access the attached hyperlink for an important electronic communications disclaimer: