1.先去监听日志的目录里面并查看大小 cd $ORACLE_HOME/network/log/ du -sh *2.到listener里面,查看对应的log_file和log_status [oraarp@localhost log]$ lsnrctl LSNRCTL> show log_file &nbs...【阅读全文】
博客文章除注明转载外,均为原创。转载请注明出处。本文链接地址:http://blog.chinaunix.net/uid-31396856-id-5753417.html某库数据库检查表空间大小的时候非常慢检查其其执行计划:SQL> set timing onSQL> set autot onSQL> set linesize 120SQL> /Elapsed: 00:01:45.55Execution Plan----------...【阅读全文】
转载请注明出处。本文链接地址:http://blog.chinaunix.net/uid-31396856-id-5752977.html节后第一天就遇到dg出现gap但是已无日志进行恢复,从前已经遇到过好几次。alert日志Tue Oct 08 16:02:10 2016FAL[client]: Failed to request gap sequence GAP - thread 1 sequence 26336-26435 DBID 3637089832 ...【阅读全文】
集群alert在$ORACLE_HOME/log/hostname/alerthostname.log2016-10-08 10:37:48.706: [ohasd(2219)]CRS-2112:The OLR service started on node rac1.2016-10-08 10:37:48.875: [ohasd(2219)]CRS-1301:Oracle High Availability Service started on node rac1.(OHAS)2016-10-08 10:37:48.882: [ohasd(2219)]CRS-8017...【阅读全文】
Data Block是数据库中最小的I/O单元,下面我来简单介绍下数据块的基本结构。OK!跟着我一步步实验:一、建表空间SQL>create tablespace tp1 datafile '/oradata/bxocp/tp01.dbf' size 10M;二、建用户及授权SQL>create user gyj identified by gyj default tablespace tp1;SQL>grant dba to g...【阅读全文】