archived log for thread 1 with sequence 17 is already on disk as file /dsk4/arch1/arch_1_17_851265252.log
archived log for thread 1 with sequence 18 is already on disk as file /dsk4/arch1/arch_1_18_851265252.log
archived log for thread 1 with sequence 19 is already on disk as file /dsk4/arch1/arch_1_19_851265252.log
archived log file name=/dsk4/arch1/arch_1_17_851265252.log thread=1 sequence=17
media recovery complete, elapsed time: 00:00:09
Finished recover at 15-JUL-14
database opened
3、验证
[oracle@rh6 ~]$ sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jul 15 17:26:10 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
17:26:10 SYS@ prod>select count(*) from scott.emp1;
COUNT(*)
----------
28
Elapsed: 00:00:00.03
17:27:09 SYS@ prod>
数据被恢复！
5、查看Incarnation
RMAN> list incarnation;
using target database control file instead of recovery catalog
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 PROD 239333010 PARENT 1 15-AUG-09
2 2 PROD 239333010 PARENT 945184 30-SEP-13
3 3 PROD 239333010 PARENT 1087512 18-MAY-14
4 4 PROD 239333010 PARENT 1857377 26-JUN-14
5 5 PROD 239333010 CURRENT 2123791 15-JUL-14
RMAN>
RMAN> list backup of database;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17 Full 1.13G DISK 00:01:21 03-JUL-14
BP Key: 17 Status: AVAILABLE Compressed: NO Tag: TAG20140703T171545
Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/0lpcfu61_1_1
List of Datafiles in backup set 17
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/system01.dbf
2 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/sysaux01.dbf
3 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/undotbs1.dbf
4 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/users01.dbf
5 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/example01.dbf
6 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/tbs1.dbf
7 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/undotbs2.dbf
8 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/perftbs01.dbf
案例2：（不完全恢复2）
1、table被误删除，通过不完全恢复进行恢复
17:42:24 SYS@ prod>conn scott/tiger
Connected.
17:42:28 SCOTT@ prod>insert into emp1 select * from emp where rownum <4;
3 rows created.
Elapsed: 00:00:00.05
17:42:42 SCOTT@ prod>commit;
Commit complete.
Elapsed: 00:00:00.01
17:42:44 SCOTT@ prod>insert into emp1 select * from emp where rownum <5;
4 rows created.
Elapsed: 00:00:00.02
17:42:52 SCOTT@ prod>commit;
Commit complete.
Elapsed: 00:00:00.05
17:42:55 SCOTT@ prod>conn /as sysdba
Connected.
17:43:01 SYS@ prod>select current_scn from v$database;
CURRENT_SCN
-----------
2124840
17:43:13 SYS@ prod>alter system switch logfile;
System altered.
Elapsed: 00:00:00.10
17:43:38 SYS@ prod>conn scott/tiger
Connected.
17:43:42 SCOTT@ prod>select count(*) from scott.emp1;
COUNT(*