ITPub博客

方式一:按照天数批量生成awr输入参数: 快照截止时间snap_date输入参数: 收集的天数输入参数: 类型(text/html)注意 :此脚本需要先保存成文件如batch_awrrpy.sql然后再sqlplus 里执行     ...

RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform. Support (Doc ID 1079563.1)APPLIES TO:Oracle Server - Enterprise Edition - Version 10.2.0.1 and laterInformation in this document applies to any platf...

Oracle Server - Enterprise Edition - Version 9.2.0.1 to 11.2.0.2 [Release 9.2 to 11.2]Information in this document applies to any platform.SYMPTOMSRecovery session fails:SQL> recover database;ORA...

Oracle Support Lifecycle AdvisorsWelcome | Agile | E-Business Suite | Engineered Systems | Enterprise Manager | Enterprise Performance Management&nbsp...

 1   启动报ORA-01157 ORA-01110状态2   启动数据库到mount 状态3   alter database datafile offline drop;4   alterdatabase open5   创建新的u...

APPLIES TO:(Doc ID 1428786.1).OracleServer - Enterprise Edition - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]Information in this document applies to anyplatform.SYMPTOMSTh...

APPLIES TO:Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]Information in this document applies to any platform.Checked for relevance on 11-Jan-2012SYMPTOMSWhil...

APPLIES TO:Oracle Universal Installer - Version 10.2.0.3 to 11.1.0.7 [Release 10.2 to 11.1]Information in this document applies to any platform.Reviewed for currency Aug-27-2012SYMPTOMSFollowing error...

环境操作系统：Redhat 5.4 x86数据库版本：Oracle 10.2.0.1Golden Gate : V11.1.1.1.2 for Oracle 10g on Linux x86源端： hostname：ylptnode1目标端：hostname：ylptnode2 一准备工作1...

NLS_LANG Parameter Fundamentals A locale is a setof information addressing linguistic and cultural requirements that correspondsto a given language and country. Traditionally, the data ...

SELECT B.TABLE_NAME, C.COLUMN_NAME,C.POSITIONFROM USER_CONSTRAINTS A,USER_CONSTRAINTS B,USER_CONS_COLUMNS CWHEREA.CONSTRAINT_NAME=B.R_CONSTRAINT_NAMEAND A.TABLE_NAME = C.TABLE_NAMEANDA.CONSTRAINT...

默认情况下exp/expdp 导出的时候 是针对当前表的一致性读在导入的时候经常遇到: 1ORA-02298: cannot validate  - parent keys not found是因为主表和子表不一致引起的2 ORA-00001 uniqu...

Undo LifetimeUndo information has different states during it’s lifecycle, depending onrunning transactions and retention settings.There are three states or types of extents in the Undo tablespac...

Oracle Server - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]Information in this document applies to any platform.***Checked for relevance on 26-Feb-2009***GOALThis goal wal...

1)  安装备库服务器oracle 软件 略2)  配置主库服务器和备库服务器网络[root@db11g01 ~]# more/etc/hosts# Do not remove the followingline, or various programs# that r...

Error:    RMAN 6217 (RMAN-06217 RMAN-6217)Text:    not connected to auxiliary database with a net service name------------------------------------------------------------...

APPLIES TO:Oracle Server - Enterprise Edition - Version 9.2.0.8 to 11.2.0.3 [Release 9.2 to 11.2]Information in this document applies to any platform.GOALThis article deals with monitoring and tuning ...

Troubleshooting Data GuardIn my last section on Data Guard we are going to cover troubleshooting, I cover common issues and resolutions regarding the configuration and maintainance of a Data Guard env...

ORION简介ORION (Oracle I/O Calibration Tool) 是校准用于 Oracle 数据库的存储系统 I/O 性能的独立工具。校准结果对于了解存储系统的性能有很大帮助，不仅可以找出影响 Oracle 数据库性能的问题，还能测量新数据...

Truncatetable 或者 drop table 收缩数据文件,经常遇到ORA-03297: file contains used data beyondrequested RESIZE value 查询dba_free_space也有空闲空间。经过查询MOS(Doc ID 1029252.6)得知If you ha...