ORA-01173的模拟与故障处理
下面的测试来至于一位网友，他们生产数据库异常，在drop表空间，重建控制文件后，报下面的错误： Sat Jul 19 00:45:47 2014SMON: enabling cache recoverySat Jul 19 00:45:47...
技术文章列表
120 篇Optimize Oracle SQL*Loader (sqlldr) Performance
> > > > > > > > > > > Advanced Oracle Utilities > SQL*Loader Option | Elapsed Time (...
Optimize Oracle import performance
| | **Optimize Oracle import (imp) performance** Don Burleson | see here[Oracle export (expdp) performance speed](http:/...
OGG_GoldenGate日常监控
!1756814744621-2b73f94c-b576-4c01-a8e7-94c769a7f3cd.png一、摘要 — 对GoldenGate实例进行监控，可以公国简单高效的方式GGSCI命令进行监控，并查看返回的信息，判断...
Moving Your 11.2 Database to a new Diskgroup in ASM
Introduction: I have been assigned with a new challenge with 11.2 Oracle On RedHat Linux with Grid Infrastructure and AS...
Monitoring Restore_Recovery Progress 1335910.1
Goal Solution RMAN Log Alert.log Restore Operation Recovery Operation User Managed Recovery Log Operating System Utiliti...
Migration using cross platform transportable tablespace [XTTS] and Cross platform incremental backup
DBMS_FILE_TRANSFER method RMAN backup method Pre-requisites for using "XTTS+Cross platform incremental backup"...
Linux系统Oracle定时删除归档日志
使用rman命令删除做Oracle数据库定期删除归档日志处理1、准备工作：以root用户角色登录Linux操作系统，创建存储删除归档时记录日志及删除shell脚本文件的目录并授权给Oracle用户，命令如下：mkdir -p /home/d...
Linux传统Huge Pages与Transparent Huge Pages总结
Linux下的大页分为两种类型：标准大页（Huge Pages）和透明大页（Transparent Huge Pages）。Huge Pages有时候也翻译成大页/标准大页/传统大页，它们都是Huge Pages的不同中文翻译名而已，顺带提...
Oradba
1.七种外语教科书参考.docx – http___122.228.237.105_d1.baidupcs.com_file_91ee06f0833b7d33fd7a5174ebd847f1_ 10Grac del 11.2RA...
Huge Archive_Redo Generation in System
Archive for April, 2015 Huge Archive/Redo Generation in System! Posted by FatDBA on April 14, 2015 On one of our product...
How to retrieve previous table statistics using Oracle dbms_stats – Blog dbi services
Sometimes, you need to modify the statistics of a table. There are various reasons: either for the performance analysis ...
How to install Oracle RAC 18c in silent mode on Oracle Linux 7.5 with VirtualBox – Part 2_1
Both posts document how to install a 2-node Oracle RAC cluster with Oracle 18c on Oracle Linux 7.5 (OL7) with VirtualBox...
How to install Oracle RAC 18c in silent mode on Oracle Linux 7.5 with VirtualBox – Part 2
Both posts document how to install a 2-node Oracle RAC cluster with Oracle 18c on Oracle Linux 7.5 (OL7) with VirtualBox...
How Migrate All Files on ASM to Non-ASM (Unix_Linux)
I’ll use PL/SQL scripts and RMAN commands to accomplish this. I don’t like to use Oracle Managed File (OMF) for filesyst...
How many checkpoints in Oracle database _
Well, the answer is 7 (as per my knowledge). Oracle does 7 different checkpoints at various stages. Lets check out what ...
GoldenGate在Oracle数据库复制环境下aftercsn与atcsn的选取测试
实验说明： 熟悉Ogg实施过程的伙伴们都应了解，实施步骤中初始化的步骤尤为关键，通常可以使用rman或者exp两种方式，而开启复制进程时也有atcsn（大于或等于该scn的事务将被apply），aftercsn（大于该scn的事务将被app...
EXPDP_IMPDP running slow on 11g or above _ STREAMS AQ: ENQUEUE BLOCKED ON LOW MEMORY” WHEN REDUCING STREAMS_POOL_SIZE
SYMPTOMS The import with DataPump of tables into an Oracle11g Release 11.2.0.4 database takes almost 45 minutes, while t...
Enable ARCHIVELOG and FLASHBACK mode on ASM
Tweet Recommend this on Google To enable ARCHIVELOG on ASM and configure FLASHBACK (without enabling it) you need to set...
Document 1260095.1
Applies to: Oracle Database – Enterprise Edition – Version 11.2.0.1 to 11.2.0.4 [Release 11.2] IBM AIX on PO...