My Oracle Support Banner

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

Last updated on SEPTEMBER 06, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.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 '/ora11g/app/product/11.2.0.1/test/dbs/UNNAMED00221' as '+DG_TEST_DATA';
alter database create datafile '/ora11g/app/product/11.2.0.1/test/dbs/UNNAMED00221' as '+DG_TEST_DATA'
*
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:
'/ora11g/app/product/11.2.0.1/test/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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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