RAC – 第 2 页 – 技术博客

某系统数据库故障诊断

某物流系统数据库故障诊断 – Fiyo – ITeye博客故障现象：某物流公司新上一套软件系统，数据库CPU占用率基本维持在80%以上，业务高峰期数据库宕机。知识预览： LGWR什么时候开始工作的,触发他的动作...

Posted in RAC, 性能优化 on 2026-04-14 | 阅读全文

本机SQLPLUS 的时候报错 ORA-12547: TNS: lost contact-tolywang-ITPUB博客

# $ relink oracle 即可。具体原因： Veirfy that your LIBPATH also includes $ORACLE_HOME/lib and relink the oracle software. Shu...

Posted in Linux/AIX, Oracle, RAC on 2026-04-12 | 阅读全文

有关Oracle SCN知识点的整理

1 BLOG文档结构图 ![1756815324270-016f069a-4147-4026-b2ea-caae4261f29c.jpg](http://images2015.cnblogs.com/blog/646850/201610/6...

Posted in Oracle, RAC, RMAN on 2026-04-10 | 阅读全文

无标题_17

Startup ** 1. Ensure that you are logged in as the _root _Linux/ UNIX user. If you are not connected as root OS user, yo...

Posted in ASM, GoldenGate, Linux/AIX, Oracle, RAC on 2026-04-03 | 阅读全文

无标题_15

客户的SYSAUX表空间和对应的数据文件都完全脱机，且归档已经不存在，没办法执行物理级别的恢复。使用TTS迁移也行不通，因为exp和expdp导出元数据会报错；使用expdp、exp按照tablespace、schema导出也行不通，同样会...

Posted in Oracle, RAC, RMAN on 2026-03-31 | 阅读全文

无标题_14

Oracle物化视图日志：如果需要进行快速刷新，则需要建立物化视图日志。Oracle物化视图日志根据不同物化视图的快速刷新的需要，可以建立为ROWID或PRIMARY KEY类型的。还可以选择是否包括SEQUENCE、INCLUDING N...

Posted in Oracle, RAC on 2026-03-29 | 阅读全文

文档 1641136.1

| | ## Applies to: Oracle Database – Enterprise Edition – Version 11.2.0.4 to 11.2.0.4 [Release 11.2] Inform...

Posted in Data Guard, Oracle, RAC, 性能优化 on 2026-02-27 | 阅读全文

文档 1626301.1

用途排错步骤什么是'log file sync'等待事件？用户应该搜集那些信息，来初步分析'log file sync'等待事件？什么原因造成了很高的’log file sync’等待？影响...

Posted in Oracle, RAC, 性能优化 on 2026-02-26 | 阅读全文

文档 1600704.1

Purpose Details ALERTS General Resources Evaluate The Value of Upgrading Plan, Test, Implement Your Upgrade Tools and Di...

Posted in Oracle, RAC on 2026-02-24 | 阅读全文

文档 1362329.1

Goal Collecting Performance Diagnostics with Performance Service Request Diagnostic Collection (SRDC) documents Solution...

Posted in Oracle, RAC, RMAN on 2026-02-22 | 阅读全文

文档 1029252.6

Purpose Scope Details | [============================= Increase Datafile Size =============================](https://sup...

Posted in Oracle, RAC on 2026-02-21 | 阅读全文

文档 854428.1

| | ## Applies to: Oracle Database – Enterprise Edition – Version 12.1.0.2 to 12.1.0.2 [Release 12.1] Inform...

Posted in Oracle, RAC on 2026-02-19 | 阅读全文

文档 733824.1

Goal Solution References Applies to: Oracle Database – Enterprise Edition – Version 10.2.0.1 and later Infor...

Posted in Oracle, RAC, RMAN on 2026-02-17 | 阅读全文

文档 428681.1

Goal Solution Prepare the disks 1. Size 2. For raw or block device (pre 11.2) 3. For ASM disks (11.2+) 4. For cluster fi...

Posted in ASM, Oracle, RAC on 2026-02-15 | 阅读全文

文档 398838.1

Purpose Best Practices Pro-Active Problem Avoidance and Diagnostic Collection Questions and Answers Where is there an Ov...

Posted in Oracle, RAC, RMAN, 性能优化 on 2026-02-14 | 阅读全文

文档 62143.1_1

Purpose Introduction Ask Questions, Get Help, And Share Your Experiences With This Article Troubleshooting Steps What is...

Posted in Oracle, RAC, 性能优化 on 2026-02-12 | 阅读全文

文档 62143.1

Purpose Introduction Ask Questions, Get Help, And Share Your Experiences With This Article Troubleshooting Steps What is...

Posted in Oracle, RAC, 性能优化 on 2026-02-10 | 阅读全文

文档 10626.1

| | Note.29236.1Document 1270930.1 References NOTE:73489.1 – Effect of Number of Tables on Join Order Permutations

Posted in Oracle, RAC on 2026-02-08 | 阅读全文

数据泵使用总结

Posted in Oracle, RAC, RMAN on 2026-02-07 | 阅读全文

数据库：

原文档没有单独处理临时文件 *.db_file_name_convert='+DATA/','/u02/data/'上边是原来参数配置。实际上主库的临时文件的路径应该是+DATA/tempfile/...

Posted in ASM, Data Guard, Oracle, RAC, RMAN on 2026-02-05 | 阅读全文

技术文章列表