oracle missing00007,探索Oracle之RMAN_07整个业务表空间丢失恢复

2.5恢复方法二，离线恢复

开始执行恢复操作，分为五个步骤：

1、强制将数据库启动到mount状态

SQL> startupforce mount;

Oracle instancestarted.

Total SystemGlobal Area  285212672 bytes

Fixed Size                  1218968 bytes

Variable Size             104859240 bytes

DatabaseBuffers          171966464 bytes

Redo Buffers                7168000 bytes

Database mounted.

2、将wwl表空间的所有数据文件从备份中restore出来

RMAN> restoretablespace wwl;

Starting restoreat 22-JUN-12

using targetdatabase control file instead of recovery catalog

allocated channel:ORA_DISK_1

channelORA_DISK_1: sid=156 devtype=DISK

channelORA_DISK_1: starting datafile backupset restore

channelORA_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile00005 to /DBData/WWL/wwl001.dbf

restoring datafile00006 to /DBData/WWL/wwl002.dbf

restoring datafile00007 to /DBData/WWL/wwl003.dbf

channelORA_DISK_1: reading from backup piece /DBBak/bak_WWL_06_22_0vne4ph6_1_1

channelORA_DISK_1: restored backup piece 1

piecehandle=/DBBak/bak_WWL_06_22_0vne4ph6_1_1 tag=TAG20120622T010021

channelORA_DISK_1: restore complete, elapsed time: 00:00:07

Finished restore at 22-JUN-12

3、执行表空间的所有数据恢复，保证scn一致

RMAN> recovertablespace wwl;

Starting recoverat 22-JUN-12

using channelORA_DISK_1

starting mediarecovery

archive log thread1 sequence 20 is already on disk as file/DBData/flash_recovery_area/WWL/archivelog/2012_06_22/o1_mf_1_20_7y804kwr_.arc

archive log thread1 sequence 21 is already on disk as file/DBData/flash_recovery_area/WWL/archivelog/2012_06_22/o1_mf_1_21_7y80zjqx_.arc

archive log thread1 sequence 22 is already on disk as file/DBData/flash_recovery_area/WWL/archivelog/2012_06_22/o1_mf_1_22_7y8y7l70_.arc

archive logfilename=/DBData/flash_recovery_area/WWL/archivelog/2012_06_22/o1_mf_1_20_7y804kwr_.arcthread=1 sequence=20

media recoverycomplete, elapsed time: 00:00:02

Finished recover at 22-JUN-12

4、打开数据库

SQL> alter database open;

Database altered.

5、验证表空间数据是否都恢复回来了。

SQL>conn wwl/wwl

Connected.

SQL>select count(*) from tab;

COUNT(*)

----------

5

SQL>select * from wwl05;

ID NAME

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

1 wwl

2 wm

3 zq

4 wbq

5 wq