RMAN恢复报错ORA-01180: can not create datafile 1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ==…
Centos7.4安装Oracle11g 一、环境规划 HostName IP DB Name Version Oracle Home Oracle Base server01 192.168.1.113 oradb Oracle11g 11.2.0.4 /opt/app/oracle/product/11.2.0/db_1 /opt/app/or…
Oracle11g RAC迁移到单机 一、环境 1.RAC环境(源库) HostName Public IP Private IP VIP Scan IP DB Name Rac01 192.168.1.21 10.0.0.21 192.168.1.23 192.168.1.25 mydb Rac02 192.168.1.22 10.0.0.22 …
一、故障现象 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ============…
查看数据文件、日志文件、临时文件存放位置脚本: set line 9999 pagesize 9999 col FILE_NAME format a60 select 'datafile' file_type, file#,name FILE_NAME,status,enabled from v$datafile union a…
查询频繁commit的SQL语句: set linesize 1000 column sid format 99999 column program format a20 column machine format a20 column logon_time format date column wait_class format a10 colu…
安装Oracle19c RAC执行runcluvfy.sh验证报错: [grid@server01 grid]$ ./runcluvfy.sh stage -pre crsinst -n server01,server02 -method root Verifying User Equivalence ...FAILED server02: PRV…
DNS服务器安装与配置 一、配置YUM [root@dns ~]# mkdir /opt/yum [root@dns ~]# cp -r /run/media/admin/CentOS\ 7\ x86_64/* /opt/yum/ [root@dns ~]# cat > /etc/yum.repos.d/CentOS-Base.repo &l…
SQL> drop diskgroup data including contents; drop diskgroup data including contents * ERROR at line 1: ORA-15039: diskgroup not dropped ORA-15073: diskgroup DATA is mounted by…
Oracle PSU/CPU/RU补丁下载 1.Opatch 登录support.orcle.com或者直接打开 https://updates.oracle.com/download/6880880.html 或搜索Document 293369.1 2.常用补丁下载 Quick Reference to Patch Numbers for Da…