<<Back to Oracle DataGuard Main Page
ORA-01136: specified size of file file# is less than original size
SQL> alter database create datafile '/u01/app/oracle/12.2.0.1/dbp1/dbs/UNNAMED00016' as '+DG_TEST_DATA/';alter database create datafile '/u01/app/oracle/12.2.0.1/dbp1/dbs/UNNAMED00016' as '+DG_TEST_DATA/'
*
ERROR at line 1:
ORA-01136: specified size of file 16 (12800 blocks) is less than original size
of 34560 blocks
ORA-01110: data file 16: '+DG_TEST_DATA/'
Solution:
When ASM is used, you have to define the size of the datafile in the create command. You can find the datafile size from primary database.
SQL> alter database create datafile '/u01/app/oracle/12.2.0.1/dbp1/dbs/UNNAMED00016' as '+DG_TEST_DATA/' size 1G;
Database altered.
Comments
Post a Comment