1_17/o1_mf_nnndf_TAG20140117T094447_9fk2rhv7_.bkp tag=TAG20140117T094447
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:04:16
Finished restore at 17-JAN-14
Starting recover at 17-JAN-14
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 17-JAN-14
RMAN> **end-of-file**
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;
四 相关文章
RMAN备份与恢复之控制文件丢失RMAN备份与恢复之可脱机数据文件丢失RMAN备份与恢复之UNDO表空间丢失