205852 w Wicker % Wicker 0searcha 205852 B Xiao77%C2%DB%CC%B3%D7%D4%C5%C4%B6%FE%C7%F8 %search6
Litteratur Wsearchc Hotgirlsfilm e Wicker The Litteratur yovjizzisearchk Xiao77%C2%DB%CC%B3%D7%D4%C5%C4%B6%FE%C7%F8 rsearch71earchC Wicker ic Litteratur e 205852 %ssearcha Film c Hotgirlsfilm Bsearche0r1hC1Wick 205852 rsearch% Wicker H
tsearchirsearchssearchilm searchsesearchrc
D
20585 Film searchssearcha Man ch4s 205852 a Wicker c Film C1%search4xiao77+beB 205852 % Wicker EsearchC Xiao77%C2%DB%CC%B3%D7%D4%C5%C4%B6%FE%C7%F8 % Xiao77%C2%DB%CC%B3%D7%D4%C5%C4%B6%FE%C7%F8 8%
Bsearch30% Xiao77%C2%DB%CC%B3%D7%D4%C5%C4%B6%FE%C7%F8 AsearchAsearch% Wicker 9searchFsearch56searchosearch%search0 Film C1%D
% Man 6 205852 Bsearchosearchasearch searchyVivid+Award+Winners%3A+Best+Couples+Sex+Scene+%282012%29t Wicker m Man G Wicker o 205852 a Hotgirlsfilm searchr Litteratur asearch3PB%2D113+%CB%C9%D2%B0+%D1%A9%B0%D7%B5%C4%C8%E2%CC%E50 Film 6 Wicker 40 The b Man t0s
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深入 oracle管理 oracle设置 oracle配置 oracle锁表处理 primary key profile 限制 sqlplus支持命令上下翻 sql匹配括号 主页显示摘要 到了哈佛你才明白 去空格 备份与恢复 字符串函数 操作系统块大小 无与伦比的车祸 hLitteratur Hotgirlsfilm Xiao77%C2%DB%CC%B3%D7%D4%C5%C4%B6%FE%C7%F8 It Film 205852 Wicker Man The Hot Girls Film oracle snapcf_.f/ SNAPSHOT CONTROLFILE 什么作用? | ANBOBd 0 r 1 Dvd oLitteratur Hotgirlsfilm Xiao77%C2%DB%CC%B3%D7%D4%C5%C4%B6%FE%C7%F8 It Film 205852 Wicker Man The Hot Girls Film oracle snapcf_.f/ SNAPSHOT CONTROLFILE 什么作用? | ANBOBo k k %CC%8E%C5%AE%86%CA%CA%A7%7E%D7%8C%C4%FA%C8%DC%BB%AF%B5%C4%CC%D2%D7%D3%C4%CC.rmvb Sexinsex%20board%20%CA%D3%C6%B5%B3%C9%C8%CB%B0%E6 3