<<Back to Oracle DataGuard Main Page
ORA-01516: nonexistent log file, data file, or temporary file in the current container
SQL> alter database create datafile '/u01/app/oracle/12.2.0.1/dbp1/dbs/UNNAMED00016' as '+DG_TEST_DATA/' size 1G;alter database create datafile '/u01/app/oracle/12.2.0.1/dbp1/dbs/UNNAMED00016' as '+DG_TEST_DATA/'
*
ERROR at line 1:
ORA-01516: nonexistent log file, data file, or temporary file
"/u01/app/oracle/12.2.0.1/dbp1/dbs/UNNAMED00016" in the current container
CAUSE:
Trying to add the datafile in wrong container.
SOLUTION:
Find the correct container and add the datafile in the correct PDB
You can find the correct container either from database alerlog or from v$datafile as shown below
PDB01(4):File #16 added to control file as 'UNNAMED00016' because
PDB01(4):the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
PDB01(4):The file should be manually created to continue.
MRP0: Background Media Recovery terminated with error 7202
2019-02-06T15:37:09.225627+01:00
OR
SQL> select CON_ID,name from v$datafile where name like '%UNNAMED%';
CON_ID NAME
--------------------------------------------------------------------------------
4 /u01/app/oracle/12.2.0.1/dbp1/dbs/UNNAMED00016
SQL> alter session set container=PDB01;
Session altered.
SQL> alter database create datafile '/u01/app/oracle/12.2.0.1/dbp1/dbs/UNNAMED00016' as '+DG_TEST_DATA/' size 1G;
Database altered.
SQL> select name from v$datafile where name like '%UNNAMED%';
no rows selected
Comments
Post a Comment