My Oracle Support Banner

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

Last updated on NOVEMBER 29, 2019

Applies to:

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

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the
Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual
environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:

Database Name: PROD
Standby Db_unique_name:  STBY
Directory Name: /u01/app/oracle/, /u06/oradata/, /u04/oradata/flash_recovery_area including sub-directories

***************

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: PROD (DBID=2187817329, not open)
using target database control file instead of recovery catalog

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

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

searching for all files that match the pattern /u01/app/oracle/arch_PROD/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_PROD/standby_restore/standby_STBY.ctl
channel dev_0: reading from backup piece /u01/app/oracle/arch_PROD/standby_restore/PROD_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_PROD/standby_restore/PROD_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/sysaux01.dbf
...
restoring datafile 00121 to /u06/oradata/waapp.dbf
channel ORA_AUX_DISK_1: reading from backup piece
/u04/oradata/flash_recovery_area/STBY/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/STBY/mdjd8s5v_1_1
ORA-19863: device block size 1040384 is larger than max allowed: 262144



Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.