Hi: It is a strange problem,did you add new objects which db_block_size is different from the old objects?
2006/2/23, Stephen Andert <andert@(protected)>: > > 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:</div> <div> It is a strange problem,did you add new objects which db_block_size is different from the old objects?</div> <div> <br><br> </div> <div><span class="gmail_quote">2006/2/23, Stephen Andert <<a href="mailto :andert@(protected)">andert@(protected)</a>>:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid"> <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 onclick="return top.js.OpenExtLink(window,event,this)" href= "mailto:'?/dbs/cntrl@(protected)'" target="_blank"> '?/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 onclick="return top.js.OpenExtLink(window ,event,this)" href="http://9.2.0.4/" target="_blank">9.2.0.4</a> on AIX 5.2.<br clear="all"></div> <div>TIA<br>-- <br>Stephen </div></blockquote></div><br>
