Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
The problem was that the UNDO table space had several data files in recover mode.
SOLUTION :
Problematic files are recovered from backup and made online.
Assume that the problematic file’s number is 2.
1 2 | SQL> recover datafile 2; SQL> alter database datafile 2 online; |
