Open read only after incomplete recovery? 2006-06-01 - By David Sharples
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@(protected)> 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.
>
yes it is possible, can be used to see how far down a recovery process you are.
Is this a RAC database?<br><br>
<div><span class="gmail_quote">On 01/06/06, <b class="gmail_sendername"
>Baumgartel, Paul</b> <<a href="mailto:paul.baumgartel@(protected)"
>paul.baumgartel@(protected)</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">Oracle <a href="http://9.2.0.6">9.2.0.6</a>
on 64-bit Solaris 5.8.<br><br>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.
<br><br>I am told by other DBAs that they have successfully performed the
following:<br><br>startup mount<br>recover database using backup controlfile
until cancel<br><br>...apply a few logs<br>... cancel<br><br>alter database
open read only;
<br><br>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.<br></blockquote></div>
|
|
