Re: RMAN Restore problems

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@xxxxxxxxx>:
>
> 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: