在利用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/