Re: RMAN Restore problems
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 <email@example.com>:
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)
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 220.127.116.11
on AIX 5.2.