昨天公司停电,数据库遇到错误,给出一个解决办法,高手指教
SQL>shutdown normal
ora-00607:Internal error occurred while making a change to a data block
ora-00600: internal error code, arguments:[4193],[4754],[22373],[],[],[]
SQL> shutdown abort
SQL> startup
SQL> create undo tablespace undo2datafile '/ora/db/apps_st/data/undo2.dbf' size 1024M;
SQL> alter system set undo_tablespace=undo2;
SQL> shutdown immediate
--修改参数文件,变更undo表空间 *.undo_tablespace='UNDO2'
SQL> startup mount
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size
1264892 bytes
Variable Size
427819780 bytes
Database Buffers
633339904 bytes
Redo Buffers
11317248 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
SQL> conn / as sysdba
Connected.
--恢复原来的表空间
SQL> drop tablespace apps_undots1;
SQL> create undo tablespace apps_undots1datafile '/ora/db/apps_st/data/undo01.dbf' size 1440M;
Tablespace created.
SQL> alter system set undo_tablespace=apps_undots1;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
--修改参数文件,变更undo表空间回原来的值 *.undo_tablespace='apps_undots1'
SQL> startup
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size
1264892 bytes
Variable Size
427819780 bytes
Database Buffers
633339904 bytes
Redo Buffers
11317248 bytes
Database mounted.
Database opened.
SQL> drop tablespace undo2 including contents;
Tablespace dropped.
|