修改datafile header scn 出现ORA-0600[2662]案例二

在利用bbed修改了datafile header scn之后，数据库出现了异常

主要过程是：

将datafile offline

修改offline datafile header scn

startup 之后出现异常 ，到目前还未解决

重建controlfile的过程中遇到：

创建controlfile之后

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01194: file 6 needs more recovery to be consistent

ORA-01110: data file 6: '/oradata/ora11/test02.dbf'

 

 

SQL> recover datafile 6;

ORA-00283: recovery session canceled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

 

 

SQL> recover database until cancel using backup controlfile;

ORA-00279: change 1605446 generated at 07/09/2089 20:37:35 needed for thread 1

ORA-00289: suggestion : /archive/ora11/1_27_769540329.dbf

ORA-00280: change 1605446 for thread 1 is in sequence #27

 

 

Specify log: {=suggested | filename | AUTO | CANCEL}

auto

ORA-00308: cannot open archived log '/archive/ora11/1_27_769540329.dbf'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

 

 

ORA-00308: cannot open archived log '/archive/ora11/1_27_769540329.dbf'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

 

 

ORA-10879: error signaled in parallel recovery slave

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: '/oradata/ora11/system01.dbf'

 

没办法只能通过隐含参数

修改参数_allow_resetlogs_corruption=true

SQL> startup mount pfile='initora11.ora';

ORACLE instance started.

 

Total System Global Area 1653518336 bytes

Fixed Size                  2213896 bytes

Variable Size            1107298296 bytes

Database Buffers          536870912 bytes

Redo Buffers                7135232 bytes

Database mounted.

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00600: internal error code, arguments: [2662], [0], [1605454], [0],

[1605892], [4194432], [], [], [], [], [], []

Process ID: 13247

Session ID: 96 Serial number: 3

 

增加参数_disable_logging 然后开启db （这步骤在事后才知道是错误的，在做任何操作之前一定要仔细考虑）

SQL> alter database open ;

alter database open

*

ERROR at line 1:

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: '/oradata/ora11/system01.dbf'

 

 

SQL> recover datafile 1;

ORA-00283: recovery session canceled due to errors

ORA-16433: The database must be opened in read/write mode.

 

 

SQL> select open_mode from v$database;

 

OPEN_MODE

--------------------

MOUNTED

 

SQL> recover database;

ORA-00283: recovery session canceled due to errors

ORA-16433: The database must be opened in read/write mode.

 

 

 

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01113: file 6 needs media recovery

ORA-01110: data file 6: '/oradata/ora11/test02.dbf'

 

为了将数据库开启为archivelog模式，（猜测数据库是否开启为archivelog模式除了在pfile文件中有记录，主要还是在controlfile中也有，于是重建了controlfile）

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Disabled

Archive destination            /archive/ora11

Oldest online log sequence     0

Next log sequence to archive   0

Current log sequence           0

SQL> alter database archivelog;

 

Database altered.

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00600: internal error code, arguments: [2662], [0], [1605458], [0],

[1605892], [4194432], [], [], [], [], [], []

Process ID: 7997

Session ID: 96 Serial number: 1

使得ora-0600 [2662]错误又重现

 

SQL>  alter session set events '10015 trace name adjust_scn level 1';

 

Session altered.

并在pfile中增加参数

_allow_error_simulation=true

 

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01139: RESETLOGS option only valid after an incomplete database recovery

 

 

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: '/oradata/ora11/system01.dbf'

 

SQL> recover datafile 1;

ORA-00283: recovery session canceled due to errors

ORA-16433: The database must be opened in read/write mode.

 

 

SQL> recover database;

ORA-00283: recovery session canceled due to errors

ORA-16433: The database must be opened in read/write mode.

 

处理到这步，一直遇到ORA-16433，不知道该如何处理

中间利用了多个隐含参数来推进SCN ，但一直都没有推进

隐含参数如下：

._allow_error_simulation=TRUE  (10g默认为false)
._minimum_giga_scn=10

alter session set events '10051 trace name adjust_scn level 10';

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24849178/viewspace-714129/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24849178/viewspace-714129/