RMAN Restore (also during a recovery) fails: Ora-19863 (Doc ID 1326100.1)

Last updated on AUGUST 14, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

Restoring a Standby Controlfile from an RMAN Backup is failing with: ORA-19863


The issue is specific to a RESTORE operation but can also occur during a RECOVER.

Recovery Manager: Release 11.1.0.7.0 - Production on Sun Jan 9 17:07:13 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: ECCP (DBID=2187817329, not open)
using target database control file instead of recovery catalog

RMAN> catalog start with '/u01/app/oracle/arch_ECCP/standby_restore/';
      run {
        allocate channel dev_0 device type disk PARMS="BLKSIZE=1048576";

        restore standby controlfile to '/u01/app/oracle/arch_ECCP/standby_restore/standby_ECCS.ctl';
         recover database noredo;
      }

searching for all files that match the pattern /u01/app/oracle/arch_ECCP/standby_restore/

List of Files Unknown to the Database
=====================================
cataloging files...
no files cataloged

allocated channel: dev_0
channel dev_0: SID=467 device type=DISK

Starting restore at 09-JAN-11

channel dev_0: starting datafile backup set restore
channel dev_0: restoring control file
output file name=/u01/app/oracle/arch_ECCP/standby_restore/standby_ECCS.ctl
channel dev_0: reading from backup piece /u01/app/oracle/arch_ECCP/standby_restore/ECCP_standby_scn_138561_1.dbf
released channel: dev_0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/09/2011 17:08:03
ORA-19870: error while restoring backup piece /u01/app/oracle/arch_ECCP/standby_restore/ECCP_standby_scn_138561_1.dbf
ORA-19863: device block size 4177920 is larger than max allowed: 1048576

Recovery Manager complete.


OR

Duplicate failing during the datafile restore stage:

Starting restore at 2008-Apr-09 09:28:24
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /u06/oradata/hcmprdc/sysaux01.dbf
...
restoring datafile 00121 to /u06/oradata/hcmprdc/waapp.dbf
channel ORA_AUX_DISK_1: reading from backup piece
/u04/oradata/flash_recovery_area/HCMPRD/mdjd8s5v_1_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/09/2008 09:28:28
RMAN-03015: error occurred in stored script Memory Script
ORA-19870: error reading backup piece /u04/oradata/flash_recovery_area/HCMPRD/mdjd8s5v_1_1
ORA-19863: device block size 1040384 is larger than max allowed: 262144



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms