Fix ORA-19870 ORA-19863: device block size 4186112 is larger than max allowed: 1048576


Error Description:
RMAN Duplicate database command failed with following error message.
RMAN-00571: ==============================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ==
RMAN-00571: ==============================================
RMAN-03002: failure of Duplicate Db command at 07/20/2012 09:50:30
RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script
ORA-19870: error while restoring backup piece +RECO/proddb1/backups/lungh8o7_1_1
ORA-19863: device block size 4186112 is larger than max allowed: 1048576

Solution Description:
Here is the work around for this issue.
  1. Add the following parameter to the auxiliary database init<dbname>.ora file and startup with nomount option for duplicate database. Rerun the duplicate command with noresume option. The value for these parameters should be same as the max value allowed in the error message.
a.   If it is RAC database _BACKUP_KSFQ_BUFSZ=1048576
b.   If it is Single Instance database _DB_FILE_DIRECT_IO_COUNT=1048576
duplicate target database to testdb1 until scn 1674927122 noresume;

  1. In case above attempt fails you have to take a fresh backup from the TARGET database by setting the following variable. Use the new SCN number from the new backup for the duplicate database. Also set the same init variable in Auxiliary database before starting the duplicate command. i.e: synchronize the variable values in both TARGET and AUXILIARY database.
a.   If it is RAC database use _BACKUP_KSFQ_BUFSZ=1048576
If it is Single Instance database use _DB_FILE_DIRECT_IO_COUNT =1048576
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google