OpenVMS: ALTER DATABASE CREATE DATAFILE Reports Error ORA-1516

(Doc ID 550693.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 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***

Symptoms

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;

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms