FreeLists / oracle-l / Re: Open read only after incomplete recovery?

[oracle-l] || [Date Prev] [06-2006 Date Index] [Date Next] || [Thread Prev] [06-2006 Thread Index] [Thread Next]

Re: Open read only after incomplete recovery?

From: "David Sharples" <davidsharples@xxxxxxxxx>
To: paul.baumgartel@xxxxxxxxxxxxxxxxx
Date: Thu, 1 Jun 2006 21:05:27 +0100

yes it is possible, can be used to see how far down a recovery process you
are.  Is this a RAC database?

On 01/06/06, Baumgartel, Paul <paul.baumgartel@xxxxxxxxxxxxxxxxx> wrote:


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.

References:
- Open read only after incomplete recovery?
  - From: Baumgartel, Paul