2019年12月10日
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 阅读(372) 评论(0) 推荐(0) 编辑
Oracle ASM无法识别扩展分区的磁盘设备
摘要： 在linux 环境下，我们一般通过udev或者asmlib来绑定磁盘分区作为ASM的候选存储单元。在使用udev的情况下，一般只要我们可以看到被绑定的磁盘的设备，并且这些设备的属主和权限没有问题，ASM就可以识别并使用这些设备了。 但是也有例外情况： 1. 首先观察到的现象：在ASMCA的“"sho 阅读全文
posted @ 2019-12-10 12:27 ZYLONG-SYS 阅读(766) 评论(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 阅读(1150) 评论(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 阅读(348) 评论(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 阅读(457) 评论(0) 推荐(0) 编辑
2019年12月9日
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 阅读(309) 评论(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 阅读(357) 评论(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 阅读(524) 评论(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 阅读(330) 评论(0) 推荐(0) 编辑
2019年12月8日
如何通过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 阅读(863) 评论(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 阅读(600) 评论(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 阅读(272) 评论(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 阅读(1366) 评论(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 阅读(387) 评论(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 阅读(374) 评论(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 阅读(476) 评论(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 阅读(320) 评论(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 阅读(336) 评论(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 阅读(323) 评论(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 阅读(342) 评论(0) 推荐(0) 编辑
2019年12月7日
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 阅读(672) 评论(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 阅读(525) 评论(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 阅读(394) 评论(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 阅读(652) 评论(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 阅读(543) 评论(0) 推荐(0) 编辑
2019年12月6日
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 阅读(725) 评论(0) 推荐(0) 编辑
2019年12月5日
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 阅读(1161) 评论(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 阅读(472) 评论(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 阅读(373) 评论(0) 推荐(0) 编辑
2019年12月4日
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 阅读(1469) 评论(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 阅读(955) 评论(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 阅读(3325) 评论(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 阅读(389) 评论(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 阅读(2698) 评论(1) 推荐(0) 编辑
2019年12月3日
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 阅读(288) 评论(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 阅读(468) 评论(0) 推荐(0) 编辑
2019年12月1日
更改 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 阅读(1052) 评论(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 阅读(561) 评论(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 阅读(837) 评论(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 阅读(1037) 评论(0) 推荐(0) 编辑