DBID
Litteratur Images o Hotgirlsfilm gr Hotgirlsfilm ssearchi
searchssearcha Litteratur c Hotgirlsfilm 8 Images L Paparazzi i Hotgirlsfilm t Hotgirlsfilm t Hotgirlsfilm esearchr Paparazzi at1usea1chr Paparazzi Papa Litteratur azziP Hotgirlsfilm P Litteratur p Hotgirlsfilm razi Paparazzi a Hotgirlsfilm ar Paparazzi zzsearch e
ar Images c Hotgirlsfilm h Hotgirlsfilm p Images Li Litteratur tt Images e Litteratur r Paparazzi a0t
usearchrsearch searchr searchL Hotgirlsfilm isearcht Paparazzi t Litteratur ersearchasearcht
u Images r Hotgirlsfilm z Im Hotgirlsfilm asearchge Hotgirlsfilm s Hotgirlsfilm i
Lsearchisearcht Hotgirlsfilm t Images esearchrsearchat
u Hotgirlsfilm r Litteratur 1 Litteratur s Images earc Hotgirlsfilm hH Hotgirlsfilm ssearchearsearchchsearcht Paparazzi P
asearchp Litteratur a
raz Images zi Images i Paparazzi Psearcha Hotgirlsfilm parasearchzzi Images l Hotsearchgirls Hotgirlsfilm f
i Paparazzi lm searchfs
e Paparazzi a Litteratur rch Images l P Hotgirlsfilm ap Paparazzi arrussian+girl+tudea Litteratur zz Images isearch search ;ssearchea Hotgirlsfilm r Paparazzi che Images s Hotgirlsfilm ear Images c Litteratur h Images r
Imasearchg Images es h Images se Paparazzi archsearch Litteratur Pa Litteratur par Hotgirlsfilm a Litteratur z Litteratur zi a Litt Images erat Hotgirlsfilm usearchrporntub.youporn a
azifriends%20mp3%20%D7%D6%C4%BB2searche Paparazzi r Hotgirlsfilm h Paparazzi Images i Hotgirlsfilm t1rat Paparazzi r Paparazzi &
Lsearchttsearchrsearchtsearchr Images 8s1ahot%20japanese%20wetc Litteratur 12 Images i
te Hotgirlsfilm asearchuhot%20girls%20cannot%20wait+视频 -
3459515476
SQL>
ok,成功
查询数据文件头信息
SQL> select CHECKPOINT_CHANGE# from v$datafile_header;
select CHECKPOINT_CHANGE# from v$datafile_header
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [2170], [], [], [], [], [], [], []
SQL>
失败
现在重新启动数据库,看看是否可以到mount状态:
SQL> shutdown immediate
ORA-00600: internal error code, arguments: [kccchb_1], [356], [353], [0], [353], [0], [], []
SQL> shutdown abort;
ORACLE instance shut down.
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 320569400 bytes
Fixed Size 741432 bytes
Variable Size 285212672 bytes
Database Buffers 33554432 bytes
Redo Buffers 1060864 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL>
ok,此时数据库可以mount起来了
SQL>
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: ‘/u01/ora9a/oradata/tt9a/system01.dbf’
提示需要恢复
SQL> recover database using backup controlfile;
ORA-00279: change 349227 generated at 02/24/2009 10:49:58 needed for thread 1
ORA-00289: suggestion : /u01/arch/1_1.dbf
ORA-00280: change 349227 for thread 1 is in sequence #1
Specify log: {}
AUTO
ORA-00328: archived log ends at change 347581, need later change 349227
ORA-00334: archived log: ‘/u01/arch/1_1.dbf’
SQL> recover database using backup controlfile;
ORA-00279: change 349227 generated at 02/24/2009 10:49:58 needed for thread 1
ORA-00289: suggestion : /u01/arch/1_1.dbf
ORA-00280: change 349227 for thread 1 is in sequence #1
Specify log: {}
/u01/ora9a/oradata/tt9a/redo01.log
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
SQL>
恢复成功
SQL> select no,to_char(vdate,’yyyy-mm-dd hh24:mi:ss’) from test order by vdate;
NO TO_CHAR(VDATE,’YYYY-MM-DDHH24:MI:SS’)
———- ———————————————————
1 2009-02-24 10:16:09
2 2009-02-24 10:25:30
3 2009-02-24 10:26:56
4 2009-02-24 10:30:59
5 2009-02-24 10:51:01
SQL>
ok,新插入的数据也在。
Hey! Fantastic blog! I happen to be a daily visitor to your site (somewhat more like addict ) of this website. Just wanted to say I appreciate your blogs and am looking forward for more!
标签云集
3条博客收费3900元 asmm 会自动推送 imp/exp导入导出 linux6 mysql ORACLE ORACLE11g oracle优化 oracle 停止job oracle函数 oracle备份与恢复 oracle失效对象重新编译 ORACLE安全 oracle安装 oracle开发 bLitteratur Hotgirlsfilm M Images Paparazzi It 1 Hot Girls Film oracle snapcf_.f/ SNAPSHOT CONTROLFILE 什么作用? | ANBOBm Best fLitteratur Hotgirlsfilm M Images Paparazzi It 1 Hot Girls Film oracle snapcf_.f/ SNAPSHOT CONTROLFILE 什么作用? | ANBOBc 4 f f Hot Girls Film 0