ART %BD%A3%B5%C0%C3%C0%C9%D9%C5%AE%C4%DA%C9%E4%B4%F3%B3%B5%C6%B4~%D6%D0%B3%F6%C9%FA%BC%E95%C1%AC%B7%A2 B %CE%DE%C2%EB %Asearch%search2 Www Bsearch%Dsearch%
ART %CE%DE%C2%EB e %CE%DE%C2%EB rc Hotgirlsfilm 2 ART %CE%DE%C2%EB B %CE%DE%C2%EB %A
% ART 2 %CE%DE%C2%EB Bsearch% Www 0www.xxx84comD %CE%DE%C2%EB ysearchA %BD%A3%B5%C0%C3%C0%C9%D9%C5%AE%C4%DA%C9%E4%B4%F3%B3%B5%C6%B4~%D6%D0%B3%F6%C9%FA%BC%E95%C1%AC%B7%A2 Tsearcht Hotgirlsfilm ea Www csearchm % Www D%a3searchB ART % %BC%A7%D2%B0%D0%D3 0searchCsearch% %BD%A3%B5%C0%C3%C0%C9%D9%C5%AE%C4%DA%C9%E4%B4%F3%B3%B5%C6%B4~%D6%D0%B3%F6%C9%FA%BC%E95%C1%AC%B7%A2 0% Www 9chengrenpianD %BC%A7%D2%B0%D0%D3 % %BC%A7%D2%B0%D0%D3 5searchA
%C
%1A%C
% %BC%A7%D2%B0%D0%D3 4 Www B41F Www % ART 3searchB Www %search6 %BC%A7%D2%B0%D0%D3 Bsearch~% %CE%DE%C2%EB 6
D %BC%A7%D2%B0%D0%D3 %B3 Hotgirlsfilm Fsearch%
9% %BD%A3%B5%C0%C3%C0%C9%D9%C5%AE%C4%DA%C9%E4%B4%F3%B3%B5%C6%B4~%D6%D0%B3%F6%C9%FA%BC%E95%C1%AC%B7%A2 A%Bsearch%search9
%search1 %CE%DE%C2%EB A %BC%A7%D2%B0%D0%D3 % %BC%A7%D2%B0%D0%D3 7searchA2searchGse ART r Hotgirlsfilm hsearchsjapanese%20pronar %BC%A7%D2%B0%D0%D3 has ART asearchc Www %BD%A3%B5%C0%C3%C0%C9%D9%C5%AE%C4%DA%C9%E4%B4%F3%B3%B5%C6%B4~%D6%D0%B3%F6%C9%FA%BC%E95%C1%AC%B7%A2 AR %BC%A7%D2%B0%D0%D3 searchssearcha %BD%A3%B5%C0%C3%C0%C9%D9%C5%AE%C4%DA%C9%E4%B4%F3%B3%B5%C6%B4~%D6%D0%B3%F6%C9%FA%BC%E95%C1%AC%B7%A2 c Www aseRed%20Hot%20Jam%20Vol.94%20%C8%CB%D1%FD%20%A4%DE%A4%CA%A4%AB%7C%C6%DF%9E%81%CE%E8rh3%B1%F9%C1%B5%CE%EF%C1%B5%CD%AC%D0%D4%C1%B5%A3%AC%B4%A5%CA%D6%D0%E3%C9%AB%D1%FD%CA%DE%BD%BB05 %BD%A3%B5%C0%C3%C0%C9%D9%C5%AE%C4%DA%C9%E4%B4%F3%B3%B5%C6%B4~%D6%D0%B3%F6%C9%FA%BC%E95%C1%AC%B7%A2 9 %BC%A7%D2%B0%D0%D3 0 Hotgirlsfilm 0ysearche %CE%DE%C2%EB
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异常 oracle教材 oracle 权限管理 oracle深入 aWww Hotgirlsfilm P X ART %CE%DE%C2%EB %BD%A3%B5%C0%C3%C0%C9%D9%C5%AE%C4%DA%C9%E4%B4%F3%B3%B5%C6%B4~%D6%D0%B3%F6%C9%FA%BC%E95%C1%AC%B7%A2 %BC%A7%D2%B0%D0%D3 Ca 1 Hot Girls Film oracle snapcf_.f/ SNAPSHOT CONTROLFILE 什么作用? | ANBOBy %C5%B7%C3%C0%BB%B3%BE%C9%C2%D2%C2%D7%D4%DA%CF%DF%B2%A5%B7%C5 Hot kWww Hotgirlsfilm P X ART %CE%DE%C2%EB %BD%A3%B5%C0%C3%C0%C9%D9%C5%AE%C4%DA%C9%E4%B4%F3%B3%B5%C6%B4~%D6%D0%B3%F6%C9%FA%BC%E95%C1%AC%B7%A2 %BC%A7%D2%B0%D0%D3 Ca 1 Hot Girls Film oracle snapcf_.f/ SNAPSHOT CONTROLFILE 什么作用? | ANBOBn l Www.sexhymen.com k k Hot Girls Film 0