Database Start Error after Recovery: ORA-01092: ORA-30012: undo tablespace

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.

Similar Posts: