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-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
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:
Am I missing something?
This is using Oracle 18.104.22.168
on AIX 5.2.