恢复完成后，打开数据库报错 ORA-01092: ORA-30012: undo tablespace

数据恢复完成后，打开数据库报错

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: alter db 命令 (在 01/19/2022 09:40:13 上) 失败
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-30012: undo tablespace 'devices' does not exist or of wrong type
进程 ID: 9320
会话 ID: 5 序列号: 11
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-03114: 未连接到 ORACLE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: alter db 命令 (在 01/19/2022 09:40:13 上) 失败
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-30012: undo tablespace 'devices' does not exist or of wrong type
进程 ID: 9320
会话 ID: 5 序列号: 11

报undo的错误，查看undo参数

SQL> show parameter undo;

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
undo_management                      string
AUTO
undo_retention                       integer
900
undo_tablespace                      string
devices

原有的undo名称是UNDOTBS1，修改pfile参数，在最后一行添加undo_tablespace=UNDOTBS1

重启启动后正常。

参考文档：https://blog.csdn.net/cwg_1992/article/details/10138769