ORA-01276: Cannot add file +ASM….. File has an Oracle Managed Files file name.

SQL> select name from v$datafile;


NAME
—————————————————————————————————————————————-
+DATA/LOCATION/datafile/system.329.926973193
+DATA/LOCATION/datafile/sysaux.324.926973259
+DATA/LOCATION/datafile/undotbs1.307.926973213
+DATA/LOCATION/datafile/xdb_ts.326.926973193
+DATA/LOCATION/datafile/users.383.926973185
+DATA/LOCATION/datafile/db_data1.325.926973191
+DATA/LOCATION/datafile/db_data1.318.926973259
+DATA/LOCATION/datafile/db_data1.336.926973183
+DATA/LOCATION/datafile/db_data1.366.926973213
+DATA/LOCATION/datafile/db_lob1.335.926973185
+DATA/LOCATION/datafile/db_index1.384.926973191
+DATA/LOCATION/datafile/db_index1.315.926973183
+DATA/LOCATION/datafile/db_index1.330.926973257
+DATA/LOCATION/datafile/db_index1.313.926973213
+DATA/LOCATION/datafile/db_audit_data.312.926973259
+DATA/LOCATION/datafile/db_audit_data.376.926973215
/u01/app/oracle/product/11.2.0.4/db_1/dbs/UNNAMED00017


17 rows selected.


SQL> alter database create datafile ‘/u01/app/oracle/product/11.2.0.4/db_1/dbs/UNNAMED00017’  as ‘+DATA’;
alter database create datafile ‘/u01/app/oracle/product/11.2.0.4/db_1/dbs/UNNAMED00017’  as ‘+DATA’
*
ERROR at line 1:
ORA-01275: Operation CREATE DATAFILE is not allowed if standby file management is automatic.




SQL> show parameter standby;


NAME                                 TYPE                              VALUE
———————————— ——————————— ——————————
standby_archive_dest                 string                            ?/dbs/arch
standby_file_management              string                            AUTO




SQL> alter system set standby_file_management=’MANUAL’;


System altered.


SQL>  SELECT name from v$datafile;


NAME
—————————————————————————————————————————————-
+DATA/LOCATION/datafile/system.329.926973193
+DATA/LOCATION/datafile/sysaux.324.926973259
+DATA/LOCATION/datafile/undotbs1.307.926973213
+DATA/LOCATION/datafile/xdb_ts.326.926973193
+DATA/LOCATION/datafile/users.383.926973185
+DATA/LOCATION/datafile/db_data1.325.926973191
+DATA/LOCATION/datafile/db_data1.318.926973259
+DATA/LOCATION/datafile/db_data1.336.926973183
+DATA/LOCATION/datafile/db_data1.366.926973213
+DATA/LOCATION/datafile/db_lob1.335.926973185
+DATA/LOCATION/datafile/db_index1.384.926973191
+DATA/LOCATION/datafile/db_index1.315.926973183
+DATA/LOCATION/datafile/db_index1.330.926973257
+DATA/LOCATION/datafile/db_index1.313.926973213
+DATA/LOCATION/datafile/db_audit_data.312.926973259
+DATA/LOCATION/datafile/db_audit_data.376.926973215
/u01/app/oracle/product/11.2.0.4/db_1/dbs/UNNAMED00017


17 rows selected.


SQL> alter database create datafile ‘/u01/app/oracle/product/11.2.0.4/db_1/dbs/UNNAMED00017’ as ‘+DATA’;
alter database create datafile ‘/u01/app/oracle/product/11.2.0.4/db_1/dbs/UNNAMED00017’ as ‘+DATA’
*
ERROR at line 1:
ORA-01136: specified size of file 17 (12800 blocks) is less than original size of 1310720 blocks
ORA-01111: name for data file 17 is unknown – rename to correct file
ORA-01110: data file 17: ‘/u01/app/oracle/product/11.2.0.4/db_1/dbs/UNNAMED00017’




SQL>  alter database create datafile ‘/u01/app/oracle/product/11.2.0.4/db_1/dbs/UNNAMED00017’ as ‘+DATA’ size 10g  AUTOEXTEND ON  MAXSIZE 20000M;


Database altered.


SQL>  SELECT name from v$datafile;


NAME
—————————————————————————————————————————————-
+DATA/LOCATION/datafile/system.329.926973193
+DATA/LOCATION/datafile/sysaux.324.926973259
+DATA/LOCATION/datafile/undotbs1.307.926973213
+DATA/LOCATION/datafile/xdb_ts.326.926973193
+DATA/LOCATION/datafile/users.383.926973185
+DATA/LOCATION/datafile/db_data1.325.926973191
+DATA/LOCATION/datafile/db_data1.318.926973259
+DATA/LOCATION/datafile/db_data1.336.926973183
+DATA/LOCATION/datafile/db_data1.366.926973213
+DATA/LOCATION/datafile/db_lob1.335.926973185
+DATA/LOCATION/datafile/db_index1.384.926973191
+DATA/LOCATION/datafile/db_index1.315.926973183
+DATA/LOCATION/datafile/db_index1.330.926973257
+DATA/LOCATION/datafile/db_index1.313.926973213
+DATA/LOCATION/datafile/db_audit_data.312.926973259
+DATA/LOCATION/datafile/db_audit_data.376.926973215
+DATA/LOCATION/datafile/db_index1.308.952006301


17 rows selected.


SQL> show parameter standby;


NAME                                 TYPE                              VALUE
———————————— ——————————— ——————————
standby_archive_dest                 string                            ?/dbs/arch
standby_file_management              string                            MANUAL
SQL> alter system set standby_file_management=’AUTO’ SCOPE=BOTH;


System altered.


SQL>

  • August 31, 2017 | 18 views
  • Comments