ITPub博客

ORA-00257:archiver error. Connect internal only,until freed.

重建索引

查看oracle的日志组切换频率

查杀oracle的阻塞源

物理Standby  概念DG通过REDO应用来维护物理Standby数据库。通常在物理Standby没有执行REDO应用操作的时候，可以将物理Standby数据库以READ ONLY模式打开，如果数据库中指定了Flashback Area的话...

[root@test ~]# cd /etc/udev/rules.d[root@test rules.d]# cat 99-oracle-asmdevices.rulesKERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="3600c0ff00027efc42a82ce5701000000", NAME="crs1", OWNER="grid",GROUP="asmadmin", MODE="...

查询Oracle正在执行的sql语句及执行该语句的用户：SELECT b.sid oracleID,         b.username 登录Oracle用户名,         b.serial#,         spid 操作系统ID,         paddr, &nbs...

查看buffer cache的大小：SQL> SELECT component,current_size,min_size FROM v$sga_dynamic_components;COMPONENT                                                      ...

创建表空间：create tablespace HY datafile '/usr/oracle/oradata/YSDB/HY01.dbf' size 300M autoextend on next 50M maxsize unlimited;创建临时表空间：create TEMPORARY tablespace TMP tempfile '/usr/oracle/oradata/YSDB/TMP01.dbf' size 1000M autoextend on next 50M maxsize unlimited;创建数据库用户...

数据库监听正常。用普通用户远程登录正常，但是用sys用户报错，登录工具PLSQL Developer报错信息：ora-01031:insufficient privileges根据提示代表没有权限。给sys用户赋予sysdba权限：SQL> grant sysdba to sys;grant sysdba to sys*ERROR at line 1:ORA-01994: GRANT failed: password file missing or disabled...

1.操作系统及Oracle版本：Linux版本：CentOS release 6.6 (Final)Oracle版本：Oracle Database 11g Release 2 (11.2.0.3.0) for Linux x86-64（p10404530_112030_Linux-x86-64_1of7.zip、p10404530_112030_Linux-x86-64_2of7.zip）如果是Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86-64版本，见下文链接：...

SQL> col SNAP_INTERVAL for a20SQL> col RETENTION for a20SQL> select * from dba_hist_wr_control;      DBID SNAP_INTERVAL        RETENTION            TOPNSQL---------- -------------------- -------------------- ---------- 8902...

查看表的情况，看是否要进行手工统计信息收集：SQL>select to_char(LAST_ANALYZED,'yyyy-mm-dd hh24:mi:ss') from DBA_TAB_STATISTICS where OWNER = '用户' and TABLE_NAME = '表名';SQL>select * from dba_tab_modifications where table_name='表名' and TABLE_OWNER='用户';SQL>SELECT s.table_name,s.num_row...

问题展现：机房掉电导致oracle 11g RAC+DG  3节点都非正常关机。开机之后，RAC两节点正常启动，DG上面的数据库实例只能启动到mount状态，无法open。DG：

Oracle 11g体系结构：oracle运行原理：高效处理数据内存机制：核心内存3大组件：Shared PoolDatabase Buffer CacheRedo Log BufferShared Pool:提升SQL语句在解析阶段的效率。Data Dictionary Cache数据字典高速缓冲区提升SQL语句解析阶段里的语义解析效率。把数据字典信息全弄到内存里，下次不需要读磁盘了...

[oracle@hr1 opt]$ mkdir -p infor1SQL> create directory scprd as '/opt/infor1';Directory created.SQL> grant read,write on directory scprd to system;Grant succeeded.[oracle@hr1 opt]$ expdp system/oracle@HR  dumpfile=tablespace_hr.dmp schemas=hr2  DIRECTORY=hr LOGFILE=hr2_exp.log...

创建表空间：create tablespace hr6_Data datafile    '+DATA' size 5000M REUSE autoextend on next 10M MAXSIZE Unlimited extent management local autoallocate permanent online;创建临时表空间：create temporary tablespace hr6_TempData tempfile    '+DATA' size 200M REUSE autoe...

Oracle 11g RAC环境，节点2[oracle@db2 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 15 21:08:14 2017Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the P...

[oracle@db1 ~]$ rman target /Recovery Manager: Release 11.2.0.3.0 - Production on Tue Dec 12 16:08:43 2017Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.connected to target database: PRD (DBID=893924085)RMAN> list backup of database;using target data...

oracle环境变量设置：[oracle@test ~]$ echo $ORACLE_SIDsh这个oracle的sid的环境变量是设置在.bash_profile修改这个文件。[oracle@test ~]$ pwd/home/oracle[oracle@test ~]$ cat .bash_profile# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then        . ~...