Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Open read only after incomplete recovery?

Re: Open read only after incomplete recovery?

From: David Sharples <davidsharples_at_gmail.com>
Date: Thu, 1 Jun 2006 21:05:27 +0100
Message-ID: <be592d550606011305r441ed9bdg952a53b5df7f965a@mail.gmail.com>


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_at_credit-suisse.com> 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.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 01 2006 - 15:05:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US