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>
