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으로 문의하세요.
如何恢复您的 Steam 云存档May 28, 2023 pm 10:25 PMSteam会在您玩游戏时保存您的游戏进度并将其存储在Steam云中。当您在多台设备上玩Steam游戏时，此功能非常有用。只需在所有设备上使用您的Steam凭据登录，安装游戏即可！所有用户设置、游戏保存数据、您朋友的聊天框等等。修复1–检查游戏是否受支持所有Steam游戏均不支持Steam云存档功能。因此，您必须检查游戏是否真的支持此功能。1.在您的系统上打开Steam应用程序。2.现在，您必须使用您的凭据登录Steam。3.然后，输入您的用户名和密码，然后点击“登录
如何修改Linux的fstab文件以取消只读属性Jan 15, 2024 pm 05:57 PM实验了通过挂载选项禁止执行set位程序、二进制程序[root@localhost~]#vi/etc/fstab/#加入/dev/sdc1/varext3defaults,noexec12[root@localhost~]#mount-oremount/var之后系统重启发现不到/dev/sdc1进入不了，只能够进入字符界面。想删除掉那一行，可是文件保存的时候提示只读属性Read-onlyfilesystem实验过用（1）chmod+w/etc/fstab（2）:w!文件还是只读，不能够修改方法＃
Windows 11 Recovery USB：下载、安装和创建Jul 05, 2023 pm 01:05 PM您的PC有时会遇到问题，导致难以正常启动。在这种情况下，您可以使用Windows11恢复USB恢复它。虽然这一切看起来简单明了，但您仍然需要知道如何创建和使用恢复USB。在本指南中，我们将引导您完成轻松执行此任务所需的步骤。我可以下载Windows11恢复USB吗？如果您的操作系统完全崩溃，您可以从另一台运行良好的PC下载Windows11恢复USB。但是，要从中创建恢复驱动器的电脑必须与你的电脑具有相同的体系结构。最好的选择仍然是在PC正常运行时从PC创建USB。这消除了任何兼容性风险。或者，
机器学习基础之数字上的距离：点在空间中的距离Apr 11, 2023 pm 11:40 PM本文转载自微信公众号「活在信息时代」，作者活在信息时代。转载本文请联系活在信息时代公众号。在机器学习中，一个基础的概念就是如何判断两个样本之间的差异，从而能够评价两个样本之间的相似性和类别等信息。而判断这种相似性的度量就是两个样本在特征空间内的距离。根据数据特征的不同，度量方法有很多种。一般而言，对两个数据样本x，y，定义一个函数d（x，y），如果定义其为两个样本之间的距离，那么d（x，y）则需要满足以下几条基本性质：非负性：d（x，y）>=0同一性：d（x，y）=0 ⇔ x=y对
实践指南：在Oracle中实现表级只读权限Mar 06, 2024 pm 05:09 PM在Oracle中实现表级只读权限是数据库管理中常见且重要的操作。通过设置只读权限，可以确保部分用户只能查询表的数据，而不能进行修改操作，从而有效保护数据的完整性和安全性。下面将详细介绍在Oracle中如何实现表级只读权限，以及具体的代码示例。步骤一：创建表首先，在Oracle中创建一个示例表，用于演示如何设置表级只读权限。假设我们创建了一个名为“exampl
升级win11需要的C盘空间介绍Dec 23, 2023 am 08:57 AM众所周知，如果系统安装完成后占用系统盘太大，可能会导致系统运行卡顿、延迟，甚至是文件丢失。因此大家在安装win11系统之前，需要了解升级win11需要多大C盘空间，下面就跟着小编一起来看看吧。升级win11需要多大C盘空间：答：升级win11需要20-30GB的C盘空间。1、根据微软的win11配置要求可以看到，win11安装需要64GB的硬盘空间。2、但其实一般来说是不需要这么大的空间的。3、根据已经安装win11的用户反馈，win11升级大概需要20-30GB的C盘空间。4、但是如果我门只有
c盘剩余空间多大合适Jun 27, 2023 pm 02:51 PMc盘剩余空间50-80G比较合适。由于系统在日后使用当中会产生垃圾文件,缓存文件等因此建议至少预留50GB-80GB的空间给C盘;如果您不习惯在安装软件时选择路径,日常也不是经常清理电脑,那么至少需要100GB。
如何在 Ubuntu 上添加交换空间 22.04 LTSFeb 20, 2024 am 11:12 AM交换空间在Linux系统中扮演着重要角色，特别是在系统内存不足时。它充当着一个备用的内存存储空间，可以帮助系统平稳运行，即使在负载高的情况下也能保持稳定性。本文为您提供了在Ubuntu22.04LTS上添加交换空间的详细指南，以确保您的系统性能得到优化并能应对各种工作负载。了解交换空间交换空间提供虚拟内存，用于补充系统的物理RAM。当系统的RAM不足时，内核会将数据交换到磁盘，以防止内存不足和系统崩溃。Linux系统常用交换空间来处理这种情况。同时运行多个内存密集型应用程序处理非常大的文件或数据
핫 AI 도구
Undresser.AI Undress
사실적인 누드 사진을 만들기 위한 AI 기반 앱
AI Clothes Remover
사진에서 옷을 제거하는 온라인 AI 도구입니다.
Undress AI Tool
무료로 이미지를 벗다
Clothoff.io
AI 옷 제거제
AI Hentai Generator
AI Hentai를 무료로 생성하십시오.
인기 기사
R.E.P.O. 에너지 결정과 그들이하는 일 (노란색 크리스탈)
2 몇 주 전By尊渡假赌尊渡假赌尊渡假赌
Repo : 팀원을 부활시키는 방법
4 몇 주 전By尊渡假赌尊渡假赌尊渡假赌
헬로 키티 아일랜드 어드벤처 : 거대한 씨앗을 얻는 방법
4 몇 주 전By尊渡假赌尊渡假赌尊渡假赌
스플릿 소설을이기는 데 얼마나 걸립니까?
3 몇 주 전ByDDD
R.E.P.O. 파일 저장 위치 : 어디에 있고 그것을 보호하는 방법은 무엇입니까?
3 몇 주 전ByDDD
뜨거운 도구
SublimeText3 Mac 버전
신 수준의 코드 편집 소프트웨어(SublimeText3)
DVWA
DVWA(Damn Vulnerable Web App)는 매우 취약한 PHP/MySQL 웹 애플리케이션입니다. 주요 목표는 보안 전문가가 법적 환경에서 자신의 기술과 도구를 테스트하고, 웹 개발자가 웹 응용 프로그램 보안 프로세스를 더 잘 이해할 수 있도록 돕고, 교사/학생이 교실 환경 웹 응용 프로그램에서 가르치고 배울 수 있도록 돕는 것입니다. 보안. DVWA의 목표는 다양한 난이도의 간단하고 간단한 인터페이스를 통해 가장 일반적인 웹 취약점 중 일부를 연습하는 것입니다. 이 소프트웨어는
SecList
SecLists는 최고의 보안 테스터의 동반자입니다. 보안 평가 시 자주 사용되는 다양한 유형의 목록을 한 곳에 모아 놓은 것입니다. SecLists는 보안 테스터에게 필요할 수 있는 모든 목록을 편리하게 제공하여 보안 테스트를 더욱 효율적이고 생산적으로 만드는 데 도움이 됩니다. 목록 유형에는 사용자 이름, 비밀번호, URL, 퍼징 페이로드, 민감한 데이터 패턴, 웹 셸 등이 포함됩니다. 테스터는 이 저장소를 새로운 테스트 시스템으로 간단히 가져올 수 있으며 필요한 모든 유형의 목록에 액세스할 수 있습니다.
Atom Editor Mac 버전 다운로드
가장 인기 있는 오픈 소스 편집기
ZendStudio 13.5.1 맥
강력한 PHP 통합 개발 환경
