Thursday, February 26, 2015

ORA-19597: file blocksize 8192 does not match set blocksize of 16384


Recently, I have backup failed with ORA-19597: file blocksize 8192 does not match set blocksize of 16384.


error message image

OERR
Error: ORA 19597 Text: file %s blocksize %s does not match set blocksize of %s ---------------------------------------------------------------------------------------------------------------------------

Cause: A file was specified for inclusion in a backup set but it has a 
 logical block size different from the rest of the files in the backup 
 set. All files in a backup set must have the same logical block size. 
Action: Specify a file that has the same block size as the rest of the files 
 in the backup set. The conversation is still active and more files can 
 be specified.
Possibly root cause for this error is having include the current controlfile in each backuppiece with tablespaces of different blocksizes confused RMAN.
Resolution
For Oracle Database 9i is not necessary to include the statement "include current controlfile".

RMAN> configure controlfile autobackup on;



backup script image

Once a successful full backup is complete, proceed to run 'include current controlfile' in your backup script, the issue should not be recurred.

No comments:

Post a Comment