Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to increase db block size with RMAN restore

40569Oct 2 2006 — edited Oct 3 2006
How to increase db block size with RMAN restore

I am trying to increase the db_block_size of a test database from 8K to 16K or 32K.
Is this even possible?

I get the following error stack from rman during restore.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/02/2006 11:14:12
ORA-19625: error identifying file /db/logger/data/control01.ctl
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
ORA-19600: input file is controlfile (/db/logger/data/control01.ctl)
ORA-19601: output file is controlfile (/db/logger/data/control02.ctl)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 31 2006
Added on Oct 2 2006
5 comments
813 views