标签 Oracle 下的文章

Oracle TBS 'REDO': Tablespace usage is too high (over 95% for 5m).

Posted on: 7 September 2023

查看当前日志组成员： ========== SQL> select member from v$logfile; > MEMBER > ------------------------------------------------------ > C:\ORACLE\PRODUCT\10.2.0\ORADATA\FYDB\REDO01.LOG > C:\ORACLE\PRODUCT\10.2.0\ORADATA\FYDB\REDO02.LOG > C:\ORACLE\PRODUCT\10.2.0\ORADATA\FYDB\REDO03.LOG

Tags: Oracle ZABBIX redo.log Tablespace

Anolis 7.9 安装 Oracle 19c 记录

Posted on: 27 November 2022

yum -y install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*.devel compat-libstdc++-33 compat-libstdc++-33*.devel gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libaio-devel*.devel libstdc++-devel libstdc++-devel*.devel libXi libXtst make sysstat unixODBC unixODBC-devel

Tags: Oracle Anolis 19c

Oracle几个命令备注

Posted on: 4 September 2021

crosscheck archivelog all; //交叉检查归档日志信息 delete noprompt obsolete; //删除超出保存策略的备份 delete noprompt expired archivelog all;

Tags: Oracle

Oracle11G数据库的导入导出记录

Posted on: 24 July 2020

su - roacle sqlplus /nolog conn /as sysdba show parameter dump_dir expdp system/password directory=dump_dir dumpfile=file.dump logfile=file.log schemas=user1,user2,user3 c:\users\Administrator>sqlplus /nolog

Tags: Oracle 11g expdp impdp

Oracle RAC 命令

Posted on: 27 January 2019

Oracle Clusterware把整个集群的配置信息放在共享存储上，这个存储就是OCR Disk.在整个集群中，只有一个节点能对OCR Disk进行读写操作，这个节点叫作Master Node，所有节点都会在内存中保留一份OCR的拷贝，同时哟一个OCR Process从这个内存中读取内容。

Tags: Oracle RAC CRS_STAT crsctl