[Oracle]System 表空间的文件丢失-阿里云开发者社区

开发者社区> 数据库> 正文
登录阅读全文

[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 ~] $









本文转自健哥的数据花园博客园博客,原文链接:http://www.cnblogs.com/gaojian/p/7573468.html,如需转载请自行联系原作者

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

分享:
数据库
使用钉钉扫一扫加入圈子
+ 订阅

分享数据库前沿,解构实战干货,推动数据库技术变革

其他文章
最新文章
相关文章