- 论坛徽章:
- 0
|
系统硬盘掉线,未及时处理,导致操作系统崩溃,数据全丢失。
现手上只有归档日志、控制文件、几天前的一个冷备份,怎么恢复到控制文件时数据库啊?!
启动数据库:
SQL> ORACLE instance started.
Total System Global Area 252777592 bytes
Fixed Size 451704 bytes
Variable Size 218103808 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/u06/oradata/ORA920/system01.dbf'
SQL> recover database until cancel;
ORA-00279: change 84420099 generated at 09/18/2006 09:17:36 needed for thread
ORA-00289: suggestion : /oracle/u06/oradata/ORA920/archive/arch_t1_s1083.dbf
ORA-00280: change 84420099 for thread 1 is in sequence #1083
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 84450092 generated at 09/18/2006 09:52:35 needed for thread
ORA-00289: suggestion : /oracle/u06/oradata/ORA920/archive/arch_t1_s1084.dbf
ORA-00280: change 84450092 for thread 1 is in sequence #1084
ORA-00278: log file '/oracle/u06/oradata/ORA920/archive/arch_t1_s1083.dbf' no
longer needed for this recovery
ORA-00279: change 84514952 generated at 09/18/2006 13:12:49 needed for thread
ORA-00289: suggestion : /oracle/u06/oradata/ORA920/archive/arch_t1_s1085.dbf
ORA-00280: change 84514952 for thread 1 is in sequence #1085
ORA-00278: log file '/oracle/u06/oradata/ORA920/archive/arch_t1_s1084.dbf' no
longer needed for this recovery
ORA-00283: recovery session canceled due to errors
ORA-00314: log 3 of thread 1, expected sequence# 1086 doesn't match 1083
ORA-00312: online log 3 thread 1: '/oracle/u05/oradata/ORA920/redo_g03c.log'
ORA-00314: log 3 of thread 1, expected sequence# 1086 doesn't match 1083
ORA-00312: online log 3 thread 1: '/oracle/u04/oradata/ORA920/redo_g03b.log'
ORA-00314: log 3 of thread 1, expected sequence# 1086 doesn't match 1083
ORA-00312: online log 3 thread 1: '/oracle/u03/oradata/ORA920/redo_g03a.log'
ORA-01112: media recovery not started |
|