Perry705-CSDN博客

原创时间戳解析

分类语法解释示例 y-year yyyy full year number. 2015 yy two-digit year. 15 M-month of the year M minimal-digit month. 1 MM two-digit month. 01 MMM two-di...

2019-08-30 17:18:24 1398

原创创建ASM磁盘（Redhat/Centos 6及以上）

1.查看磁盘UUID[root@rac01 rules.d]# /sbin/scsi_id -g -u -d /dev/sdb36000c296d133a2fcc55455bd5142dadb2.配置/etc/udev/rules.d/99-asm.rules文件[root@oradb ~]# vi/etc/udev/rules.d/60-raw.rulesKERNEL==...

2019-06-17 17:06:49 742

原创 DataGuard日志无法同步，报错：CORRUPTION DETECTED: In redo blocks starting at block ......

DataGuard日志无法同步，报错如下图：After further investigation, it would seem that the Cisco switches being used between ourprimary and standby sites had “SQL*Net inspection enabled” by default (deep packet i...

2019-06-13 14:42:52 735

原创登录Linux短时间内不操作就会断开连接并报该“Write failed: Broken pipe”错误

问题描述：登录Linux短时间内不操作就会断开连接并报该“Write failed: Broken pipe”错误。问题方案：方法一：如果您有多台服务器，不想在每台服务器上设置，只需在客户端的 ~/.ssh/config 文件中，添加下面的配置：ServerAliveInterval 60方法二：如果您有多个人管理服务器，不想在每个客户端进行设置，只需在服务器的 /et...

2019-06-11 21:56:30 1080

原创 Oracle归档日志暴增查找定位

1.查找引起日志暴增对象select * from (SELECT to_char(begin_interval_time, 'YYYY_MM_DD HH24:MI') snap_time, dhsso.object_name, SUM(db_block_changes_delta) FROM dba_hist_seg_stat dhss, ...

2019-06-10 14:15:04 4404

原创在线迁移ASM磁盘

1、创建新的ASM磁盘（参考如下）[root@rac2 ~]# cat /etc/udev/rules.d/99-oracle-asmdisk.rules KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent", RESULT=="36000c2922c52395d2fe5336aa94477c...

2019-06-03 17:50:59 286

转载 Grid Infrastructure 启动的五大问题 (Doc ID 1526147.1)

文档内容用途适用范围详细信息问题 1：CRS-4639：无法连接 Oracle 高可用性服务，ohasd.bin 未运行或 ohasd.bin 虽在运行但无 init.ohasd 或其他进程问题 2：CRS-4530：联系集群同步服务守护进程时出现通信故障，ocssd.bin 未运行问题 3：CRS-4535：无法与集群就绪服务通信，crsd.bin 未运...

2018-12-20 10:35:20 771

转载 free命令详解

1、free命令显示结果$free total used free shared buffers cachedMem: 16464652 16371084 93568 0 305928 14781392-/+ buffers/cache: 1283764 15...

2018-05-04 17:43:14 14263 1

转载 CPU and Wait Time Tuning Dimensions

CPU and Wait Time Tuning DimensionsWhen tuning your system, it is important that you compare the CPU time with the wait time of your system. By comparing CPU time with wait time, you can determine how...

2018-04-13 16:39:46 256

原创 oracle中的processes,session,transaction参数详解

Oracle数据库中processes,sessions,transactions分别代表进程数、会话数及当前最大允许的交易量。按照官方文档中描述，他们之间是有关系的。以下是11.2.0.4数据库版本（一会儿测试也是11.2.0.4版本）sessions=(1.5*processes)+22transactions＝1.1*sessions在10g版本中sessions=(1.1*processe...

2018-04-12 17:32:02 3629

翻译 Patchsets

Assistant: Download Reference for Oracle Database/GI PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2)Patchsets12.1.0.2 (12.1.0.2.0 PATCH SET FOR ORACLE DAT

2017-12-13 16:02:37 297

翻译 Rolling Patch - OPatch Support for RAC (Doc ID 244241.1)

APPLIES TO:Oracle Database - Enterprise Edition - Version 9.0.1.0 to 12.1.0.2 [Release 9.0.1 to 12.1]Information in this document applies to any platform.PURPOSEThis note is to describe the

2017-12-04 22:31:44 386

转载什么是PSU/CPU

1. 什么是PSU/CPU？CPU: Critical Patch UpdateOracle对于其产品每个季度发行一次的安全补丁包，通常是为了修复产品中的安全隐患。自2012年10月已经更名为Security Patch Update (SPU)PSU: Patch Set UpdatesOracle对于其产品每个季度发行一次的补丁包，包含了bug的修复。Oracle选取被用户

2017-11-28 18:56:41 2600

转载关于脑裂

Oracle Grid Infrastructure: Understanding Split-Brain Node Eviction (Doc ID 1546004.1)To BottomIn this Document Purpose Scope Detail

2017-06-14 15:52:13 424

转载 Flashing Back a Failed Primary Database into a Physical Standby Database（12.1）

Oracle Data Guard Concepts and Administration>Oracle Data Guard Scenarios>Converting a Failed Primary Into a Standby Database Using Flashback Database>15.2.1 Flashing Back a Fa

2016-12-13 19:38:02 418

翻译 Interpreting Explain Plan (10g and Above) (文档 ID 1616894.1)

In this DocumentPurpose Scope Details What is an explain plan? Terminology How does Oracle access data?

2016-10-18 11:19:06 481

转载游标例子

Example 6-18 Implicit Cursor FOR LOOP StatementBEGIN FOR item IN ( SELECT last_name, job_id FROM employees WHERE job_id LIKE '%CLERK%' AND manager_id > 120 ORDER BY last_name

2016-09-05 21:34:46 323

原创 duplicate报错：ORA-12154

2016-09-05 13:42:56 808

原创启动数据库报错：

SD2-100-RAC1:/home/oracle>srvctl start database -d anyangPRCR-1079 : Failed to start resource ora.anyang.dbCRS-5017: The resource action "ora.anyang.db start" encountered the following error: OR

2016-09-05 13:34:19 552

原创 DG同步测试脚本

sqlplus / as sysdba drop table t1;create table t1(id number,check_for_dg varchar2(30));declarei number;begindelete t1 where 1=1;insert into t1 values(1,to_char(sysdate,'YYYY-MM-DD HH24:M

2016-09-05 13:29:59 892

转载 Creating a Standby using RMAN Duplicate (RAC or Non-RAC) (Doc ID 1617946.1)

Creating a Standby using RMAN Duplicate (RAC or Non-RAC) (Doc ID 1617946.1)To BottomIn this DocumentGoal Solution

2016-08-30 11:58:08 1494

转载 Adding a standby database to a dataguard configuration fails with ORA-1017 (Doc ID 1072022.1)

Adding a standby database to a dataguard configuration fails with ORA-1017 (Doc ID 1072022.1)To BottomIn this DocumentSymptoms

2016-08-07 20:02:59 732 2

原创创建Control Files/Redo Log Files的目录顺序

Specifying Control Files at Database CreationAt database creation, the control file is created in the files specified by the CONTROL_FILES initialization parameter. If the CONTROL_FILES paramete

2016-04-26 15:27:29 395

原创 Duplication with Oracle Managed Files(OMF)

Duplication with Oracle Managed FilesIf the source database files are in the Oracle Managed Files (OMF) format, then you cannot use the DB_FILE_NAME_CONVERT andLOG_FILE_NAME_CONVERT initializati

2016-04-26 14:16:04 406

原创 Resolving ORA-752 or ORA-600 [3020] During Standby Recovery (Doc ID 1265884.1)

Resolving ORA-752 or ORA-600 [3020] During Standby Recovery (Doc ID 1265884.1)To BottomIn this DocumentSymptoms Cause

2016-04-25 20:49:34 892

原创 standby报错：PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 16009.

standby报错：Mon Apr 25 12:18:26 2016PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. Error is 16009.Mon Apr 25 12:19:26 2016PING[ARC2]: Heartbeat failed to connect to standby 'orcl'. E

2016-04-25 13:30:40 7000

原创 Installer安装过程中报错：安装包有问题

Installer安装过程中报错：安装包有问题（大小一致，可正常解压）Installer安装过程中报错：安装包有问题（大小一致，可正常解压）

2016-04-19 21:45:10 988

原创 Views Relevant to Oracle Data Guard

This chapter describes the views that are especially useful when monitoring a Data Guard environment. The view described in this chapter are a subset of the views that are available for Oracle databas

2016-04-19 17:28:50 243

原创 Physical Standby Switchover_status Showing Not Allowed. (Doc ID 1392763.1)

Physical Standby Switchover_status Showing Not Allowed. (Doc ID 1392763.1)In this Document Symptoms Cause SolutionThis docum

2016-04-17 19:40:40 1629

原创 rman target sys/oracle@PROD1 auxiliary sys/oracle@PROD2

[oracle@lucky ~]$ rman target sys/oracle@PROD1 auxiliary sys/oracle@PROD2//1.When you connect RMAN to the source database as TARGET, you must specify a password, even if RMAN uses operating syst

2016-04-07 10:52:40 3734

原创 Physical and Logical Block Corruptions. All you wanted to know about it. (Doc ID 840978.1)

Physical and Logical Block Corruptions. All you wanted to know about it. (Doc ID 840978.1)Physical Block CorruptionsThis kind of block corruptions are normally reported by Oracle with erro

2016-03-24 13:05:30 407

原创 Directory Structures for Oracle RAC

/u01/app/grid/11.2.0/An OFA-compliant path for the Oracle Clusterware home.During the Oracle Grid Infrastructure for a cluster installation, Oracle Clusterware and Oracle Automatic Storage Man

2016-03-23 10:51:52 258

原创 Requirements for Creating an Oracle Grid Infrastructure Home Directory

Requirements for Creating an Oracle Grid Infrastructure Home Directory

2016-03-22 19:41:26 387

原创 DB2诊断日志路径查看

UNIX：################db2 get dbm cfg Diagnostic data directory path (DIAGPATH) = /home/db2inst1/sqllib/db2dumpWINDOWS:################db2 get dbm cfg 诊断数据目录路径

2016-02-16 09:39:29 10520

原创 11gR2 DataGuard参数文件(pfile/spfile)设置模板

主机：orcl.__db_cache_size=771751936orcl.__java_pool_size=16777216orcl.__large_pool_size=16777216orcl.__oracle_base='/u01/app/oracle'orcl.__pga_aggregate_target=1308622848orcl.__sga_target=20

2016-01-15 08:53:44 877

原创 11gR2 DataGuard standby开启实时查询（Real-time query）备份standby恢复报错：ORA-01194 ORA-01110

1.备份standy，确认archivelog同步是没有问题的2.使用rman备份恢复standby，打开报错3.手动在主机切换redo将切换后的3组归档日志拷贝到备机4.手动指定归档日志前滚后，数据库可以open

2016-01-14 16:45:09 1862

原创 dbca静默建库

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname orcl -sid orcl -sysPassword oracle -systemPassword oracle -responseFile NO_VALUE -datafileDestination /u01/app/oracle/oradata/or

2016-01-13 11:59:57 1218

原创 RMAN For 11gR2 RAC脚本备份

1.创建脚本，备份集，备份日志存放路径mkdir /data/scripts -p //备份脚本路径mkdir /data/rman_bak/data -p //备份集存放路径mkdir /data/rman_bak/logs -p //备份日志存放路径chown oracle:oinstall /data -R //设置路径

2016-01-07 14:48:12 1493

原创 11gR2 RAC停机修改redolog路径

1.查看redolog路径2.停止所有节点的数据库服务srvctl stop database -d orcl3.连接ASM实例，查看确认磁盘组（本实验中将+DATA和+ARCH中的redolog修改到+DC中）4.进入asmcmd，在+DC中创建对应的路径5.将+DATA和+ARCH中的redolog全部cp到+DC中

2016-01-07 13:42:17 1265

空空如也

空空如也