cppg67031-优快云博客

转载 ctgmq00

[root@localhost ~]# mkdir -p ctgmq_deploy/version [root@localhost ~]# cd ctgmq_deploy/version [root@localhost ...

2018-03-17 15:30:55 1979

转载 HAIP&linked-local ip&RFC-3927&IPv4 169.254xxlinked local

APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterInformation in this document ...

2017-10-27 17:40:43 3679

转载 How to Create Oracle Database QoS Management Administrator Accounts

How to Create Oracle Database QoS Management Administrator Accounts [oracle@oratest1 bin]$ srvctl status ...

2017-09-27 17:15:40 304

转载 Creating Physical Standby Using RMAN DUPLICATE

Step by step guide on how to create a physical standby database using RMAN DUPLICATE FROM ACTIVE DATABASE ...

2017-09-27 16:30:38 330

转载 MultiColumn Statistics

When the WHERE clause of a query specifies multiple columns from a single table (multiple single column pr...

2017-09-15 09:59:22 206

转载 Result Cache Can Not Be Enabled

Result Cache is a feature introduced in Oracle 11g which caches the results of a query in the shared pool....

2017-09-08 11:28:30 98

转载 Convert Range-Partitioned Table To Interval-Range-Partitioned Table

Convert Range-Partitioned Table To Interval-Range-Partitioned Table first of all,Interval partitionin...

2017-08-25 21:55:06 199

转载 Indexing on Virtual Columns

Virtual columns can be indexed like any other non virtual columns. The index created is always a fu...

2017-08-25 13:38:56 140

转载 Create Reference-Partitioned Tables

Reference partitioning allows tables related by foreign keys to be logically equi-partitioned. The child tab...

2017-08-25 13:10:15 426

转载 How To Use Virtual Column-Based Partitioning

上一篇我介绍和测试了oracle 11g版本引入的虚拟列新特性，本文继续测试分区键基于表的虚拟列：Prior releases of Oracle only allowed a table to be parti...

2017-08-25 11:34:25 109

转载 How To Use Virtual Column

Oracle Database 11g (11.1) and later versions canstore expressions directly in base tables as Virtual columns...

2017-08-25 10:59:33 125

转载 How To Using Flashback Data Archive (Oracle Total Recall)

First of all,How Recall?An end user recovers from erroneous transactions that were previously committed in the d...

2017-08-24 11:55:58 134

转载 How To Configuring To Use Tbs Encryption

You can encrypt any permanent tablespace to protect sensitive data. Tablespace encryption is completely ...

2017-08-21 18:16:30 126

转载 How To Use DBMS_ADVISOR.TUNE_MVIEW Tuning Materialized Views

SQL Access Advisor index recommendations include bitmap, function-based, and B-tree indexes. A bitmap i...

2017-08-19 15:54:50 139

转载 Configure Direct NFS(DNFS) on RHELinux6.4 (11R2)

Configure Direct NFS(DNFS) onRHELinux6.4 (11R2) In oracle 11greleases,oracleintroduce ...

2017-08-17 11:55:27 183

转载 10.2.0.4以后vip不会自动relocate back回原节点

solution 1：srvctl relocate service -d -s -I;crsctl relocate resource $resource_name;solution 2：srvctl sta...

2016-05-25 05:13:09 591

转载 How To modify listener port in oracle 11g Grid

My env as follows:OS:[root@ORACLERAC2 ~]# uname -aLinux ORACLERAC2 2.6.32-358.el6.x86_64 #1 SMP Tue Jan 29...

2016-02-25 09:57:04 138

转载 SMON Following Errors ORA-21779

2016-01-22 10:06:36 229

转载 Oracle 11g rac add node

./addNode.sh -pre CLUSTER_NEW_NODES={sde1} CLUSTER_NEW_VIRTUAL_HOSTNAMES={sde1-vip}cluvfy stage -post nodeadd -...

2015-08-20 18:07:19 111

转载 OGG-00446

ogg@OSS-JH-DB1:/backup/ogg$ ./ggsciOracle GoldenGate Command Interpreter for OracleVersion 11.2.1.0.1 OGGCORE_...

2015-08-12 21:52:34 274

转载 Rman Backup&ORA-00245/RMAN-08132

日常监控备份发现，有个库归档备份报错信息如下：channel ch01: finished piece 1 at 2015-08-04 09:42:46piece handle=al_4171_1_886843941 t...

2015-08-04 09:56:22 165

转载 How To modify SCAN listener Port

**************************************************************************************************************...

2015-07-24 11:43:20 90

转载 Catalog archivelog from file system to Asmdg;

[root@sscp-db2 arch2]# scp 2_9204_844882031.dbf root@135.149.48.95:/u01The authenticity of host '135.149.48.95 ...

2015-07-17 17:36:00 231

转载 Please Check VKTM Trace File for More Details (文档 ID 1347586.1)

Applies to:Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterInformation in this document ...

2015-05-26 17:42:17 370

转载 SqlTuning&Composite Index

SQL> select a.processinstid from sas.wf_h_processinst a where a.createtime >= sysdate - 90;select a.proces...

2015-04-30 12:00:01 98

转载 Drop Column之ORA-01732

应用厂家同事报错，随即诊断如下：[root@netmgrdb1 ~]# su - oracle[oracle@netmgrdb1 ~]$ iduid=1101(oracle) gid=1000(oinstall) g...

2015-04-17 17:46:43 326

转载 BlockRecover之ORA-00494

凌晨00:10左右接到监控电话，说库连接异常，随即起床登陆主机一看，库实例已然crash掉啦,查告警日志： Mon Mar 23 20:45:24 2015 Thread 1 advanced to log seq...

2015-03-24 10:51:50 169

转载 How to create user for oracle10g/11g asm instance

在常规的asm维护管理中，我们可以用具有sysasm和sysdba权限的sys用户登录asm实例，进行相关的维护管理工作，但是在ogg相关的项目工程中，ogg读取asm存放的日志文件，为了管理的安全规范和方便，需要给...

2015-02-04 18:00:59 120

转载 GoldenGate&ASM&Connecting to a 'BLOCKED' instance

Applies to:Oracle Net Services - Version: 10.1.0.4.0 to 10.2.0.4.0Information in this document applies to any ...

2015-01-08 09:43:30 126

转载 How to check oracleasm config

uname -a cat /etc/*release rpm -qa |grep oracleasm /etc/init.d/oracleasm status lsmod |grep -i asm...

2014-08-23 17:55:49 97

转载资源管理才是关键焦点问题

集群内的资源调度和互补:1 业务空闲的和业务繁忙的互补互动调度资源（忙的种类不同，网络带宽/IOcpu）；2 白天忙的和晚上忙的业务时间错峰来资源互补互动调度(各自业务忙的时间不同)。 o...

2014-08-06 17:57:40 116

转载 Truncate and data_object_id

默认的，一个表当进行truncate 表时DATA_OBJECT_ID将增加1；但是当此表有一个索引时，进行truncate 表时DATA_OBJECT_ID将增加2： SQL> SQL>...

2014-07-01 16:42:16 106

转载 Rac One Node在计划内切换和非计划内CRASH时实例名的变化区别

我这里说的rac one node是11203版本，如果我们为了主动进行维护进行计划内切换，比如进行：srvctl relocate database -d lteidba -n osslteidb2...

2014-07-01 10:17:26 170

转载 11gR2_After Modify Passwd Normal User Conn Hang Solution

晚上陪着应用室同事弄数据库应用账号的口令加固工作，心想应该没什么大问题，一边等他们一边看电视，突然电话过来问题就出现了。应用帐号批量修改密码后，若干应用帐号用新密码连接数据库无反应hang住...

2014-06-19 10:11:04 84

转载 How to move ASM database files from one diskgroup to another

原来数据文件：ASMCMD> pwd+sysdg/UIMDB/datafileASMCMD> lsSYSAUX.257.840633371SYSTEM.256.8406333...

2014-06-12 11:07:00 84

转载 12c-How To Recover Root Container

接下来分享一下对root容器的备份与恢复： root容器的备份其实就是cdb的备份，完全没有pdb的备份： [oracle@orat3 ~]$ export ORACLE_SID=prd12cdb1 [oracle@...

2014-06-07 14:58:03 124

转载 12c-RECOVER PLUGGABLE DATABASE

[oracle@orat3 ~]$ export ORACLE_SID=prd12cdb1 [oracle@orat3 ~]$ rman target / Recovery Manager: Relea...

2014-06-07 10:57:53 290

转载 12c-Say goodbye to your backup when dropping your PDB

删除pdb：SQL> drop PLUGGABLE database ZSKMSDB; Pluggable database dropped.SQL> show pdbs CO...

2014-06-07 00:05:33 106

转载 How To Restore 12cR1DB to New Host File System using RMAN(二)

容器数据库(CDB$ROOT)包含system，sysaux，undo和temp表空间，控制文件和redofile；而种子数据库(PDB$SEED)包含system，sysaux，temp，example表空间，用来作...

2014-06-05 13:51:54 106

转载 How To Restore 12cR1DB to New Host File System using RMAN(一)

oracle 12cr1 异机恢复； oracle 12cr1备份目前nbu不支持，所以主机写sh包含rman，然后放到crontab里变定期跑备份到本地文件目录； [root@uccpdb2...

2014-05-29 13:46:59 127

空空如也

空空如也