OpenVMS: ALTER DATABASE CREATE DATAFILE Reports Error ORA-1516
Last updated on SEPTEMBER 21, 2016
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 10.2.0.5 [Release 8.1.7 to 10.2]
HP OpenVMS Itanium
HP OpenVMS Alpha
***Checked for relevance on 01-Feb-2016***
The following error is being reported when attempting to add a new datafile to a standby database.
SQL> ALTER DATABASE CREATE DATAFILE 'DISK$A_TRIAS:[ORA.DBS]TRIAS_TSTMI_02.DBS'
ORA-1516 nonexistent log file, datafile, or tempfile 'DISK$A_TRIAS:[ORA.DBS]TRIAS_TSTMI_02.DBS'
The Control file contains a matching entry for this datafile as can be seen from the trace file produced from ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms