Open read only after incomplete recovery?
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 1 Jun 2006 20:56:03 +0100
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
Other related posts:
