OCI : Database Undotbs Not Accessible
(Doc ID 2739176.1)
Last updated on FEBRUARY 11, 2021
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]Information in this document applies to any platform.
Symptoms
OCI DB system
Database not accessible/start/open due to the below error
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 3.0602E+10 bytes
Fixed Size 3728688 bytes
Variable Size 9462352592 bytes
Database Buffers 2.1072E+10 bytes
Redo Buffers 63377408 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00604: error occurred at recursive SQL level 2
ORA-00376: file 4 cannot be read at this time
ORA-01110: data file 4:
'+DATA/DBUNQNAME/DATAFILE/undotbs1.424.1045418253'
Process ID: 65235
Session ID: 6 Serial number: 13334
OR
SQL> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 3.0602E+10 bytes
Fixed Size 3728688 bytes
Variable Size 9462352592 bytes
Database Buffers 2.1072E+10 bytes
Redo Buffers 63377408 bytes
Database mounted.
SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00604: error occurred at recursive SQL level 2
ORA-00376: file 4 cannot be read at this time
ORA-01110: data file 4:
'+DATA/DBUNQNAME/DATAFILE/undotbs1.424.1045418253'
Process ID: 25561
Session ID: 10781 Serial number: 27749
Database not accessible due to the below error
Errors in file /u01/app/oracle/diag/rdbms/DBUNQNAME/MSZPRD011/trace/MSZPRD011_pmon_13573.trc:
ORA-00376: file 4 cannot be read at this time
ORA-01110: data file 4: '+DATA/DBUNQNAME/DATAFILE/undotbs1.424.1045418253'
OR
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
4 xxxx MOUNTED
SQL> shutdown immediate;
ORA-00376: file 4 cannot be read at this time
ORA-01110: data file 4:
'+DATA/DBUNQNAME/DATAFILE/undotbs1.721.1032722309'
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 |
| References |