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. My attempts to do this always end with Specify log: {<RET>=suggested | filename | AUTO | CANCEL} cancel ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/data/oracle/XXX/u01/system_01.dbf' ORA-01112: media recovery not started SQL> alter database open read only; alter database open read only * ERROR at line 1: ORA-16004: backup database requires recovery ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/data/oracle/XXX/u01/system_01.dbf' 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@xxxxxxxxxxxxxxxxx www.credit-suisse.com ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ============================================================================== -- //www.freelists.org/webpage/oracle-l