探索oracle之rman_07 system表空间丢失恢复
1、     system表空间数据文件丢失恢复
注意：以下的所有实验，都是基于上面的全库备份来做的恢复。
3.1 删除system表空间的所有数据文件。
[oracle@wwldb wwl]$ rm -rf syste*
[oracle@wwldb wwl]$ exit
3.2 再次启动数据库报错。
sql> startup force
oracle instance started.
total system globalarea  285212672 bytes
fixed size                  1218968 bytes
variable size             104859240 bytes
database buffers          171966464 bytes
redo buffers                7168000 bytes
database mounted.
ora-01157: cannotidentify/lock data file 1 - see dbwr trace file
ora-01110: data file 1:'/dbdata/wwl/system01.dbf'
3.3 检查跟踪文件，，分析错误。
errors in file /dbsoft/admin/wwl/bdump/wwl_dbw0_4600.trc:
ora-01157: message 1157 not found; no message file for product=rdbms,facility=ora; arguments: [1]
ora-01110: message 1110 not found; no message file for product=rdbms,facility=ora; arguments: [1] [/dbdata/wwl/system01.dbf]
ora-27037: message 27037 not found; no message file for product=rdbms,facility=ora
linux error: 2: no such file or directory
additional information: 3
ora-1157 signalled during: alter database open...
由如上日志文件我们得出是由于/dbdata/wwl/system01.dbf文件丢失，而且这个文件同时又是system表空间的的数据文件，因为system表空间存放了数据字典信息，所以该数据文件是不可以采用脱机的方式实现在线的的恢复。
3.4恢复system表空间数据文件
开始执行恢复分为五个步骤
状态
sql> startup force mount;
oracle instance started.
total system global area  285212672 bytes
fixed size                  1218968 bytes
variable size             104859240 bytes
database buffers          171966464 bytes
redo buffers                7168000 bytes
database mounted.
sql>
表空间的数据文件
rman> restore datafile 1;
starting restore at 22-jun-12
using target database control file instead of recoverycatalog
allocated channel: ora_disk_1
channel ora_disk_1: sid=156 devtype=disk
channel ora_disk_1: starting datafile backupsetrestore
channel ora_disk_1: specifying datafile(s) to restorefrom backup set
restoring datafile 00001 to /dbdata/wwl/system01.dbf
channel ora_disk_1: reading from backup piece/dbbak/bak_wwl_06_22_0vne4ph6_1_1
channel ora_disk_1: restored backup piece 1
piece handle=/dbbak/bak_wwl_06_22_0vne4ph6_1_1tag=tag20120622t010021
channel ora_disk_1: restore complete, elapsed time:00:01:06
finished restore at 22-jun-12
表空间数据恢复。
rman> recover datafile 1;
starting recover at 22-jun-12
using channel ora_disk_1
starting media recovery
archive log thread 1 sequence 20 is already on diskas file/dbdata/flash_recovery_area/wwl/archivelog/2012_06_22/o1_mf_1_20_7y804kwr_.arc
archive log thread 1 sequence 21 is already on diskas file/dbdata/flash_recovery_area/wwl/archivelog/2012_06_22/o1_mf_1_21_7y80zjqx_.arc
archive log thread 1 sequence 22 is already on diskas file /dbdata/flash_recovery_area/wwl/archivelog/2012_06_22/o1_mf_1_22_7y8y7l70_.arc
archive log thread 1 sequence 23 is already on diskas file/dbdata/flash_recovery_area/wwl/archivelog/2012_06_22/o1_mf_1_23_7y903v17_.arc
archive logfilename=/dbdata/flash_recovery_area/wwl/archivelog/2012_06_22/o1_mf_1_20_7y804kwr_.arcthread=1 sequence=20
archive logfilename=/dbdata/flash_recovery_area/wwl/archivelog/2012_06_22/o1_mf_1_21_7y80zjqx_.arcthread=1 sequence=21
media recovery complete, elapsed time: 00:00:02
finished recover at 22-jun-12
sql> alter database open;
database altered.
sql> select instance_name,status from v$instance;
instance_name   status
---------------- ------------
wwl             open
sql>
相关阅读：
探索oracle之rman_01概念
探索oracle之rman_02基本使用
探索oracle之rman_03非一致性备份
探索oracle之rman_04非一致性备份
探索oracle之rman_05增量备份
探索oracle之rman_06备份策略
探索oracle之rman_07单个数据文件丢失恢复
探索oracle之rman_07整个业务表空间丢失恢复
探索oracle之rman_07 磁盘损坏数据丢失恢复
探索oracle之rman_07 数据库所有文件全部丢失恢复
探索oracle之rman_07 重做日志redu文件丢失恢复
探索oracle之rman_07 参数文件丢失恢复
探索oracle之rman_07控制文件丢失恢复
探索oracle之rman_07 system表空间丢失恢复