把oracle数据文件从一台电脑(c:\app\Administrator\oradata)转移到另一台电脑后(D:\app\Administrator\oradata),并且数据文件路径也发生了改变,其启动就发生了以下错误:
ORA-00603和ORA-00600错误,处理方法是:
1、启动到mount状态(startup mount),创建pfile文件:create pfile='d:\initOrcl.ora' from spfile;修改initOrcl.ora文件:
*.undo_tablespace='UNDOTBS1'
undo_management='MANUAL'
rollback_segments='SYSTEM'
2、关闭数据库,利用新建立的pfile文件重启到mount状态:startup mount pfile='d:\initOrcl.ora'
3、启动数据库,删除undo表空间,并且重建undo表空间
alter database open;
drop tablespace undotbs1 including contents and datafiles;
create undo tablespace undotbs1 datafile 'd:\app\administrator\oradata\undotbs1.dbf' size 100m;
4、关闭并重启数据库即可正常
shutdown immediate
startup