摘要：
我们都知道，oracle pre-12c之前，若是想要把一个数据文件改名或者迁移， 必须在归档模式下先把这个数据文件offline之后， 然后进行OS上的copy或者rename 操作， 最后在sqlplus里面进行alter database rename file x to Y; 如果不是arc
阅读全文
posted @ 2019-12-10 12:35
ZYLONG-SYS
阅读(382)
推荐(0)
摘要：
在linux 环境下，我们一般通过udev或者asmlib来绑定磁盘分区作为ASM的候选存储单元。在使用udev的情况下，一般只要我们可以看到被绑定的磁盘的设备，并且这些设备的属主和权限没有问题，ASM就可以识别并使用这些设备了。 但是也有例外情况： 1. 首先观察到的现象：在ASMCA的“"sho
阅读全文
posted @ 2019-12-10 12:27
ZYLONG-SYS
阅读(798)
推荐(0)
摘要：
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
阅读(1201)
推荐(0)
摘要：
如何从 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
阅读(366)
推荐(0)
摘要：
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)
摘要：
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
阅读(318)
推荐(0)
摘要：
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
阅读(370)
推荐(0)
摘要：
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
阅读(562)
推荐(0)
摘要：
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
阅读(343)
推荐(0)
摘要：
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
阅读(946)
推荐(0)
摘要：
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
阅读(660)
推荐(0)
摘要：
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)
摘要：
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
阅读(1425)
推荐(0)
摘要：
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
阅读(417)
推荐(0)
摘要：
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
阅读(409)
推荐(0)
摘要：
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
阅读(541)
推荐(0)
摘要：
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
阅读(335)
推荐(0)
摘要：
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
阅读(357)
推荐(0)
摘要：
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
阅读(340)
推荐(0)
摘要：
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
阅读(401)
推荐(0)
摘要：
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
阅读(724)
推荐(0)
摘要：
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
阅读(575)
推荐(0)
摘要：
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
阅读(405)
推荐(0)
摘要：
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
阅读(701)
推荐(0)
摘要：
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
阅读(573)
推荐(0)
摘要：
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
阅读(764)
推荐(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: d
阅读全文
posted @ 2019-12-05 22:42
ZYLONG-SYS
阅读(1181)
推荐(0)
摘要：
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
阅读(494)
推荐(0)
摘要：
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
阅读(399)
推荐(0)
摘要：
遇到一个案例，在这里记录一下 一套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
阅读(1506)
推荐(0)
摘要：
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
阅读(999)
推荐(0)
摘要：
最近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
阅读(3829)
推荐(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
阅读(416)
推荐(0)
摘要：
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
阅读(2752)
推荐(0)
摘要：
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
阅读(300)
推荐(0)
摘要：
环境 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
阅读(473)
推荐(0)
摘要：
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
阅读(1364)
推荐(0)
摘要：
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
阅读(582)
推荐(0)
摘要：
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
阅读(919)
推荐(0)
摘要：
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
阅读(1122)
推荐(0)
浙公网安备 33010602011771号