-
编辑 删除
【DG】三张经典图片展示Data Guard主备之间日志传输及恢复
5.3.1.2ARCn Archival Processing5.3.2.2LGWR SYNC Archival Processing5.3.2.3LGWR ASYNC Archival Processing参考自oralce官方文档：http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/log_trans...
-
编辑 删除
Applying Redo Data to Physical Standby Databases
6.3 Applying Redo Data to Physical Standby DatabasesBy default, the redo data is applied from archived redo log files. When performing Redo Apply, a physical standby database can use the real-time ap...
-
编辑 删除
Using a Physical Standby Database with a Time Lag
12.8 Using a Physical Standby Database with a Time LagBy default, when log apply services are running on the standby database, the redo data is either written to archived log files and applied, or w...
-
编辑 删除
Manually Determining and Resolving Archive Gaps
5.8.4 Manually Determining and Resolving Archive GapsIn some situations, automatic gap recovery may not take place and you will need to perform. gap recovery manually. For example, you will need to ...
-
编辑 删除
Planning for Growth and Reuse of the Control Files
The maximum control file size is 20000 database blocks. If DB_BLOCK_SIZE equals 8192, then the maximum control file size is 156 MB .7.4.2 Specifying the Reuse of Records in the Control FileThe...
-
编辑 删除
ORA-12012: error on auto execute of job 83
cd /data/oracle/product/10.2.0.1/OPatchcp /home/oracle/p8350262_10205_Generic.zip .[oracle@ora OPatch]$ unzip p8350262_10205_Generic.zip [oracle@ora 8350262]$ opatch prereq CheckConflictAgains...
-
编辑 删除
Where Are The Controlfile 'Max' Parameters Stored?
有人问到这个问题,当我们创建控制文件时指定的以下这些参数，是否可以从数据库的字典表中查询得到?MAXLOGFILES MAXLOGMEMBERS MAXDATAFILES MAXINSTANCESMAXLOGHISTORY 答案是除了MAXLOGMEMBERS以外，其他的都不可...
-
编辑 删除
oracle 分面查询
１.rownum 分页：(select * from emp)２.显示rownum [oracle 分配的]select a1.*,rownum rn from (select * from emp ) a13. 显示rownum 》６ 《＝１０select a1.*,rownum rn from (select * from emp ) a1 w...
-
编辑 删除
10gR2中awrsqrpt.sql介绍
在RDBMS/admin/awrsqrpt.sql中，这个脚本可以方便地取出某个sql在某两个快照间隔内，它总的消耗的cpu时间，执行次数，逻辑读，物理读，sql的执行计划以及sql的full sql text等 生成HTML的执行计划很简...
-
编辑 删除
Create SPFILE Under ASM
-- Suppose that the database instance name is "osmdr"-- In the database instance When trying to create a new spfile from a pfile under sqlplusSQL> create SPFILE='+DATA/osmdr/spfileosmdr.ora' from pfi...
-
编辑 删除
ORACLE 10G RAC+ASM 增加controlfile (安装好默认只有一个控制文件)
ORACLE10GRAC+ASM默认只有一个控制文件,如何增加多个控制文件的副本呢?网上的做法是直接恢复控制文件,但在哪里恢复没有说清楚.其实只要复制原来的控制文件即可.因为如果是恢复来自备份的控制文件,那么就和当前的...
-
编辑 删除
ORA-02354 ORA-01555
data/oracle/product/10.2.0.1/bin/expdp mma/mma schemas=mma directory=dump_dir dumpfile=expdp_mma_`date +%F`_%U.dmp EXCLUDE=TABLE:\"IN\(\'MMA_LOG\'\)\" parallel=2 filesize=8g logfile=...
-
编辑 删除
rlwrap 安装
默认情况下，在LINUX下使用SQLPLUS非常麻烦，退格键和命令记录都不能使用，我们最好安装rlwrap来实现在SQLPLUS和RMAN里的退格键和命令记录的功能# yum install ncurses ncurses-devel readline readline-dev...
-
编辑 删除
Quiesce Database
Quiesce DatabaseYou can put the system into quiesced state. The system is in quiesced state if there are no active sessions, other than SYS and SYSTEM. An active session is defined as a session that ...
-
编辑 删除
Database in quiesce mode
今天在oracle 10.2.0.5中安装EM时,总是卡住：[oracle@rac3 ~]$ emca -config dbcontrol db -repos createSTARTED EMCA at Apr 6, 2012 10:40:00 AMEM Configuration Assistant, Version 10.2.0.5.0 Product...
-
编辑 删除
Oracle 10g UNDO表空间过大导致磁盘空间不足的解决
在Oracle 10g数据库的应用中，出现了UNDO表空间过大导致磁盘空间不足而崩溃的现象(ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1')。对此问题进行分析后，总结了出现该问题的原因主要有以...
-
编辑 删除
rac 集群必会 [转]
最近整理了一下 RAC 方面的内容，稍作总结，发现 RAC 在集群这个层面需要知道的东西主要如下。1.查看CRS栈状态及各个服务的状态，配置CRS自动启动，启动关闭CRS2.查看修改 CRS参数 misscount3...
-
编辑 删除
最近跟踪了下GMCC一个系统的ORACLE性能问题，大致有这些方法
1、登录数据库2、看CPU是否耗用过多，运行队列是否过多vmstat --CPU当时有100多个任务在队列中3、看是否有CPU过高的进程top/prstat --系统CPU资源消耗100%，ORACLE进程占92%4、检查oracle进程数量ps -e...
-
编辑 删除
Backup && recover read only tablespace
1.alter tablesacpe read only SQL> alter tablespace test1 read only; Tablespace altered. SQL> a...
-
编辑 删除
Making User-Managed Backups of Read-Only Tablespaces
Making User-Managed Backups of Read-Only TablespacesWhen backing up an online read-only tablespace, you can simply back up the online datafiles. You do not have to place the tablespace in backup mod...
