XIANHUAFANG的博客

有时我们想知道数据库创建以来数据文件的空间增长情况，可以以下语句初略统计SELECTTO_CHAR(creation_time,'RRRR-MM')"month",SUM(bytes)growthFROMsys.v_$datafileGROUPBYTO_CHAR(creation_time,'RRRR-MM')ORDERBYTO_CHAR(creation_time,'RRRR-MM');monthGROWTH------------------------2019-052076180480。...

有一个ORACLE 11G RAC集群，由于各种原因，不用集群了，使用单机，删除GI 部分，包含GRID用户，然后，启动数据库，报以下错误：$ sqlplus /nologSQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 13 20:18:20 2022Copyright (c) 1982, 2013, Oracle. All rights reserved.SQL> conn / as sysdbaConnected to an idle instanc

rac expdp导出时报错：ORA-31693: Table data object "testuser"."test" failed to load/unload and is being skipped due to error:ORA-31617: unable to open dump file "/home/oracle/exp_dir/full05.dmp" for writeORA-19505: failed to identify file "/home/oracle/exp_

Bug30284751 - Trace File With Messages "Required IPC RDMAV_FORK_SAFE /RDMAV_HUGEPAGES_SAFE" Is Generated In Windows Platform (Doc ID30284751.8) This note gives a brief overview of bug 30284751.The content was last updated on: 08-MAR-2022Aff...

安装11.2.0.4数据库进度到80%多的时候报ORA-13516: AWR Operation failed: CATPROC not valid.当时在设置密码的时含有@符号,和以下文档相符:DBCA fails in the middle of database creation with ORA-13516 / ORA-06512 (文档 ID 1929718.1)In this DocumentSymptomsCauseSolutionApplies to:Orac

数据库环境单机+DG，在备库alert日志中出现这样的告警：ORA-00235: control file read without a lock inconsistent due to concurrent update查询官方文档（Doc ID 8655559.8）WorkaroundIgnore the errors in the alert log.可以确认是由版本bug造成的，bug号为8655559，可以安全忽略...