ITPub博客

环境：Oracle 11g RAC和DG关闭操作流程：RAC节点：关闭primary主机：SQL>shutdown immediate无法shutdown immediateSQL> shutdown abort;ORACLE instance shut down.SQL> startup restrict;ORACLE instance started.SQL> shutdownDatabase closed.Database dis...

[oracle@test dbs]$ vi initshdb.ora#shwmsdb.__db_cache_size=14361296896#shwmsdb.__java_pool_size=67108864#shwmsdb.__large_pool_size=67108864#shwmsdb.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment##shwmsdb.__pga_aggregate_target=4294967296#shwmsdb.__sga_target=21474836480#shwm...

环境：oralce 11g 11.2.0.3单节点报错信息：SQL> startup nomount;ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initshwmsdb.ora'无法启动到nomount状态：找不到pfile文件到dbs目录下...

环境：RAC  2节点：alert日志报错：RAC1：PING[ARC2]: Heartbeat failed to connect to standby 'DG'. Error is 12541RAC2：PING[ARC2]: Heartbeat failed to connect to standby 'DG'. Error is 12541DG：FAL[client, USER]: Error 12543 connecting to RAC for fetching gap sequence...

RMAN备份报错：RMAN-06207: WARNING: 286 objects could not be deleted for DISK channel(s) due to mismatched statusRMAN> delete noprompt obsolete;RMAN-06207: WARNING: 286 objects could not be deleted for DISK channel(s) dueRMAN-06208:          to mismatched status.  Us...

首先停止用户端连接：SQL > startup restrict mount;删除数据库：SQL> drop database;Database dropped.Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[oracle@test ~]$ c...

环境：oracle RAC 2节点DG 单节点问题：在DG上执行sqlserver到oracle的linkserver的ETL查询报错：Package Name:WMSINFO_ETL_StockPackage_5th Start Time: 2017/11/14 16:53:55Error: WMS_STOCK源无法处理这些数据。ORA-01555: 快照过旧: 回退段号 39 (名称为 "_SYSSMU39_3029844184$") 过小DG上DB的alert...

V$DATAGUARD_STATS视图提供了重做传输和重做应用进程落后多远的信息。在物理备库执行以下SQL脚本：COL NAME FOR A13COL VALUE FOR A20COL UNIT FOR A30SET LINES 122SELECT NAME,VALUE,UNIT,TIME_COMPUTEDFROM V$DATAGUARD_STATSWHERE NAME IN ('transport lag','apply lag');SQL> COL NAME FOR A13SQL> COL VA...

ASM on Non-First Node (Second or Others) Fails to Start: PMON (ospid: nnnn): terminating the instance due to error 481

1、现象Oracle 11g两个节点关机，进行硬件移动。同时开机后，节点1正常，节点2开始能启动ASM实例，但是很快ASM实例就挂了，而且CRS服务也启动不了。[oracle@shwmsdb1 ~]$ ps -ef|grep pmongrid     14309     1  0 03:05 ?        00:00:01 asm_pmon_+ASM1ora...

[oracle@test admin]$ pwd/u01/app/oracle/product/11.2.0/db_1/network/admin[oracle@test admin]$ cat listener.ora# listener.ora Network Configuration File: /oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER =  (DESCRIPTI...

授权：grant connect to test01;;

在DG上执行：SQL> select database_role from v$database;DATABASE_ROLE----------------PHYSICAL STANDBY原本DG是mount状态。SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;Database altered.SQL> alter database open read only;Database altered.SQL> ALTER DATABASE RECOVER MANAGED STANDB...

数据库版本：11.2.0.3.0RAC双节点，DG一节点。RAC节点1正常，RAC节点2出现log file sync严重等待事件，数据库性能受到严重影响。从AWR报告看：DB Time很高，log file sync等待严重。正常情况下log file sync的Avg wait应该是1。问题表现是log buffer向log file写入很慢。排除了IO问题。有一篇文章关于11.2.0.3的...

在DG上操作：SQL> select RECOVERY_MODE from v$archive_dest_status where rownum select group#,member from v$logfile order by 1;    GROUP#----------MEMBER---------------------------------------------...

[root@test ~]# su - oracle[oracle@test ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 17 21:28:22 2017Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith ...

备库关闭日志应用：SQL> select status from v$instance;STATUS------------MOUNTEDSQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;Database altered.日志报错：ORA-16037: user requested cancel of managed recovery operationManaged Standby Rec...

统计信息

oracle 11g 体系结构

数据库系统环境：操作系统：Microsoft Windows x86 64-bit数据库版本：oracle 11.2.0.1.0       单实例系统出现故障，CPU使用率飙升到100%看alert日志发现是redo的检查点没有完成，导致数据库实例出了故障 AWR报告：显示CPU消耗很高，而且log file sync单次等待达到10毫秒，表示IO可...