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