Open read only after incomplete recovery? 2006-06-01 - By Baumgartel, Paul
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 (See ORA-01547.ora-code.com): warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194 (See ORA-01194.ora-code.com): file 1 needs more recovery to be consistent
ORA-01110 (See ORA-01110.ora-code.com): data file 1: '/data/oracle/XXX/u01/system_01.dbf'
ORA-01112 (See ORA-01112.ora-code.com): media recovery not started
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16004 (See ORA-16004.ora-code.com): backup database requires recovery
ORA-01194 (See ORA-01194.ora-code.com): file 1 needs more recovery to be consistent
ORA-01110 (See ORA-01110.ora-code.com): 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@(protected)
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
==============================================================================
--
http://www.freelists.org/webpage/oracle-l
|
|
