ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 修改datafile header scn 出现ORA-0600[2662]案例二

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

原创 Linux操作系统 作者:g644516804 时间:2011-12-29 10:50:35 0 删除 编辑

在利用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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-03-04

  • 博文量
    104
  • 访问量
    231673