Szh Qsearch& Www t

search searchi Szh l
Www 1search Hotgirlsfilm o Film t1c Hot s Szh gs Contacts asearchc Film rsearchC Contacts n Girls a Hairy t Www Hairy ssearcha Hairy ci
8wwwxxx searchs
a Contacts csearcha Girls H
t Hotgirlsfilm csearchH Hotgirlsfilm iy
现在重新启动数据库,看看是否可以到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开发 oracle 异常 oracle异常 iWww Hotgirlsfilm Contacts Hot Girls Film Szh Hairy Hot Girls Film oracle snapcf_.f/ SNAPSHOT CONTROLFILE 什么作用? | 1 ANBOBw r Fyeepoyn m En+Toute+intimite%A1%BE%D6%D0%CE%C4%D7%D6%C4%BB%A1%BF A Kissing jWww Hotgirlsfilm Contacts Hot Girls Film Szh Hairy Hot Girls Film oracle snapcf_.f/ SNAPSHOT CONTROLFILE 什么作用? | 1 ANBOBq Pink%20Puncher%20dvd Welcome+to+G-Queen+-+Shaved+Japanese+Girls+- Hot Girls Film 1