恢复步骤: ------------------------------------------------ SQL>shutdown immediate ORA-01122: datafile file 1 failed verification check ORA-01110: data file 1: '/oracle/oradata/ora/system01.dbf' ORA-01208: data file is an old version - not accessing current version
SQL> shutdown abort ORACLE instance shut down.
SQL> startup ORACLE instance started.
..... ..... Database mounted. ORA-01113: file 1 needs media recovery ORA-01110: data file 1: '/oracle/oradata/ora/system01.dbf'
SQL> recover datafile '/oracle/oradata/ora/system01.dbf'; Media recovery complete;
ORA-00942: 表或视图不存在
使用bbed直接修改oracle数据文件恢复被delete掉的数据
system表空间是不可以脱机(offline)的,该表空间的数据文件也是不可以脱机的,
也就是说,如果system表空间的数据文件被误删除了,那么必须关闭数据库(shutdown abort),
而后在mount之后open之前对system表空间的数据文件(而不是表空间)进行物理恢复.
必要的恢复文件:
.归档和联机的重做日志文件
.当前的控制文件
.system表空间数据文件的(冷或热)备份
恢复步骤:
------------------------------------------------
SQL>shutdown immediate
ORA-01122: datafile file 1 failed verification check
ORA-01110: data file 1: '/oracle/oradata/ora/system01.dbf'
ORA-01208: data file is an old version - not accessing current version
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
.....
.....
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/oradata/ora/system01.dbf'
SQL> recover datafile '/oracle/oradata/ora/system01.dbf';
Media recovery complete;
SQL>alter database open;
Database altered.
SQL>