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.
Is this even possible? The docs say that it is not, but two of my colleagues claim otherwise.
Paul Baumgartel CREDIT SUISSE Information Technology DBA & Admin - NY, KIGA 1 11 Madison Avenue New York, NY 10010 USA Phone 212.538.1143 paul.baumgartel@(protected) www.credit-suisse.com
============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer:
