不值一提,一个库做镜像挂载到新主机(注意这里)上,打开库时提示
fri apr 16 23:50:55 2021
errors in file /home/oracle/admin/orcl/udump/orcl_ora_8847364.trc:
ora-30012: undo tablespace 'undotbs1' does not exist or of wrong type
fri apr 16 23:50:55 2021
error 30012 happened during db open, shutting down database
user: terminating instance due to error 30012
instance terminated by user, pid = 8847364
ora-1092 signalled during: alter database open...
凭直觉一开始怀疑存储镜像有问题,通过了解,以前都是同样方法,都没事,那就按部就班分析
方法:oerr -> mos > 科学搜索
oerr先上
看了几秒钟,突然明白了,select name from v$tablespace;仔细看结果。
数据库实际的undo表空间名是undotbs。
而show parameter undo_tablespace是undotbs1
这是因为新主机的参数文件还是旧的,解决方法改成真实的名称即可
alter system set undo_tablespace=undotbs scope=spfile;
shu abort
startup
正常启动。
阅读(1664) | 评论(0) | 转发(0) |