12 2019 档案

Partition Fast Split 不起作用时应检查的内容 (Doc ID 378138.1)
摘要：What to Check When Partition Fast Split does Not Appear Working (Doc ID 378138.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 9.2.0.7 a 阅读全文
posted @ 2019-12-31 10:36 ZYLONG-SYS 阅读(176) 评论(0) 推荐(0)
How to Perform a FAST SPLIT PARTITION Using ALTER TABLE? (Doc ID 1268714.1)
摘要：APPLIES TO: Oracle Database - Enterprise Edition - Version 10.2.0.3 and laterOracle Database Cloud Schema Service - Version N/A and laterOracle Databa 阅读全文
posted @ 2019-12-30 17:06 ZYLONG-SYS 阅读(422) 评论(0) 推荐(0)
How To Resolve Stranded DBA_2PC_PENDING Entries [ID 401302.1]
摘要：How To Resolve Stranded DBA_2PC_PENDING Entries [ID 401302.1] Applies to: Oracle Server - Enterprise Edition - Version: 8.1.5.0 to 11.1.0.6 - Release: 阅读全文
posted @ 2019-12-24 17:05 ZYLONG-SYS 阅读(1166) 评论(0) 推荐(0)
盘点 Oracle 11g 中新特性带来的10大性能影响
摘要：转自 https://mp.weixin.qq.com/s?__biz=MjM5MDAxOTk2MQ==&mid=2650275500&idx=1&sn=84bc12fea2b88a92162117ab95a52954&chksm=be4866ba893fefac19fd7abb984057be31 阅读全文
posted @ 2019-12-20 17:03 ZYLONG-SYS 阅读(923) 评论(0) 推荐(0)
史上最全Oracle数据泵常用命令
摘要：本文转自https://blog.csdn.net/Enmotech/article/details/102848825 墨墨导读：expdp和impdp是oracle数据库之间移动数据的工具，本文简单总结了数据泵的常用命令，希望对大家有帮助。 前言 expdp和impdp是oracle数据库之间移 阅读全文
posted @ 2019-12-19 16:20 ZYLONG-SYS 阅读(2763) 评论(0) 推荐(0)
Oracle查看 open_cursors 和 session_cached_cursors
摘要：本文转自 http://blog.itpub.net/25583515/viewspace-2152997/ 查看当前session已使用的最大open cursor数 和cached cursor数： SELECT 'session_cached_cursors' PARAMETER, LPAD 阅读全文
posted @ 2019-12-18 14:14 ZYLONG-SYS 阅读(1510) 评论(0) 推荐(0)
SLES 12: Database Startup Error with ORA-27300 ORA-27301 ORA-27303 While Starting using Srvctl (Doc ID 2340986.1)
摘要：SLES 12: Database Startup Error with ORA-27300 ORA-27301 ORA-27303 While Starting using Srvctl (Doc ID 2340986.1) APPLIES TO: Oracle Database - Enterp 阅读全文
posted @ 2019-12-17 14:33 ZYLONG-SYS 阅读(709) 评论(0) 推荐(0)
FAQ: Oracle Flex ASM 12c / 12.1 (Doc ID 1573137.1)
摘要：FAQ: Oracle Flex ASM 12c / 12.1 (Doc ID 1573137.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]Oracl 阅读全文
posted @ 2019-12-15 15:25 ZYLONG-SYS 阅读(535) 评论(0) 推荐(0)
Test Case:: 12C ASM New feature (Doc ID 1571975.1)
摘要：Test Case:: 12C ASM New feature (Doc ID 1571975.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterInformation in this do 阅读全文
posted @ 2019-12-15 14:57 ZYLONG-SYS 阅读(414) 评论(0) 推荐(0)
Test Case:: 12C ASMCMD New feature (Doc ID 1589249.1)
摘要：Test Case:: 12C ASMCMD New feature (Doc ID 1589249.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterInformation in this 阅读全文
posted @ 2019-12-15 14:26 ZYLONG-SYS 阅读(327) 评论(0) 推荐(0)
如何在Oracle 12C中Drop/Truncate多个分区 (Doc ID 1482264.1)
摘要：How to Drop/Truncate Multiple Partitions in Oracle 12C (Doc ID 1482264.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and late 阅读全文
posted @ 2019-12-15 14:07 ZYLONG-SYS 阅读(2843) 评论(0) 推荐(0)
如何在Oracle 12C中添加多个分区 (Doc ID 1482456.1)
摘要：How to Add Multiple Partitions in Oracle 12C (Doc ID 1482456.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Da 阅读全文
posted @ 2019-12-15 13:52 ZYLONG-SYS 阅读(1022) 评论(0) 推荐(0)
12c分区增强功能，新功能（文档ID 1568010.1）
摘要：12c Partitioning Enhancements, New Features (Doc ID 1568010.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Dat 阅读全文
posted @ 2019-12-15 13:41 ZYLONG-SYS 阅读(560) 评论(0) 推荐(0)
Data Guard：Oracle 12c –新增和更新的功能 (Doc ID 1558256.1)
摘要：Data Guard: Oracle 12c – New and updated Features (Doc ID 1558256.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [ 阅读全文
posted @ 2019-12-15 13:19 ZYLONG-SYS 阅读(425) 评论(0) 推荐(0)
Creating a Physical Standby from Primary on Version 12c (Doc ID 1570958.1)
摘要：Creating a Physical Standby from Primary on Version 12c (Doc ID 1570958.1) APPLIES TO: Oracle Database Cloud Schema Service - Version N/A and laterOra 阅读全文
posted @ 2019-12-15 13:10 ZYLONG-SYS 阅读(269) 评论(0) 推荐(0)
12C新功能：在线移动分区 (Doc ID 1584032.1)
摘要：12C New Feature: Online Move Partition (Doc ID 1584032.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Database 阅读全文
posted @ 2019-12-15 12:53 ZYLONG-SYS 阅读(281) 评论(0) 推荐(0)
RMAN RECOVER TABLE 功能是 Oracle Database 12c 的新增功能 (Doc ID 1521524.1)
摘要：RMAN RECOVER TABLE Feature New to Oracle Database 12c (Doc ID 1521524.1) APPLIES TO: Oracle Database Cloud Schema Service - Version N/A and laterOracl 阅读全文
posted @ 2019-12-15 12:45 ZYLONG-SYS 阅读(652) 评论(0) 推荐(0)
12C新功能：在线移动数据文件 (Doc ID 1566797.1)
摘要：12C New Feature : Move a Datafile Online (Doc ID 1566797.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Databa 阅读全文
posted @ 2019-12-15 12:31 ZYLONG-SYS 阅读(547) 评论(0) 推荐(0)
How To Convert A Partitioned Table To A Non-Partitioned Table Using DataPump In 11g (Doc ID 1276049.1)
摘要：How To Convert A Partitioned Table To A Non-Partitioned Table Using DataPump In 11g (Doc ID 1276049.1) APPLIES TO: Oracle Database Exadata Cloud Machi 阅读全文
posted @ 2019-12-15 11:38 ZYLONG-SYS 阅读(1099) 评论(0) 推荐(0)
12.2新特性 使用DBCA duplicate创建物理备用数据库 (Doc ID 2283697.1)
摘要：Creating a Physical Standby database using DBCA duplicate (Doc ID 2283697.1) APPLIES TO: Oracle Database Cloud Exadata Service - Version N/A and later 阅读全文
posted @ 2019-12-15 11:01 ZYLONG-SYS 阅读(499) 评论(0) 推荐(0)
Data Guard Physical Standby - RAC Primary to RAC Standby 使用第二个网络 (Doc ID 1349977.1)
摘要：Data Guard Physical Standby - RAC Primary to RAC Standby using a second network (Doc ID 1349977.1) APPLIES TO: Oracle Database - Enterprise Edition - 阅读全文
posted @ 2019-12-15 01:01 ZYLONG-SYS 阅读(756) 评论(0) 推荐(0)
使用Active Database Duplication创建跨平台Data Guard设置 (Windows/Linux) (Doc ID 881421.1)
摘要：Using Active Database Duplication to Create Cross Platform Data Guard Setup (Windows/Linux) (Doc ID 881421.1) APPLIES TO: Oracle Database Cloud Exadat 阅读全文
posted @ 2019-12-14 23:52 ZYLONG-SYS 阅读(489) 评论(0) 推荐(0)
12.2 中的Data Guard Standby 密码文件自动同步 (Doc ID 2307365.1)
摘要：Data Guard Standby Automatic Password file Synchronization in 12.2 (Doc ID 2307365.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.2. 阅读全文
posted @ 2019-12-14 23:36 ZYLONG-SYS 阅读(615) 评论(0) 推荐(0)
使用Data Guard迁移到RAC (Doc ID 273015.1)
摘要：Migrating to RAC using Data Guard (Doc ID 273015.1) APPLIES TO: Oracle Database Cloud Exadata Service - Version N/A and laterOracle Database Cloud Ser 阅读全文
posted @ 2019-12-14 23:10 ZYLONG-SYS 阅读(456) 评论(0) 推荐(0)
如何计算Data Guard环境中Redo所需的网络带宽传输 (Doc ID 736755.1)
摘要：How To Calculate The Required Network Bandwidth Transfer Of Redo In Data Guard Environments (Doc ID 736755.1) APPLIES TO: Oracle Database - Enterprise 阅读全文
posted @ 2019-12-14 22:36 ZYLONG-SYS 阅读(735) 评论(0) 推荐(0)
18c & 19c Physical Standby Switchover Best Practices using SQL*Plus (Doc ID 2485237.1)
摘要：18c & 19c Physical Standby Switchover Best Practices using SQL*Plus (Doc ID 2485237.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 18.3 阅读全文
posted @ 2019-12-14 19:35 ZYLONG-SYS 阅读(569) 评论(0) 推荐(0)
12c Data guard Switchover Best Practices using SQLPLUS (Doc ID 1578787.1)
摘要：12c Data guard Switchover Best Practices using SQLPLUS (Doc ID 1578787.1) APPLIES TO: Oracle Database Backup Service - Version N/A and laterOracle Dat 阅读全文
posted @ 2019-12-14 19:00 ZYLONG-SYS 阅读(2062) 评论(0) 推荐(0)
11.2 Data Guard Physical Standby Switchover Best Practices using SQL*Plus (Doc ID 1304939.1)
摘要：11.2 Data Guard Physical Standby Switchover Best Practices using SQL*Plus (Doc ID 1304939.1) APPLIES TO: Oracle Database - Enterprise Edition - Versio 阅读全文
posted @ 2019-12-14 18:26 ZYLONG-SYS 阅读(687) 评论(0) 推荐(0)
经典案例：如何优化Oracle使用DBlink的SQL语句
摘要：转自 https://blog.csdn.net/Enmotech/article/details/78788083 作者介绍 赵全文 就职于太极计算机股份有限公司,在中央电化教育馆做Oracle DBA的驻场运维工作。具有3年左右的Oracle工作经验，目前擅长Oracle数据库的SQL脚本编写、 阅读全文
posted @ 2019-12-13 13:08 ZYLONG-SYS 阅读(1559) 评论(0) 推荐(0)
跨平台版本迁移之 XTTS 方案操作指南
摘要：本文转自 https://blog.csdn.net/Enmotech/article/details/80045576 作者 | 罗贵林： 云和恩墨技术工程师，具有8年以上的 Oracle 数据库工作经验，曾任职于大型的国家电信、省级财政、省级公安的维护，性能调优等。精通 Oracle 数据库管理 阅读全文
posted @ 2019-12-13 10:06 ZYLONG-SYS 阅读(5669) 评论(0) 推荐(0)
XTTS Creates Alias on Destination when Source and Destination use ASM (Doc ID 2351123.1)
摘要：XTTS Creates Alias on Destination when Source and Destination use ASM (Doc ID 2351123.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 11 阅读全文
posted @ 2019-12-12 15:42 ZYLONG-SYS 阅读(488) 评论(0) 推荐(0)
Step by Step Process of Migrating non-CDBs and PDBs Using ASM for File Storage (Doc ID 1576755.1)
摘要：Step by Step Process of Migrating non-CDBs and PDBs Using ASM for File Storage (Doc ID 1576755.1) APPLIES TO: Oracle Database - Enterprise Edition - V 阅读全文
posted @ 2019-12-11 11:19 ZYLONG-SYS 阅读(1447) 评论(0) 推荐(0)
V4 Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 2471245.1)
摘要：V4 Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 2471245.1) APPLIES TO: Oracle Database Cloud Schema Servic 阅读全文
posted @ 2019-12-10 22:30 ZYLONG-SYS 阅读(947) 评论(0) 推荐(0)
12C-使用跨平台增量备份减少可移动表空间的停机时间 (Doc ID 2005729.1)
摘要：12C - Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 2005729.1) APPLIES TO: Oracle Database - Enterprise Edi 阅读全文
posted @ 2019-12-10 22:22 ZYLONG-SYS 阅读(572) 评论(0) 推荐(0)
11G-使用跨平台增量备份减少可移动表空间的停机时间 XTTS (Doc ID 1389592.1)
摘要：11G - Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 1389592.1) APPLIES TO: Oracle Database Cloud Exadata Se 阅读全文
posted @ 2019-12-10 15:56 ZYLONG-SYS 阅读(1007) 评论(0) 推荐(0)
如何在asm上定位数据块
摘要：转自 https://blogs.oracle.com/database4cn/%e5%a6%82%e4%bd%95%e5%9c%a8asm%e4%b8%8a%e5%ae%9a%e4%bd%8d%e6%95%b0%e6%8d%ae%e5%9d%97 我们都知道当db使用传统的文件系统时，定位bloc 阅读全文
posted @ 2019-12-10 13:25 ZYLONG-SYS 阅读(503) 评论(0) 推荐(0)
log file switch (checkpoint incomplete) - 容易被误诊的event
摘要：本文转自 https://blogs.oracle.com/database4cn/log-file-switch-checkpoint-incomplete-%e5%ae%b9%e6%98%93%e8%a2%ab%e8%af%af%e8%af%8a%e7%9a%84event 首先来看如下的一份A 阅读全文
posted @ 2019-12-10 12:54 ZYLONG-SYS 阅读(3344) 评论(0) 推荐(0)
12c新特性 在线操作数据文件
摘要：我们都知道，oracle pre-12c之前，若是想要把一个数据文件改名或者迁移， 必须在归档模式下先把这个数据文件offline之后， 然后进行OS上的copy或者rename 操作， 最后在sqlplus里面进行alter database rename file x to Y; 如果不是arc 阅读全文
posted @ 2019-12-10 12:35 ZYLONG-SYS 阅读(384) 评论(0) 推荐(0)
Oracle ASM无法识别扩展分区的磁盘设备
摘要：在linux 环境下，我们一般通过udev或者asmlib来绑定磁盘分区作为ASM的候选存储单元。在使用udev的情况下，一般只要我们可以看到被绑定的磁盘的设备，并且这些设备的属主和权限没有问题，ASM就可以识别并使用这些设备了。 但是也有例外情况： 1. 首先观察到的现象：在ASMCA的“"sho 阅读全文
posted @ 2019-12-10 12:27 ZYLONG-SYS 阅读(798) 评论(0) 推荐(0)
如何使用coe_load_sql_profile.sql来固定sql profile
摘要：SQLT工具包含一个脚本，名字是 coe_load_sql_profile.sql,下面以用户SCOTT的EMP表为例，说明如何使用该脚本固定sql profile. 1. SQL> -- 对emp的列ename创建一个索引 SQL> create index i_emp_ename on scot 阅读全文
posted @ 2019-12-10 11:23 ZYLONG-SYS 阅读(1208) 评论(0) 推荐(0)
如何从 ASH 找到消耗 PGA 和 临时表空间 较多的 Top SQL_ID (Doc ID 2610646.1)
摘要：如何从 ASH 找到消耗 PGA 和 临时表空间 较多的 Top SQL_ID (Doc ID 2610646.1) 适用于: Oracle Database - Enterprise Edition - 版本 11.2.0.1 和更高版本本文档所含信息适用于所有平台 目标 提供一些诊断脚本，用于从 阅读全文
posted @ 2019-12-10 11:06 ZYLONG-SYS 阅读(370) 评论(0) 推荐(0)
使用可移动表空间(TTS)的最佳做法 (Doc ID 1457876.1)
摘要：Best Practices for Using Transportable Tablespaces (TTS) (Doc ID 1457876.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 9.2.0.1 to 12.1 阅读全文
posted @ 2019-12-10 10:55 ZYLONG-SYS 阅读(493) 评论(0) 推荐(0)
How to Create Transportable Tablespaces Where the Source and Destination are ASM-Based (Doc ID 394798.1)
摘要：How to Create Transportable Tablespaces Where the Source and Destination are ASM-Based (Doc ID 394798.1) APPLIES TO: Oracle Database - Enterprise Edit 阅读全文
posted @ 2019-12-09 23:07 ZYLONG-SYS 阅读(319) 评论(0) 推荐(0)
10g+: Transportable Tablespaces Across Different Platforms (Doc ID 243304.1)
摘要：10g+: Transportable Tablespaces Across Different Platforms (Doc ID 243304.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12 阅读全文
posted @ 2019-12-09 21:48 ZYLONG-SYS 阅读(373) 评论(0) 推荐(0)
LogMiner Utility Release 8i - 11g (Doc ID 291686.1)
摘要：LogMiner Utility Release 8i - 11g (Doc ID 291686.1) APPLIES TO: Oracle Database Exadata Cloud Machine - Version N/A and laterOracle Cloud Infrastructu 阅读全文
posted @ 2019-12-09 15:50 ZYLONG-SYS 阅读(568) 评论(0) 推荐(0)
How To Determine The Cause Of Lots Of Redo Generation Using LogMiner (Doc ID 300395.1)
摘要：How To Determine The Cause Of Lots Of Redo Generation Using LogMiner (Doc ID 300395.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 8.1. 阅读全文
posted @ 2019-12-09 13:04 ZYLONG-SYS 阅读(349) 评论(0) 推荐(0)
如何通过RMAN使用传输表空间迁移到不同的Endian平台 (Doc ID 371556.1)
摘要：How to Migrate to different Endian Platform Using Transportable Tablespaces With RMAN (Doc ID 371556.1) APPLIES TO: Oracle Database - Enterprise Editi 阅读全文
posted @ 2019-12-08 23:16 ZYLONG-SYS 阅读(948) 评论(0) 推荐(0)
如何使用 TRANSPORTABLE = ALWAYS 将PDB移回Non-CDB (Doc ID 2027352.1)
摘要：How to Move a PDB Back to a Non-CDB Using TRANSPORTABLE=ALWAYS (Doc ID 2027352.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 阅读全文
posted @ 2019-12-08 22:15 ZYLONG-SYS 阅读(661) 评论(0) 推荐(0)
Transportable tablespace on standby (Doc ID 788176.1)
摘要：APPLIES TO: Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]Oracle Database - Enterprise Edition - Version 10.2.0.5 阅读全文
posted @ 2019-12-08 21:58 ZYLONG-SYS 阅读(287) 评论(0) 推荐(0)
Master Note for Transportable Tablespaces (TTS) -- Common Questions and Issues (Doc ID 1166564.1)
摘要：APPLIES TO: Oracle Database Cloud Exadata Service - Version N/A and laterOracle Database Cloud Service - Version N/A and laterOracle Database - Enterp 阅读全文
posted @ 2019-12-08 21:32 ZYLONG-SYS 阅读(1429) 评论(0) 推荐(0)
如何使用块更改跟踪文件估算RMAN增量备份大小 (Doc ID 1938079.1)
摘要：How to estimate RMAN incremental backup size using block change tracking file (Doc ID 1938079.1) APPLIES TO: Oracle Database - Enterprise Edition - Ve 阅读全文
posted @ 2019-12-08 17:54 ZYLONG-SYS 阅读(418) 评论(0) 推荐(0)
缺少控制文件备份时如何还原数据库 (Doc ID 1438776.1)
摘要：How to restore database when controlfile backup missing (Doc ID 1438776.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 9.2.0.1 and late 阅读全文
posted @ 2019-12-08 16:51 ZYLONG-SYS 阅读(412) 评论(0) 推荐(0)
如何将RAC数据库的 RMAN Disk 备份 Restore 到另一个节点上的单个实例 (Doc ID 415579.1)
摘要：HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another Node (Doc ID 415579.1) APPLIES TO: Oracle Database - Enterprise Edition 阅读全文
posted @ 2019-12-08 16:33 ZYLONG-SYS 阅读(547) 评论(0) 推荐(0)
TSPITR fails With RMAN-06553 (Doc ID 2078790.1)
摘要：TSPITR fails With RMAN-06553 (Doc ID 2078790.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Cloud Sch 阅读全文
posted @ 2019-12-08 15:53 ZYLONG-SYS 阅读(336) 评论(0) 推荐(0)
使用 TSPITR 恢复删除的表空间的步骤 (Doc ID 1277795.1)
摘要：Steps To Recover A Dropped Tablespace Using TSPITR (Doc ID 1277795.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInf 阅读全文
posted @ 2019-12-08 10:33 ZYLONG-SYS 阅读(363) 评论(0) 推荐(0)
在没有备份的情况下重新创建丢失的数据文件 (Doc ID 1149946.1)
摘要：Recreating a missing datafile with no backups (Doc ID 1149946.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 10.2.0.2 and laterInformat 阅读全文
posted @ 2019-12-08 10:22 ZYLONG-SYS 阅读(341) 评论(0) 推荐(0)
How to recover a skipped tablespace after an incomplete recovery? (Doc ID 1561645.1)
摘要：How to recover a skipped tablespace after an incomplete recovery? (Doc ID 1561645.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0 阅读全文
posted @ 2019-12-08 07:54 ZYLONG-SYS 阅读(403) 评论(0) 推荐(0)
RMAN DUPLICATE DATABASE with SET NEWNAME failed: RMAN-05501 RMAN-05517 (Doc ID 387093.1)
摘要：RMAN DUPLICATE DATABASE with SET NEWNAME failed: RMAN-05501 RMAN-05517 (Doc ID 387093.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 10 阅读全文
posted @ 2019-12-07 21:36 ZYLONG-SYS 阅读(725) 评论(0) 推荐(0)
RMAN 'Duplicate From Active Database' Feature in Oracle11g (Doc ID 452868.1)
摘要：RMAN 'Duplicate From Active Database' Feature in Oracle11g (Doc ID 452868.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 11.1.0.6 and l 阅读全文
posted @ 2019-12-07 14:51 ZYLONG-SYS 阅读(576) 评论(0) 推荐(0)
Rman Enhancements(增强) In Oracle 11g. (Doc ID 1115423.1)
摘要：Rman Enhancements In Oracle 11g. (Doc ID 1115423.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 1 阅读全文
posted @ 2019-12-07 14:26 ZYLONG-SYS 阅读(407) 评论(0) 推荐(0)
Resolving RMAN-06023 or RMAN-06025 (Doc ID 2038119.1)
摘要：Resolving RMAN-06023 or RMAN-06025 (Doc ID 2038119.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 9.0.1.0 to 12.1.0.2 [Release 9.0.1 to 阅读全文
posted @ 2019-12-07 13:05 ZYLONG-SYS 阅读(703) 评论(0) 推荐(0)
Checklist for an RMAN Restore (Doc ID 1554636.1)
摘要：Checklist for an RMAN Restore (Doc ID 1554636.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 10.2.0.1 and laterOracle Database Cloud Sc 阅读全文
posted @ 2019-12-07 10:10 ZYLONG-SYS 阅读(582) 评论(0) 推荐(0)
Recover With Until Time fails With RMAN-20207 When Time Is Before Last RESETLOGS (Doc ID 159405.1)
摘要：Recover With Until Time fails With RMAN-20207 When Time Is Before Last RESETLOGS (Doc ID 159405.1) APPLIES TO: Oracle Database Exadata Cloud Machine - 阅读全文
posted @ 2019-12-06 11:05 ZYLONG-SYS 阅读(766) 评论(0) 推荐(0)
ODA: After Apply ODA 12.2.1.2.0 Patch, Unable to Create TableSpace Due to [ORA-15001: diskgroup "DATA" does not exist or is not mounted | ORA-15040: diskgroup is incomplete] (Doc ID 2375553.1)
摘要：ODA: After Apply ODA 12.2.1.2.0 Patch, Unable to Create TableSpace Due to [ORA-15001: diskgroup "DATA" does not exist or is not mounted | ORA-15040: d 阅读全文
posted @ 2019-12-05 22:42 ZYLONG-SYS 阅读(1183) 评论(0) 推荐(0)
How to restore and recover a database from an RMAN backup. (Doc ID 881395.1)
摘要：APPLIES TO: Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]Oracle Database - Enterprise Edition - Version 1 阅读全文
posted @ 2019-12-05 17:41 ZYLONG-SYS 阅读(496) 评论(0) 推荐(0)
How To Restore Rman Backups On A Different Node When The Directory Structures Are Different (Doc ID 419137.1)
摘要：How To Restore Rman Backups On A Different Node When The Directory Structures Are Different (Doc ID 419137.1) APPLIES TO: Oracle Database - Enterprise 阅读全文
posted @ 2019-12-05 17:01 ZYLONG-SYS 阅读(401) 评论(0) 推荐(0)
start_udev 是不是会写磁盘头
摘要：遇到一个案例，在这里记录一下 一套Oracle 11.2.0.4 RAC环境，操作系统是RHEL 6.5，共享磁盘是通过UDEV实现RAW绑定设备名，如下 [root@rac1 opt]# ll /dev/sd* brw-rw . 1 root disk 8, 0 Dec 2 20:26 /dev/ 阅读全文
posted @ 2019-12-04 22:39 ZYLONG-SYS 阅读(1507) 评论(0) 推荐(0)
如何获取数据泵dm和dw进程的 Strace (Doc ID 1411563.1)
摘要：How To Get A Strace Of The Data Pump dm And dw Process(es) (Doc ID 1411563.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 10.1.0.2 and 阅读全文
posted @ 2019-12-04 21:05 ZYLONG-SYS 阅读(1002) 评论(0) 推荐(0)
Oracle 统计表空间和对象历史增长量
摘要：最近7天内 每天(某个)表空间的增长量 col TS_NAME for a15 SELECT a.snap_id, a.rtime, c.tablespace_name ts_name, round(a.tablespace_size * c.block_size / 1024 / 1024 / 1 阅读全文
posted @ 2019-12-04 17:36 ZYLONG-SYS 阅读(3849) 评论(0) 推荐(1)
如何获取表增长历史记录信息? (Doc ID 1395195.1)
摘要：How To Get Table Growth History Information? (Doc ID 1395195.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.1.0.2 [Relea 阅读全文
posted @ 2019-12-04 10:54 ZYLONG-SYS 阅读(417) 评论(0) 推荐(0)
示例：Oracle表锁、行锁模拟和处理
摘要：for update模拟锁表 --session 1 SQL> select * from tt for update; --session 2 SQL> update tt set id=1 where id=2; 按用户查询锁的情况 set line 300 col OBJECT_NAME fo 阅读全文
posted @ 2019-12-04 10:14 ZYLONG-SYS 阅读(2754) 评论(1) 推荐(0)
How to Check Device UUID or File System UUID. (Doc ID 1505398.1)
摘要：How to Check Device UUID or File System UUID. (Doc ID 1505398.1) APPLIES TO: Linux OS - Version Oracle Linux 5.0 and laterOracle Cloud Infrastructure 阅读全文
posted @ 2019-12-03 10:02 ZYLONG-SYS 阅读(303) 评论(0) 推荐(0)
Under what conditions should the 'start_udev' command be run?
摘要：环境 Red Hat Enterprise Linux 问题 We run start_udev as part of the storage allocation procedure that we have. It works, but it can be disruptive if an or 阅读全文
posted @ 2019-12-03 08:40 ZYLONG-SYS 阅读(477) 评论(0) 推荐(0)
更改 undo_retention 时，Lob retention 不更改 (Doc ID 563470.1)
摘要：Lob retention not changing when undo_retention is changed (Doc ID 563470.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 8.1.7.4 to 10.2 阅读全文
posted @ 2019-12-01 11:05 ZYLONG-SYS 阅读(1384) 评论(0) 推荐(0)
Export Receives The Errors ORA-1555 ORA-22924 ORA-1578 ORA-22922 (Doc ID 787004.1)
摘要：Export Receives The Errors ORA-1555 ORA-22924 ORA-1578 ORA-22922 (Doc ID 787004.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.2 阅读全文
posted @ 2019-12-01 11:01 ZYLONG-SYS 阅读(585) 评论(0) 推荐(0)
Data Pump Export 数据泵导出因ORA-31693 ORA-02354 和 ORA-01555 错误且没有LOB损坏而失败 (Doc ID 1507116.1)
摘要：Data Pump Export Fails With ORA-31693 ORA-02354 and ORA-01555 Errors And No LOB Corruption (Doc ID 1507116.1) APPLIES TO: Oracle Database Cloud Schema 阅读全文
posted @ 2019-12-01 10:59 ZYLONG-SYS 阅读(924) 评论(0) 推荐(0)
Undo 相关的等待事件和已知问题 (Doc ID 1575701.1)
摘要：Undo Related Wait Events & Known Issues (Doc ID 1575701.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 9.2.0.8 to 11.2.0.4 [Release 9.2 阅读全文
posted @ 2019-12-01 10:57 ZYLONG-SYS 阅读(1127) 评论(0) 推荐(0)
Master Note: Undo 空间使用率高 (Doc ID 1578639.1)
摘要：Master Note: High Undo Space Usage (Doc ID 1578639.1) APPLIES TO: Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata 阅读全文
posted @ 2019-12-01 10:45 ZYLONG-SYS 阅读(931) 评论(0) 推荐(0)
Automatic Tuning of Undo Retention 常见问题 (Doc ID 1579779.1)
摘要：Automatic Tuning of Undo Retention Common Issues (Doc ID 1579779.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [R 阅读全文
posted @ 2019-12-01 09:42 ZYLONG-SYS 阅读(1017) 评论(0) 推荐(0)
FAQ – Automatic Undo Management (AUM) / System Managed Undo (SMU) (Doc ID 461480.1)
摘要：FAQ – Automatic Undo Management (AUM) / System Managed Undo (SMU) (Doc ID 461480.1) APPLIES TO: Oracle Database - Enterprise Edition - Version 9.0.1.4 阅读全文
posted @ 2019-12-01 00:14 ZYLONG-SYS 阅读(544) 评论(0) 推荐(0)