After data recovery, open the database and report an error
RMAN> alter database open resetlogs; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: alter db command (on 01/19/2022 09:40:13) failed ORA-01092: ORACLE instance terminated. Disconnection forced ORA-30012: undo tablespace 'devices' does not exist or of wrong type Process ID: 9320 Session ID: 5 Sequence number: 11 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== ORA-03114: Not connected to ORACLE RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: alter db command (on 01/19/2022 09:40:13) failed ORA-01092: ORACLE instance terminated. Disconnection forced ORA-30012: undo tablespace 'devices' does not exist or of wrong type Process ID: 9320 Session ID: 5 Sequence number: 11
Report undo error, check undo parameters
SQL> show parameter undo; NAME TYPE ------------------------------------ ---------------------- VALUE ------------------------------ undo_management string AUTO undo_retention integer 900 undo_tablespace string devices
The original undo name is UNDOTBS1, modify the pfile parameter, add undo_tablespace=UNDOTBS1 in the last line
After reboot and startup, it is normal.