ORA-00218: block size string of controlfile 'string' does
not match DB_BLOCK_SIZE (string)



ORA-00218: block size string of controlfile 'string' does not match DB_BLOCK_SIZE (string..

Answer / guest

Cause: The block size as stored in the controlfile header is
different from the value of the initialization parameter
DB_BLOCK_SIZE. This might be due to an incorrect setting of
DB_BLOCK_SIZE, or else might indicate that the controlfile
has either been corrupted or belongs to a different database.

Action: Restore a good copy of the controlfile. If the
controlfile is known to be clean set the DB_BLOCK_SIZE to
match controlfile headers block size value.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-28592: agent control utility: agent SID not set

1 Answers  


NID-00141: No database name specified, previous attempt used string

1 Answers  


RMAN-08152: global script string written to file string

1 Answers  


EXP-00011: %s.string does not exist

1 Answers  


DRG-11500: column name expected, found string on line string

1 Answers  


ORA-25217: enqueue failed, visibility must be IMMEDIATE for queue string.string

1 Answers  


ORA-19773: must specify change tracking file name

1 Answers  


DRG-50913: first document requested string is not a positive number

1 Answers  


ORA-12663: Services required by client not available on the server

1 Answers  


KUP-00600: internal error, arguments [string] [string] [string] [string] [string]

1 Answers  


ORA-39707: compatibile parameter string too high for downgrade to string

1 Answers  


ORA-16777: unable to find the destination entry of a standby in V$ARCHIVE_DEST

1 Answers  


Categories