When Performing Recover From Hot Backup ORA-01237 or ORA-01200 (Doc ID 1413507.1)

Last updated on FEBRUARY 14, 2012

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.3 - Release: 10.1 to 11.2
Information in this document applies to any platform.

Symptoms

Database is being recovered from a hot backup made with spit mirror technologies.

When we try to perform RECOVER UNTIL TIME recovery process fails with:

SQL> RECOVER DATABASE UNTIL TIME '2011-12-31:10:00:00' USING BACKUP CONTROLFILE;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 104: '/oradbs/oradata/ORCL/sysaux01.dbf'
ORA-01122: database file 104 failed verification check
ORA-01110: data file 104: '/oradbs/oradata/ORCL/sysaux01.dbf'
ORA-01200: actual file size of 293120 is smaller than correct size of 298240
blocks

or

SQL> RECOVER DATABASE UNTIL TIME '2011-12-31:10:00:00' USING BACKUP CONTROLFILE;

ORA-00283: recovery session canceled due to errors
ORA-01237: cannot extend datafile 104
ORA-01110: data file 104: '/oradbs/oradata/pri14p/sysaux01.dbf'


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