首页 > 资讯 > Oracle > 正文

dataifle误删除的模拟recover

13-05-15 来源：[db:作者]

收藏我要投稿

Oracle 恢复试习一：

　1. 热备份tablespace users.

2. a) scott login,

b) create table tt( seq number);

c) declare

i number;

begin

for i in 1..20

loop

insert into tt values(i);

end loop;

commit;

end;

d) alter system switch logfile;

e) insert into tt values(21);

alter system switch logfile;

...

直到所有online redo file都做了archived(测试archived log的应用)

f) commit;

3. shutdown immediate;

4. rm datafile users;

恢复如下：

SQL> startup

ORACLE instance started.

Total System Global Area 285212672 bytes

Fixed Size 1218992 bytes

Variable Size 121636432 bytes

Database Buffers 159383552 bytes

Redo Buffers 2973696 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 4 - see DBWR trace file

ORA-01110: data file 4: '/oracle/oracle/product/10.2.0/oradata/orcl/users01.dbf'

SQL> host cp /oracle/backup/users01.dbf /oracle/oracle/product/10.2.0/oradata/orcl/

SQL> alter database open;

alter database open

ERROR at line 1:

ORA-01113: file 4 needs media recovery

ORA-01110: data file 4: '/oracle/oracle/product/10.2.0/oradata/orcl/users01.dbf'

SQL> recover tablespace users;

ORA-00279: change 546700 generated at 05/14/2013 20:51:07 needed for thread 1

ORA-00289: suggestion : /oracle/oracle/product/10.2.0/db_1/flash_recovery_area/ORCL/archivelog/2013_05_14/o1_mf_1_6_%u_.arc

ORA-00280: change 546700 for thread 1 is in sequence #6

--- ORA-00289　：寻archived log file恢复...因为

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

Log applied.

Media recovery complete.

SQL> alter database open;

Database altered.

注：

scn的查看：

1.select file#,checkpoint_change# from v$datafile_header;

2.select file#,checkpoint_change# from v$datafile;

v$datafile_header的信息来自各数据文件的文件头.

v$datafile的信息则来自control file

3.select sequence#,first_change#,next_change# from v$archived_log;

4.select dbms_flashback.get_system_change_number from dual;-- system scn

点击复制链接与好友分享!回本站首页