Re: RMAN Restore problems
- From: "Yu Fish" <mr.fishyu@xxxxxxxxx>
- To: andert@xxxxxxxxx
- Date: Thu, 23 Feb 2006 14:34:49 +0800
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:
