RMAN Restore problems

  • From: "Stephen Andert" <andert@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 22 Feb 2006 16:20:45 -0700

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: 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: block size 8192 of controlfile does not match DB_BLOCK_SIZE
(4096)
ORA-00202: controlfile: '?/dbs/cntrl@.dbf'
Wed Feb 22 15:43:28 2006
ORA-209 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

Other related posts: