【只读表空间--恢复-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 2014 Copyright (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 catalog List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 1 Full 609.23M DISK 00:00:38 06-NOV-14 BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20141106T063059 Piece Name: /u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_nnndf_TAG20141106T063059_b5o994hx_.bkp List of Datafiles in backup set 1 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 4 Full 422818 06-NOV-14 /u01/oracle/oradata/jadl10g/users01.dbf
登录后复制
修改表空间为只读表空间：
[oracle@oracle ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Thu Nov 6 09:45:35 2014 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine and Real Application Testing options SQL> 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 2014 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: JADL10G (DBID=2011508104) RMAN> backup database; --备份数据库 Starting backup at 06-NOV-14 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=159 devtype=DISK channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00001 name=/u01/oracle/oradata/jadl10g/system01.dbf input datafile fno=00003 name=/u01/oracle/oradata/jadl10g/sysaux01.dbf input datafile fno=00005 name=/u01/oracle/oradata/jadl10g/example01.dbf input datafile fno=00002 name=/u01/oracle/oradata/jadl10g/undotbs01.dbf input datafile fno=00004 name=/u01/oracle/oradata/jadl10g/users01.dbf channel ORA_DISK_1: starting piece 1 at 06-NOV-14 channel ORA_DISK_1: finished piece 1 at 06-NOV-14 piece handle=/u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_nnndf_TAG20141106T095036_b5onzdz1_.bkp tag=TAG20141106T095036 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset including current control file in backupset including current SPFILE in backupset channel ORA_DISK_1: starting piece 1 at 06-NOV-14 channel ORA_DISK_1: finished piece 1 at 06-NOV-14 piece handle=/u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_ncsnf_TAG20141106T095036_b5oo15kf_.bkp tag=TAG20141106T095036 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 Finished backup at 06-NOV-14 RMAN> exit Recovery Manager complete.
登录后复制
删除users表空间(只读的文件)
[oracle@oracle ~]$ rm /u01/oracle/oradata/jadl10g/users01.dbf
连接到DB，执行查询发现报错：
[oracle@oracle ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Thu Nov 6 09:52:33 2014 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine and Real Application Testing options SQL> select * from scott.dept; select * from scott.dept * ERROR at line 1: ORA-01116: error in opening database file 4 ORA-01110: data file 4: '/u01/oracle/oradata/jadl10g/users01.dbf' ORA-27041: unable to open file Linux-x86_64 Error: 2: No such file or directory Additional information: 3 SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine and 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 2014 Copyright (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 catalog sql statement: alter database datafile 4 offline RMAN> restore datafile 4; --恢复数据文件，此处可以是文件的路径 restore datafile '/u01/oracle/oradata/jadl10g/users01.dbf'; Starting restore at 06-NOV-14 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=136 devtype=DISK channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00004 to /u01/oracle/oradata/jadl10g/users01.dbf channel ORA_DISK_1: reading from backup piece /u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_nnndf_TAG20141106T095036_b5onzdz1_.bkp channel ORA_DISK_1: restored backup piece 1 piece handle=/u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_nnndf_TAG20141106T095036_b5onzdz1_.bkp tag=TAG20141106T095036 channel ORA_DISK_1: restore complete, elapsed time: 00:00:02 Finished restore at 06-NOV-14 RMAN> sql 'alter database datafile 4 online '; ---连接数据文件 sql statement: alter database datafile 4 online RMAN> exit Recovery Manager complete.
登录后复制
连接到DB，执行查询发现可以查询到结果：
[oracle@oracle ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Thu Nov 6 09:55:00 2014 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine and Real Application Testing options SQL> select * from scott.dept; DEPTNO DNAME LOC ---------- -------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON 2>
登录后复制
连接DB，修改表空间为可写：
[oracle@oracle ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Thu Nov 6 10:04:27 2014 Copyright (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 Production With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine and Real Application Testing options SQL> alter tablespace users read write; Tablespace altered. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine and Real Application Testing options
登录后复制
删除users表空间(可写的表空间)：
[oracle@oracle ~]$ rm /u01/oracle/oradata/jadl10g/users01.dbf
连接到DB，执行查询发现报错：
[oracle@oracle ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Thu Nov 6 10:05:32 2014 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine and Real Application Testing options SQL> select * from scott.dept; select * from scott.dept * ERROR at line 1: ORA-01116: error in opening database file 4 ORA-01110: data file 4: '/u01/oracle/oradata/jadl10g/users01.dbf' ORA-27041: unable to open file Linux-x86_64 Error: 2: No such file or directory Additional information: 3 SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine and 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 2014 Copyright (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 catalog sql statement: alter database datafile 4 offline RMAN> restore datafile 4; Starting restore at 06-NOV-14 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=159 devtype=DISK channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00004 to /u01/oracle/oradata/jadl10g/users01.dbf channel ORA_DISK_1: reading from backup piece /u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_nnndf_TAG20141106T095036_b5onzdz1_.bkp channel ORA_DISK_1: restored backup piece 1 piece handle=/u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_nnndf_TAG20141106T095036_b5onzdz1_.bkp tag=TAG20141106T095036 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 Finished restore at 06-NOV-14 RMAN> recover datafile 4; Starting recover at 06-NOV-14 using channel ORA_DISK_1 starting media recovery media recovery complete, elapsed time: 00:00:03 Finished recover at 06-NOV-14 RMAN> sql 'alter database datafile 4 online '; sql statement: alter database datafile 4 online RMAN> exit Recovery Manager complete.
登录后复制
连接到DB，执行查询发现可以查询到结果：
[oracle@oracle ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Thu Nov 6 10:08:18 2014 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine and Real Application Testing options SQL> select * from scott.dept; DEPTNO DNAME LOC ---------- -------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON
登录后复制
本站声明
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn
热AI工具
Undresser.AI Undress
人工智能驱动的应用程序，用于创建逼真的裸体照片
AI Clothes Remover
用于从照片中去除衣服的在线人工智能工具。
Undress AI Tool
免费脱衣服图片
Clothoff.io
AI脱衣机
Video Face Swap
使用我们完全免费的人工智能换脸工具轻松在任何视频中换脸！
热门文章
如何修复KB5055612无法在Windows 10中安装？
4 周前
By DDD
<🎜>：种植花园 - 完整的突变指南
3 周前
By DDD
<🎜>：泡泡胶模拟器无穷大 - 如何获取和使用皇家钥匙
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
北端：融合系统，解释
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
Mandragora：巫婆树的耳语 - 如何解锁抓钩
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
热工具
记事本++7.3.1
好用且免费的代码编辑器
SublimeText3汉化版
中文版，非常好用
禅工作室 13.0.1
功能强大的PHP集成开发环境
Dreamweaver CS6
视觉化网页开发工具
SublimeText3 Mac版
神级代码编辑软件(SublimeText3)
抖音怎么恢复聊天火花
Mar 16, 2024 pm 01:25 PM
在抖音这个充满创意与活力的短视频平台上，我们不仅可以欣赏到各种精彩内容，还能与志同道合的朋友展开深入的交流。其中，聊天火花作为衡量双方互动热度的重要指标，常常在不经意间点燃我们与好友之间的情感纽带。然而，有时由于一些原因，聊天火花可能会断开，那么如果我们想要恢复聊天火花究竟该如何操作呢，这篇教程攻略就将为大家带来详细的内容攻略介绍，希望能帮助到大家。抖音聊天火花断了怎么恢复？1、打开抖音的消息页面，选择好友聊天。2、互发消息聊天。3、连续发消息3天，就可以获得火花标识。在3天基础上，互发图片或视
黑鲨手机无法开机怎么办？教你自救方法！
Mar 23, 2024 pm 04:06 PM
黑鲨手机无法开机怎么办？教你自救方法！在我们日常生活中，手机已经成为我们不可或缺的一部分。而对于很多人来说，黑鲨手机是一款备受喜爱的游戏手机。但是难免会遇到各种问题，其中之一就是手机无法开机。当你遇到这样的情况时，不要慌张，下面将为你介绍一些解决方法，希望能帮助到你。首先，当黑鲨手机无法开机时，首先要检查手机是否有足够的电量。可能是由于电量耗尽导致无法开机，
如何在 PHP 中使用 MySQL 备份和还原？
Jun 03, 2024 pm 12:19 PM
在PHP中备份和还原MySQL数据库可通过以下步骤实现：备份数据库：使用mysqldump命令转储数据库为SQL文件。还原数据库：使用mysql命令从SQL文件还原数据库。
如何安装、卸载、重置Windows服务器备份
Mar 06, 2024 am 10:37 AM
WindowsServerBackup是WindowsServer操作系统自带的一个功能，旨在帮助用户保护重要数据和系统配置，并为中小型和企业级企业提供完整的备份和恢复解决方案。只有运行Server2022及更高版本的用户才能使用这一功能。在本文中，我们将介绍如何安装、卸载或重置WindowsServerBackup。如何重置Windows服务器备份如果您的服务器备份遇到问题，备份所需时间过长，或无法访问已存储的文件，那么您可以考虑重新设置WindowsServer备份设置。要重置Windows
黑鲨手机充电故障排查与解决
Mar 22, 2024 pm 09:03 PM
黑鲨手机是一款以性能强悍、游戏体验出色而著称的智能手机品牌，备受广大游戏玩家和科技爱好者的喜爱。然而，就像其他智能手机一样，黑鲨手机也会出现各种问题，其中充电故障是比较常见的一种。充电故障不仅会影响手机的正常使用，还可能引发更严重的问题，因此及时解决充电问题十分重要。本文将从常见的黑鲨手机充电故障原因入手，介绍排查和解决充电问题的方法，希望能帮助读者解决黑鲨
emmo日记删除了如何恢复
Feb 27, 2024 pm 04:40 PM
Emmo日记是一款专为记录心情而设计的软件，它为你提供了一个私密的日记空间，让你能够记录下每天的重要或琐碎的事情。通过独特的情绪识别技术，Emmo日记还能帮助你更好地理解和处理自己的情绪。但是有的时候发现自己日记被误删了以后却不知道该如何恢复，那么这篇教程攻略就将为大家带来详细的恢复攻略介绍，希望能帮助到各位有需要的小伙伴们。emmo怎么找回之前的日记？1、在emmo选择屏幕左下角【设置】图标点击进入；2、选择屏幕【数据备份与恢复】图标，进入操作即可。
小红书被删除的评论怎么恢复？被删除的评论有提示吗？
Mar 27, 2024 am 11:56 AM
小红书作为一款流行的社交电商平台，用户可以在这里分享购物心得、生活点滴等。在使用过程中，有些用户可能会遇到自己发布的评论被删除的情况。那么，小红书被删除的评论怎么恢复呢？一、小红书被删除的评论怎么恢复？如果发现评论被误删，用户可以选择静待小红书官方团队进行恢复。在这种情况下，最好保持耐心等待，因为官方团队可能会在一段时间后自动处理并恢复评论。如果您发现评论被删除，可以考虑重新发布类似内容。但在重新发布时，请确保内容符合小红书的社区准则，以免再次遭到删除。3.联系小红书客服：如果认为自己的评论被误
ghost怎么备份系统-ghost备份教程
Mar 06, 2024 pm 04:30 PM
近期有很多小伙伴咨询小编ghost怎么备份系统，接下来就让我们一起学习一下ghost备份系统的方法教程，希望可以帮助到大家。1、运行Ghost后，单击“OK”，如图所示。2、依次单击“Local”→“Partition”→“ToImage”(意为：本地→分区→到镜像文件)，如图所示。3、出现选择本地硬盘窗口，单击要备份的分区所在硬盘，再单击“OK”，如图所示。4、出现选择源分区窗口(源分区就是你要备份的那个分区)，单击系统所在的分区(通常为1区，一定要弄准)，再单击“OK”，如图所示。5、此时弹
