RMAN Restore problems 2006-02-22 - By Stephen Andert
Hi all,
I haven't done a restore/recovery in a looong time. So long in fact, that
we were not using RMAN the last time I did. Anyway, I am going through a
test recovery and restoring the controlfile and spfile worked, but after
restoring the spfile, I am unable to mount the database. I get the
following error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 02/22/2006 15:43:28
ORA-00209 (See ORA-00209.ora-code.com): control file blocksize mismatch, check alert log for more info
The alert log says this:
alter database mount
Wed Feb 22 15:43:25 2006
ORA-00218 (See ORA-00218.ora-code.com): block size 8192 of controlfile does not match DB_BLOCK_SIZE
(4096)
ORA-00202 (See ORA-00202.ora-code.com): controlfile: '?/dbs/cntrl@(protected)'
Wed Feb 22 15:43:28 2006
ORA-209 (See ORA-209.ora-code.com) signalled during: alter database mount...
however, when I look in the spfile, I see:
*.db_block_size=8192
Am I missing something?
This is using Oracle 9.2.0.4 on AIX 5.2.
TIA
--
Stephen
<div>Hi all, </div>
<div> </div>
<div>I haven't done a restore/recovery in a looong time. So long in fact,
that we were not using RMAN the last time I did. Anyway, I am going
through a test recovery and restoring the controlfile and spfile worked, but
after restoring the spfile, I am unable to mount the database. I get the
following error:
</div>
<div> </div>
<div>RMAN-00571: ===========================================================<br
>RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<br>RMAN
-00571: ===========================================================
<br>RMAN-03002: failure of alter db command at 02/22/2006 15:43:28<br>ORA-00209 (See ORA-00209.ora-code.com)
: control file blocksize mismatch, check alert log for more info<br> </div>
<div>The alert log says this:</div>
<div>alter database mount<br>Wed Feb 22 15:43:25 2006<br>ORA-00218 (See ORA-00218.ora-code.com): block size
8192 of controlfile does not match DB_BLOCK_SIZE (4096)<br>ORA-00202 (See ORA-00202.ora-code.com):
controlfile: <a href="mailto:'?/dbs/cntrl@(protected)'">'?/dbs/cntrl@(protected)'</a>
<br>Wed Feb 22 15:43:28 2006<br>ORA-209 (See ORA-209.ora-code.com) signalled during: alter database mount.
..</div>
<div> </div>
<div>however, when I look in the spfile, I see:</div>
<div>*.db_block_size=8192</div>
<div> </div>
<div>Am I missing something?</div>
<div> </div>
<div>This is using Oracle <a href="http://9.2.0.4">9.2.0.4</a> on AIX 5.2.
<br clear="all"></div>
<div>TIA<br>-- <br>Stephen </div>
|
|
