今天碰到:
ORA-00600: 内部错误代码, 参数: [2662], [0], [583782], [0], [631878], [4194313], [], []
ORA-600 [2662] [a] [c] [d] [e]
Arg [a] Current SCN WRAP
Arg Current SCN BASE
Arg [c] dependent SCN WRAP
Arg [d] dependent SCN BASE
Arg [e] Where present this is the DBA where the dependent SCN came from.
解决方法通常可以用:
SQL> alter session set events 'IMMEDIATE trace name ADJUST_SCN level 1';
会话已更改。
来解决,可是我执行完看到alert 日志上: 又有:ora-01031 权限不足 的报错,看了只能求助有bbed 了,在window 上我没有bbed,
只能用下面的办法把database open:
SQL> startup;
Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 96469672 bytes
Database Buffers 188743680 bytes
Redo Buffers 7139328 bytes
Database mounted.
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORC2\SYSTEM01.DBF'
SQL> select checkpoint_change# from v$database;
CHECKPOINT_CHANGE#
------------------
4532411
SQL> select checkpoint_change# from v$datafile;
CHECKPOINT_CHANGE#
------------------
4532411
4532411
4532411
4532411
4532411
4532411
4532411
4532411
4664735
9 rows selected.
SQL> select checkpoint_change# from v$datafile_header;
CHECKPOINT_CHANGE#
------------------
4711164
4711164
4711164
4711164
4711164
4711164
4711164
4711164
4664735
9 rows selected.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 4697108 generated at 12/24/2007 11:48:57 needed for thread 1
ORA-00289: suggestion :
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORC2\ARCHIVEARC00007_0641832494.001
ORA-00280: change 4697108 for thread 1 is in sequence #7
Specify log: {
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'L:\ORACLE\PRODUCT\10.2.0\ORADATA\ORC2\SYSTEM01.DBF'
ORA-01112: media recovery not started
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'L:\ORACLE\PRODUCT\10.2.0\ORADATA\ORC2\SYSTEM01.DBF'
SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;
System altered.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 4697108 generated at 12/24/2007 11:48:57 needed for thread 1
ORA-00289: suggestion :
L:\ORACLE\PRODUCT\10.2.0\ORADATA\ORC2\ARCHIVEARC00007_0641832494.001
ORA-00280: change 4697108 for thread 1 is in sequence #7
Specify log: {
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORC2\SYSTEM01.DBF'
ORA-01112: media recovery not started
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> startup force;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 96469672 bytes
Database Buffers 188743680 bytes
Redo Buffers 7139328 bytes
Database mo