探索Oracle之RMAN_07 system表空间丢失恢复

1、 SYSTEM表空间数据文件丢失恢复注意：以下的所有实验，都是基于上面的全库备份来做的恢复。3.1 删除system表空间的所有数据文件。[Oracle@wwldb WWL]$ rm -rf syste*[oracle@wwldb WWL]$ exit 3.2 再次启动数据库报错。SQL> startup forceORACLE instance started. Total System GlobalArea 285212672 bytesFixed Size 1218968 bytesVariable Size 104859240 bytesDatabase Buffers 171966464 bytesRedo Buffers 7168000 bytesDatabase mounted.ORA-01157: cannotidentify/lock data file 1 - see DBWR trace fileORA-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=ORALinux Error: 2: No such file or directoryAdditional information: 3ORA-1157 signalled during: ALTER DATABASE OPEN... 由如上日志文件我们得出是由于/DBData/WWL/system01.dbf文件丢失，而且这个文件同时又是system表空间的的数据文件，因为system表空间存放了数据字典信息，所以该数据文件是不可以采用脱机的方式实现在线的的恢复。 3.4恢复system表空间数据文件开始执行恢复分为五个步骤1、强制启动数据库到mount状态SQL> startup force mount;ORACLE instance started. Total System Global Area 285212672 bytesFixed Size 1218968 bytesVariable Size 104859240 bytesDatabase Buffers 171966464 bytesRedo Buffers 7168000 bytesDatabase mounted.SQL> 2、Restore出来system表空间的数据文件RMAN> restore datafile 1; Starting restore at 22-JUN-12using target database control file instead of recoverycatalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=156 devtype=DISK channel ORA_DISK_1: starting datafile backupsetrestorechannel ORA_DISK_1: specifying datafile（s） to restorefrom backup setrestoring datafile 00001 to /DBData/WWL/system01.dbfchannel ORA_DISK_1: reading from backup piece/DBBak/bak_WWL_06_22_0vne4ph6_1_1channel ORA_DISK_1: restored backup piece 1piece handle=/DBBak/bak_WWL_06_22_0vne4ph6_1_1tag=TAG20120622T010021channel ORA_DISK_1: restore complete, elapsed time:00:01:06Finished restore at 22-JUN-12 3、执行system表空间数据恢复。RMAN> recover datafile 1;Starting recover at 22-JUN-12using channel ORA_DISK_1starting media recoveryarchive log thread 1 sequence 20 is already on diskas file/DBData/flash_recovery_area/WWL/archivelog/2012_06_22/o1_mf_1_20_7y804kwr_.arcarchive log thread 1 sequence 21 is already on diskas file/DBData/flash_recovery_area/WWL/archivelog/2012_06_22/o1_mf_1_21_7y80zjqx_.arcarchive log thread 1 sequence 22 is already on diskas file /DBData/flash_recovery_area/WWL/archivelog/2012_06_22/o1_mf_1_22_7y8y7l70_.arcarchive log thread 1 sequence 23 is already on diskas file/DBData/flash_recovery_area/WWL/archivelog/2012_06_22/o1_mf_1_23_7y903v17_.arcarchive logfilename=/DBData/flash_recovery_area/WWL/archivelog/2012_06_22/o1_mf_1_20_7y804kwr_.arcthread=1 sequence=20archive logfilename=/DBData/flash_recovery_area/WWL/archivelog/2012_06_22/o1_mf_1_21_7y80zjqx_.arcthread=1 sequence=21media recovery complete, elapsed time: 00:00:02Finished recover at 22-JUN-12 4、Open数据库SQL> alter database open;Database altered. SQL> select instance_name,status from v$instance;INSTANCE_NAME STATUS---------------- ------------WWL OPEN SQL>相关阅读：探索Oracle之RMAN_01概念 http://www.linuxidc.com/Linux/2012-05/60530.htm探索Oracle之RMAN_02基本使用 http://www.linuxidc.com/Linux/2012-05/60578.htm探索Oracle之RMAN_03非一致性备份 http://www.linuxidc.com/Linux/2012-05/61025.htm探索Oracle之RMAN_04非一致性备份 http://www.linuxidc.com/Linux/2012-05/61180.htm探索Oracle之RMAN_05增量备份 http://www.linuxidc.com/Linux/2012-05/61181.htm探索Oracle之RMAN_06备份策略 http://www.linuxidc.com/Linux/2012-05/61450.htm探索Oracle之RMAN_07单个数据文件丢失恢复 http://www.linuxidc.com/Linux/2012-06/63524.htm探索Oracle之RMAN_07整个业务表空间丢失恢复 http://www.linuxidc.com/Linux/2012-07/64582.htm探索Oracle之RMAN_07 磁盘损坏数据丢失恢复 http://www.linuxidc.com/Linux/2012-07/64588.htm探索Oracle之RMAN_07 数据库所有文件全部丢失恢复 http://www.linuxidc.com/Linux/2012-07/64587.htm探索Oracle之RMAN_07 重做日志redu文件丢失恢复 http://www.linuxidc.com/Linux/2012-07/64586.htm探索Oracle之RMAN_07 参数文件丢失恢复 http://www.linuxidc.com/Linux/2012-07/64585.htm探索Oracle之RMAN_07控制文件丢失恢复 http://www.linuxidc.com/Linux/2012-07/64584.htm探索Oracle之RMAN_07 system表空间丢失恢复 http://www.linuxidc.com/Linux/2012-07/64583.htm探索Oracle之RMAN_07整个业务表空间丢失恢复探索Oracle之RMAN_07控制文件丢失恢复相关资讯 Oracle高级培训

delete表的数据后恢复（08/30/2012 08:59:58）
使用ASH信息，发现高CPUsession （08/14/2012 07:21:32）
如何阅读Oracle Errorstack Output （08/14/2012 07:15:47）

Oracle Apps Patching:adpatch（（08/16/2012 15:41:37）
话说V$SQL_MONITOR （08/14/2012 07:19:54）
Oracle Apps DBA工具:ADADMIN使用（08/14/2012 07:00:09）

本文评论查看全部评论（0）