【只读表空间–恢复-1】

1只读 —备份只读 故障 只读 还原有故障的数据文件 2只读 —备份只读 可写 故障 还原备份数据文件，重做recover 3只读 —备份可写 只读 故障 还原备份数据文件，recover 1 进入rman，确保是否有备份的文件： [oracle@oracle ~]$ rman target /Recovery Man

1>只读 —备份只读 故障 只读 还原有故障的数据文件
2>只读 —备份只读 可写 故障 还原备份数据文件，重做recover
3>只读 —备份可写 只读 故障 还原备份数据文件，recover
1>
进入rman，确保是否有备份的文件：

[oracle@oracle ~]$ rman target /Recovery Manager: Release 10.2.0.5.0 - Production on Thu Nov 6 09:44:08 2014Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: JADL10G (DBID=2011508104)RMAN> list backup of tablespace users;using target database control file instead of recovery catalogList of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------1 Full 609.23M DISK 00:00:38 06-NOV-14BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20141106T063059Piece Name: /u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_nnndf_TAG20141106T063059_b5o994hx_.bkpList of Datafiles in backup set 1File LV Type Ckp SCN Ckp Time Name---- -- ---- ---------- --------- ----4 Full 422818 06-NOV-14 /u01/oracle/oradata/jadl10g/users01.dbf

修改表空间为只读表空间：

[oracle@oracle ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Thu Nov 6 09:45:35 2014Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engineand Real Application Testing optionsSQL> alter tablespace users read only;Tablespace altered.

进入rman，重新备份数据库，删除以前备份的可以节省空间使用delete backup命令可以删除；

[oracle@oracle ~]$ rman target /Recovery Manager: Release 10.2.0.5.0 - Production on Thu Nov 6 09:50:29 2014Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: JADL10G (DBID=2011508104)RMAN> backup database; --备份数据库Starting backup at 06-NOV-14using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=159 devtype=DISKchannel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00001 name=/u01/oracle/oradata/jadl10g/system01.dbfinput datafile fno=00003 name=/u01/oracle/oradata/jadl10g/sysaux01.dbfinput datafile fno=00005 name=/u01/oracle/oradata/jadl10g/example01.dbfinput datafile fno=00002 name=/u01/oracle/oradata/jadl10g/undotbs01.dbfinput datafile fno=00004 name=/u01/oracle/oradata/jadl10g/users01.dbfchannel ORA_DISK_1: starting piece 1 at 06-NOV-14channel ORA_DISK_1: finished piece 1 at 06-NOV-14piece handle=/u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_nnndf_TAG20141106T095036_b5onzdz1_.bkp tag=TAG20141106T095036 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:55channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetincluding current control file in backupsetincluding current SPFILE in backupsetchannel ORA_DISK_1: starting piece 1 at 06-NOV-14channel ORA_DISK_1: finished piece 1 at 06-NOV-14piece handle=/u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_ncsnf_TAG20141106T095036_b5oo15kf_.bkp tag=TAG20141106T095036 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02Finished backup at 06-NOV-14RMAN> exitRecovery Manager complete.

删除users表空间(只读的文件)
[oracle@oracle ~]$ rm /u01/oracle/oradata/jadl10g/users01.dbf
连接到DB，执行查询发现报错：

[oracle@oracle ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Thu Nov 6 09:52:33 2014Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engineand Real Application Testing optionsSQL> select * from scott.dept;select * from scott.dept*ERROR at line 1:ORA-01116: error in opening database file 4ORA-01110: data file 4: '/u01/oracle/oradata/jadl10g/users01.dbf'ORA-27041: unable to open fileLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3SQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engineand Real Application Testing options

连接到rman：

[oracle@oracle ~]$ rman target /Recovery Manager: Release 10.2.0.5.0 - Production on Thu Nov 6 09:53:40 2014Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: JADL10G (DBID=2011508104)RMAN> sql 'alter database datafile 4 offline '; --数据文件脱机using target database control file instead of recovery catalogsql statement: alter database datafile 4 offlineRMAN> restore datafile 4; --恢复数据文件，此处可以是文件的路径 restore datafile '/u01/oracle/oradata/jadl10g/users01.dbf';Starting restore at 06-NOV-14allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=136 devtype=DISKchannel ORA_DISK_1: starting datafile backupset restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setrestoring datafile 00004 to /u01/oracle/oradata/jadl10g/users01.dbfchannel ORA_DISK_1: reading from backup piece /u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_nnndf_TAG20141106T095036_b5onzdz1_.bkpchannel ORA_DISK_1: restored backup piece 1piece handle=/u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_nnndf_TAG20141106T095036_b5onzdz1_.bkp tag=TAG20141106T095036channel ORA_DISK_1: restore complete, elapsed time: 00:00:02Finished restore at 06-NOV-14RMAN> sql 'alter database datafile 4 online '; ---连接数据文件sql statement: alter database datafile 4 onlineRMAN> exitRecovery Manager complete.

连接到DB，执行查询发现可以查询到结果：

[oracle@oracle ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Thu Nov 6 09:55:00 2014Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engineand Real Application Testing optionsSQL> select * from scott.dept;DEPTNO DNAME LOC---------- -------------- -------------10 ACCOUNTING NEW YORK20 RESEARCH DALLAS30 SALES CHICAGO40 OPERATIONS BOSTON2>

连接DB，修改表空间为可写：

[oracle@oracle ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Thu Nov 6 10:04:27 2014Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Editio【本文来自鸿网互联 (http://www.68idc.cn)】n Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engineand Real Application Testing optionsSQL> alter tablespace users read write;Tablespace altered.SQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engineand Real Application Testing options

删除users表空间(可写的表空间)：
[oracle@oracle ~]$ rm /u01/oracle/oradata/jadl10g/users01.dbf
连接到DB，执行查询发现报错：

[oracle@oracle ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Thu Nov 6 10:05:32 2014Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engineand Real Application Testing optionsSQL> select * from scott.dept;select * from scott.dept*ERROR at line 1:ORA-01116: error in opening database file 4ORA-01110: data file 4: '/u01/oracle/oradata/jadl10g/users01.dbf'ORA-27041: unable to open fileLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3SQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engineand Real Application Testing options

连接到rman：

[oracle@oracle ~]$ rman target /Recovery Manager: Release 10.2.0.5.0 - Production on Thu Nov 6 10:06:31 2014Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: JADL10G (DBID=2011508104)RMAN> sql 'alter database datafile 4 offline ';using target database control file instead of recovery catalogsql statement: alter database datafile 4 offlineRMAN> restore datafile 4;Starting restore at 06-NOV-14allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=159 devtype=DISKchannel ORA_DISK_1: starting datafil<div style="color:transparent">本文来源gaodai.ma#com搞##代!^码网(</div>e backupset restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setrestoring datafile 00004 to /u01/oracle/oradata/jadl10g/users01.dbfchannel ORA_DISK_1: reading from backup piece /u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_nnndf_TAG20141106T095036_b5onzdz1_.bkpchannel ORA_DISK_1: restored backup piece 1piece handle=/u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_nnndf_TAG20141106T095036_b5onzdz1_.bkp tag=TAG20141106T095036channel ORA_DISK_1: restore complete, elapsed time: 00:00:01Finished restore at 06-NOV-14RMAN> recover datafile 4;Starting recover at 06-NOV-14using channel ORA_DISK_1starting media recoverymedia recovery complete, elapsed time: 00:00:03Finished recover at 06-NOV-14RMAN> sql 'alter database datafile 4 online ';sql statement: alter database datafile 4 onlineRMAN> exitRecovery Manager complete.

连接到DB，执行查询发现可以查询到结果：

[oracle@oracle ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Thu Nov 6 10:08:18 2014Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engineand Real Application Testing optionsSQL> select * from scott.dept;DEPTNO DNAME LOC---------- -------------- -------------10 ACCOUNTING NEW YORK20 RESEARCH DALLAS30 SALES CHICAGO40 OPERATIONS BOSTON

喜欢 (0)赏

[搞代码]

分享 (0)