[Oracle]System 表空间的文件丢失
如果system 表空间的文件丢失,假设有备份的情况,可以恢复。数据库需要设置为mount 状态,然后restore/recover datafile
模拟实验:
SQL> select name from v $ datafile;
NAME
-------------------------------------------------------------------- ------------------------------
/u01/app/oracle/oradata/ORA11204/datafile/o1_mf_system_9grvc6rn_.dbf
/u01/app/oracle/oradata/ORA11204/datafile/o1_mf_sysaux_9grvc6st_.dbf
/u01/app/oracle/oradata/ORA11204/datafile/o1_mf_undotbs1_9grvc6t7_.dbf
/u01/app/oracle/oradata/ORA11204/datafile/o1_mf_users_9grvc6tr_.dbf
/u01/app/oracle/oradata/ORA11204/datafile/o1_mf_example_9grvht2m_.dbf
/home/oracle/data5.dbf
6 rows were selected.
[oracle @ db 11204 ~] $ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Friday September 22 10:51:37 2017
Copyright (c) 1982, 2011, Oracle and / or its affiliates. All rights reserved.
Target database: Connected to ORA 11204 (database ID = 1382856929)
RMAN> backup database plus archivelog;
SQL> shu immediate
$ mv /u01/app/oracle/oradata/ORA11204/datafile/o1_mf_system_9grvc6rn_.dbf /u01/app/oracle/oradata/ORA11204/datafile/o1_mf_system_9grvc6rn_.dbf.bak
SQL> startup mount
[oracle @ db 11204 ~] $ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Friday September 22 11: 00: 16 2017
Copyright (c) 1982, 2011, Oracle and / or its affiliates. All rights reserved.
Target · Database: Connected to ORA 11204 (DBID = 1382856929, not open)
RMAN> restore datafile 1;
restore started (start time: 17-09-22)
I use the target database control file instead of the recovery catalog
Channel: ORA_DISK_1 assigned
Channel ORA_DISK_1: SID = 10 Device Type = DISK
Channel ORA_DISK_1: Restoring the data file · backup set is starting
Channel ORA_DISK_1: specifies the data file to be restored from the backup set
Channel ORA_DISK_1: Restores data file 00001 to /u01/app/oracle/oradata/ORA11204/datafile/o1_mf_system_9grvc6rn_.dbf
Channel ORA_DISK_1: Backup piece / u01 / app / oracle / fast_recovery_area / ORA11204 / backupset / 2017_09_22 / o1_mf_nnndf_TAG20170922T105151_dw8v5rbq_.bkp
Channel ORA_DISK_ 1: Piece handle = / u 01 / app / oracle / fast_recovery_area / ORA 11204 / backupset / 2017 _ 09 _ 22 / o 1 _ mf _ nnndf _ TAG 20170922 T 105151 _ dw 8 v 5 rbq _. Bkp tag = TAG 20170922 T 105151
Channel ORA_DISK_1: Backup piece 1 has been restored
Channel ORA_DISK_1: Restore complete. Elapsed time: 00: 01: 35
restore completed (completion time: 17-09-22)
RMAN>
RMAN> recover datafile 1;
recover started (start time: 17-09-22)
Use of channel ORA_DISK_1
Media recovery is starting
Media recovery is completed. Elapsed time: 00: 00: 01
recover completed (completion time: 17-09-22)
RMAN> exit
Recovery Manager has completed.
[oracle @ db 11204 ~] $
相关文章
- oracle数据库外连接
- C#实现多级子目录Zip压缩解压实例 NET4.6下的UTC时间转换 [译]ASP.NET Core Web API 中使用Oracle数据库和Dapper看这篇就够了 asp.Net Core免费开源分布式异常日志收集框架Exceptionless安装配置以及简单使用图文教程 asp.net core异步进行新增操作并且需要判断某些字段是否重复的三种解决方案 .NET Core开发日志
- Oracle数据库:oracle数据表格dmp,sql,pde格式导入与导出,视图、序列、索引等对象的导出,oracle完结,后续开启mysql的学习
- Oracle数据库:创建和删除视图view,简单和复杂视图,内建视图,topN分析,oracle分页查询
- Oracle数据库:oracle数据定义语言DDL,查询表、序列、索引、视图、创建表,修改表的列alter,rename to,删除表数据truncate和表drop
- Oracle数据库:条件表达式case when then else end,decode函数,oracle单行函数练习示例
- Oracle数据库:oracle函数,单行函数,多行函数,upper,lower,initcap,字符串函数
- oracle 中控制文件中到底记录了哪些信息
- 清理Oracle安装目录里的一些日志信息
- [Oracle 工程师手记]遇到 ORA-600[4194] 错误的应对措施
- 如何取得Oracle并行执行的trace
- Oracle的sqlnet.ora与password文件试验
- 学习笔记:Oracle的trace文件可见性
- 【从翻译mos文章】在oracle db 11gR2版本号被启用 Oracle NUMA 支持
- Oracle 基础系列之1.1 oracle的安装
- Oracle 未能加载文件或程序集Oracle.DataAccess
- Oracle 开设以色列加速器,专注云端技术新创公司孵化
- Oracle-表空间管理
- Oracle-触发器和程序包