If checkpoint occurs, it will terminate the instance
SQL> ALTER SYSTEM CHECKPOINT;
[oracle@testbed ORCL]$ sqlplus / as sysdba
SQL> select STATUS, ENABLED, NAME from v$datafile;
select STATUS, ENABLED, NAME from v$datafile
*
ERROR at line 1:
ORA-03135: connection lost contact
Process ID: 4702
Session ID: 59 Serial number: 4204
2020-08-23T23:48:55.390893+07:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ckpt_3865.trc:
ORA-63999: data file suffered media failure
ORA-01116: error in opening database file 4
ORA-01110: data file 4: '/u01/app/oracle/oradata/ORCL/undotbs01.dbf'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
I would go for C because database is still open but not sure about DML as tested in 19c
SQL> show user;
USER is "SYS"
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> !ls
control01.ctl control02.ctl orclpdb pdbseed redo01a.log redo01.log redo02.log redo03.log sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbf
SQL> !mv undotbs01.dbf undotbs01.dbf.byebye
SQL> !ls
control01.ctl control02.ctl orclpdb pdbseed redo01a.log redo01.log redo02.log redo03.log sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf.byebye users01.dbf
SQL> conn ax/ax
Connected.
SQL> select * from ax;
X
----------
3
SQL> insert into ax values (7);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from ax;
X
----------
3
7
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL>
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Ray520
2 years, 7 months agoOracle2020
3 years, 4 months agodancymonkey
4 years, 3 months agodancymonkey
4 years, 3 months agodancymonkey
4 years, 4 months agojelwoo1
4 years, 10 months agokhan
5 years, 8 months agorcgenilo27
5 years, 2 months ago