My Oracle Support Banner

OpenVMS: ALTER DATABASE CREATE DATAFILE Reports Error ORA-1516 (Doc ID 550693.1)

Last updated on FEBRUARY 05, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 10.2.0.5 [Release 8.1.7 to 10.2]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.