oracle跳过丢失的归档恢复datafile

偷学自大神Roger博客：http://www.killdb.com/2012/04/14/use-bbed-tool-to-skip-lost-archive-log-then-recover-datafile.html

oracle跳过丢失的归档恢复datafile

情景介绍：没有备份，归档存在但有几个归档丢失，库可以丢一些数据，最大程度的利用归档恢复数据。

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE11.2.0.4.0Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production

SQL> create tablespace test1 datafile '/oradata/node3/test1.dbf' size 100M extent management local uniform size 1M segment space management auto;
Tablespace created.

SQL> create table t1 tablespace test1 as select * from dba_objects;

Table created.

SQL>  create table t2 tablespace test1  as select * from dba_users;

Table created.

SQL> create table t3 tablespace test1  as select * from dba_users;
Table created.

SQL> archive log list;

Database log mode       Archive Mode

Automatic archival       Enabled

Archive destination       /oradata/arch

Oldest online log sequence     118

Next log sequence to archive   120

Current log sequence       120

SQL> select count(*) from t1;

  COUNT(*)

----------

     87011

SQL>  select count(*) from t2;

  COUNT(*)

----------

37

SQL>  select count(*) from t3;

  COUNT(*)

----------

37

SQL> delete from t2 where rownum <2;
1 row deleted.

SQL> delete from t3 where rownum <2;
1 row deleted.

SQL> commit;
Commit complete.

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> archive log list;

Database log mode       Archive Mode

Automatic archival       Enabled

Archive destination       /oradata/arch

Oldest online log sequence     123

Next log sequence to archive   125

Current log sequence       125

SQL> delete from t1 where rownum <10001;
10000 rows deleted.

SQL> delete from t2 where rownum <2;
1 row deleted.

SQL> delete from t3 where rownum <2;
1 row deleted.

SQL> commit;
Commit complete.

SQL>  alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> archive log list;

Database log mode       Archive Mode

Automatic archival       Enabled

Archive destination       /oradata/arch

Oldest online log sequence     127

Next log sequence to archive   129

Current log sequence       129

SQL> shutdown immediate;
Database closed.

Database dismounted.
ORACLE instance shut down.

[oracle@node3 arch]$ ls -ltr

total 67132

-rw-r----- 1 oracle dba 50049536 Apr 24 20:24 1_119_906682003.dbf