Step 11，RMAN中使用RESETLOGS打开数据库
RMAN> ALTER DATABASE OPEN RESETLOGS; database opened
Step 12，SQL Plus中查看数据，如果能够正确地查看到，证明恢复成功
[oracle@orcl ~]$ sqlplus [uniread] Loaded history (66 lines) SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 17 10:10:53 2014 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and Real Application Testing options SQL> SELECT open_mode FROM v$database; OPEN_MODE -------------------- READ WRITE #这正是被删除掉的表中的数据 SQL> SELECT * FROM scott.test; ID NAME ---------- -------------------- 1 justdb
Step 13，因为重置了日志，我们需要重新在RMAN中备份
[oracle@orcl ~]$ uniread rman target / [uniread] Loaded history (2 lines) Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jan 17 09:44:40 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: LARRRDB (DBID=3428598070) RMAN> BACKUP DATABASE;