- 博客(14)
- 资源 (13)
- 收藏
- 关注
原创 Bug 11775332 - cluvfy fails with PRVF-5636 with DNS response timeout error [ID 11775332.8]
Bug 11775332 cluvfy fails with PRVF-5636 withDNS response timeout error but error text is not clear Thisnote gives a brief overview of bug 11775332. The content was last updated on:17-JUN-2013
2013-06-23 10:18:13 4586
原创 CVU NTP Prerequisite Check Fails With PRVF-5410 and PRVF-5416 [ID 1384298.1]
CVU NTP Prerequisite Check Fails With PRVF-5410 and PRVF-5416 [ID 1384298.1]Applies to:Oracle Database - Standard Edition - Version 11.2.0.1 and laterInformation in this document applies to
2013-06-22 10:36:45 10156
原创 Oracle 11g Data Guard Role Transitions: Failover
Role TransitionsInvolving Physical Standby Databases A database operates in one of the following mutuallyexclusive roles:primary orstandby. Data Guard enables you to change theseroles dynamica
2013-06-20 23:23:03 2978
原创 GoldenGate Data Pump 进程 report 报 WARNING OGG-01223 Cannot find executable file './server' 无法启动
今天遇到一怪问题,纳服的哥们又打过来说我们的 data pump 进程没启动,导致数据无法同步到对端,因为以往 data pump 进程没启动原因很简单,总是报 WARNING OGG-01223 TCP/IP error 146 (Connection refused). 出现这种错误,要么是因为网络不通,要么是因为对端的 manager 进程未启动。和纳服哥们一起核实后发现该对端进
2013-06-19 09:48:00 5842 1
原创 Oracle 11g Data Guard Role Transitions: Switchover
Role Transitions Involving Physical Standby Databases A database operates in one of the following mutuallyexclusive roles:primary orstandby. Data Guard enables you to change theseroles dynamic
2013-06-19 00:33:53 2124
原创 Oracle 11g Data Guard: How to Change Data Guard Protection Modes
How to Change Data Protection Mode ofa Primary Database Step 1 Select a dataprotection mode that meets your availability, performance, and data protectionrequirements. Maximum Availability
2013-06-18 09:04:05 3151
原创 Oracle 11g Data Guard: How to start and stop Redo Apply
1 Starting Redo Apply To start apply services on a physical standby database, ensure thephysical standby database is started and mounted and then start Redo Applyusing the SQL ALTER DATABASE REC
2013-06-17 21:11:17 3459
原创 Oracle 11g Active Data Guard step by step: How to create a Physical Standby Database using RMAN
DatabaseIPDB_UNIQUE_NAMEOracle Net Service Name Primary192.168.8.180prodProdStandby192.168.8.190standbystandby
2013-06-17 10:15:27 3405
原创 Oracle 中 DELETE 与 TRUNCATE 语句的区别及优缺点
通常,我们可以使用 TRUNCATE或 DELETE语句删除表中的记录。TRUNCATE语句的通常更高效,但是它的使用需要格外注意。TRUNCATE属于 DDL语句,这意味着 Oracle会在该语句运行后自动提交该语句及当前session中的事务,因此我们无法回滚 TRUNCATE语句。与此同时,又因为 TRUNCATE属于 DDL语句,我们无法在一个事务中 truncate两张不
2013-06-12 21:40:37 3508
原创 Oracle 11.2.0.3.0 Active Data Guard 遇 ORA-10458、ORA-01152、ORA-01110 错误
今天第一次配 Oracle 11g R2 Active Data Guard,在用 RMAN 创建好 physical standby database 后,尝试将 standby 以 read only 方式打开时遇如下错误:SQL> alter database open read only;alter database open read only*ERROR a
2013-06-12 10:05:10 6308
原创 Oracle 11g Undo 表空间切换
--1、查看实例当前所用 undo 表空间及 undo 相关参数SQL> show parameter undoNAME TYPE VALUE------------------------------------ ----------- ---------------------------
2013-06-11 22:31:49 3066
原创 Oracle 11g R2 新特性:Deferred Segment Generation
当你安装一个包含成千上万的表和索引的应用时,如果每个表和索引都初始分配一个 10MB的初始 extent。你很快会意识到如果每个对象在创建时都要分配 10 MB的磁盘空间,则部署DDL需要花费大量的时间。你可能会想到让 Oracle延迟每个对象的初始extent分配直到该表中实际插入记录为止。要延迟对象初始 segment的生成,唯一的方式就是使用 Oracle Database
2013-06-11 09:25:51 1919
原创 怎样在 Oracle RAC 环境下使用 Parallel 参数提高 Data Pump job 的性能
Data Pump可以并行运行多个 worker进程来提高 DataPump job的性能。将 PARALLEL参数设置为合理并行度可以充分利用当前的条件来提高性能。为了限制 Data Pump job对生产系统的影响,DBA可以对 job的并行度进行限制。例如,在业务系统生产期间可以将 PARALLEL设置为 2,在非生产期间可以将并行度设置为 8,可以在 job运行的任何时
2013-06-09 10:18:48 3817 2
原创 Flashing Back a Failed Primary Database into a Physical Standby Database
The following steps assume that a failover has been performed to aphysical standby database and that Flashback Database was enabled on the oldprimary database at the time of the failover. This proce
2013-06-30 12:17:44 1594
简单多用户Blog源码
2009-02-19
vs2005入门目录介绍
2009-02-17
基础课程_L1_STT_软件测试技术_Lab03
2009-02-08
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人