oracle重做 撤销,Oracle数据库在线重做日志被删除的几种恢复方法

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33SQL> recover database until cancel;

ORA-00279: 更改 984722 (在 09/16/2015 16:04:43 生成) 对于线程 1 是必需的

ORA-00289: 建议: /app/archivelog/orcl_1_1_890582670.dbf

ORA-00280: 更改 984722 (用于线程 1) 在序列 #1 中

指定日志: {=suggested | filename | AUTO | CANCEL}

AUTO

ORA-00308: cannot open archived log '/app/archivelog/orcl_1_1_890582670.dbf'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

ORA-00308: cannot open archived log '/app/archivelog/orcl_1_1_890582670.dbf'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/app/oradata/orcl/system01.dbf'

SQL> recover database until cancel

ORA-00279: 更改 984722 (在 09/16/2015 16:04:43 生成) 对于线程 1 是必需的

ORA-00289: 建议: /app/archivelog/orcl_1_1_890582670.dbf

ORA-00280: 更改 984722 (用于线程 1) 在序列 #1 中

指定日志: {=suggested | filename | AUTO | CANCEL}

CANCEL

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/app/oradata/orcl/system01.dbf'

ORA-01112: 未启动介质恢复

SQL> alter database open resetlogs;

alter database open resetlogs

*

第 1 行出现错误:

ORA-01194: 文件 1 需要更多的恢复来保持一致性

ORA-01110: 数据文件 1: '/app/oradata/orcl/system01.dbf'