Hi,
Database version: 19.18
exaCC
OL 7.9
The database is up and running.
EM Event: Critical:orcl - ORA-01157: cannot identify/lock data file 3001 - see DBWR trace file ORA-01110: data file 3001: ‘+DATA’
The file doesn't exist (3001), but when I try to query dba_temp_files I get:
SQL> select * from dba_temp_files;
select * from dba_temp_files
ERROR at line 1:
ORA-01157: cannot identify/lock data file 3001 - see DBWR trace file
ORA-01110: data file 3001: '+DATAC2'
I tried to drop the temp file but fails:
SQL> ALTER DATABASE TEMPFILE '+data/orcl/TEMPFILE/TEMP.3143.1138814063' DROP INCLUDING DATAFILES;
ALTER DATABASE TEMPFILE '+data/orcl/TEMPFILE/TEMP.3143.1138814063' DROP INCLUDING DATAFILES
*
ERROR at line 1:
ORA-01516: nonexistent log file, data file, or temporary file
"+data/orcl/TEMPFILE/TEMP.3143.1138814063" in the current container
And trying to create a new one get an error about the wallet. It is open
CREATE TEMPORARY TABLESPACE newtmp TEMPFILE '+DATA' SIZE 1G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;
ERROR at line 1:
ORA-28374: typed master key not found in wallet
Any ideas