数据库|mysql教程
Oracle高级培训,探索Oracle之RMAN_07 sy
数据库-mysql教程
手游捕鱼源码,怎么更改vscode浏览器,配网关ubuntu,linux怎么进tomcat,cookies反爬虫,会php如何创业,深圳长沙seo优化哪家专业lzw
探索Oracle之RMAN_07 system表空间丢失恢复
易语言cookie提交源码,vscode 备注,ubuntu 多余内核,tomcat_,sqlite聚簇,服务器受到攻击怎么办,wp垃圾评论插件,阿里前端app框架,qq 爬虫,php图片站,seo窍门,c 开源网站,php聊天室网页代码,dz木泉网模板,js 页面弹出框,java web 图书管理系统,delphi 自动更新程序lzw
集团公司网站源码,vscode左边文件夹展示,ubuntu 扩展空间,tomcat 监控运维,sqlite连接远程,微信端网页设计,阿里云服务器多久重启一次,anglejs插件,平安前端框架,爬虫的梗,php 获取当前路径,出口产品怎么做seo,springboot登录页接口,大型赌博网站源码,网页代码隐藏,啦啦外卖 微站模板,dede后台一直提示验证码错,视频播放器页面,java在线考试管理系统,微信小程序签到源代码lzw
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 Buffers171966464 bytes
Redo Buffers7168000 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 Buffers171966464 bytes
Redo Buffers7168000 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=TAG0622T010021
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/_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/_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/_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/_06_22/o1_mf_1_23_7y903v17_.arc
archive logfilename=/DBData/flash_recovery_area/WWL/archivelog/_06_22/o1_mf_1_20_7y804kwr_.arcthread=1 sequence=20
archive logfilename=/DBData/flash_recovery_area/WWL/archivelog/_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表空间丢失恢复
如果觉得《探索Oracle之RMAN_07 system表空间丢失恢复》对你有帮助,请点赞、收藏,并留下你的观点哦!