My Oracle Support Banner

Creating Missing Datafile from the Backup when Using ASM Failing with: ORA-01136 (Doc ID 1444075.1)

Last updated on OCTOBER 13, 2019

Applies to:

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

Symptoms

Restoring the database. One of the files was not backed up.

Creating the missing datafile failing with errors:

SQL> alter database create datafile '/<oracle_home path>/dbs/UNNAMED00221' as '+<DISKGROUP name>';
alter database create datafile '/<oracle_home path>/dbs/UNNAMED00221' as '+<DISKGROUP name>'
*
ERROR at line 1:
ORA-01136: specified size of file 221 (3200 blocks) is less than original size
of 131104 blocks
ORA-01111: name for data file 221 is unknown - rename to correct file
ORA-01110: data file 221:
'/<oracle_home path>/dbs/UNNAMED00221'

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.