RMAN Restore problems

From: Stephen Andert <andert_at_gmail.com>
Date: Wed, 22 Feb 2006 16:20:45 -0700
Message-ID: <6d45e210602221520h405945c6wbe2fc58014b084a2@mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Feb 22 2006 - 17:20:45 CST