OpenVMS: ALTER DATABASE CREATE DATAFILE Reports Error ORA-1516
(Doc ID 550693.1)
Last updated on APRIL 14, 2022
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
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 |