Oracle DBA 筆記

教學網站

• Basic Oracle Maintenance Jobs - 基本日常維護的 script，包含
  • Rotate Listener Log
  • Rotate Alert Log
  • Romove Old Files - Trace, etc.
  • Backup Database and Archive Logs, including Deleting Old Logs and Crosschecking Recovery Catalogs/Controlfiles, etc.
  • Gather Object - Table, Index, etc. - Statistics
• 建立資料庫(DBCA)
• 建立 Partitioned Table
• Oracle Shell Scripting
• Database Shink
  1. How to adjust the high watermark in ORACLE 10g – ALTER TABLE SHRINK
  2. Segments Shrink
  3. http://database.51cto.com/art/201108/284425.htm
• Oracle Replication
  1. GoldenGate
  2. Data Replication Using Oracle Downstream Capture
• Data Guard
  
  1. Oracle 10g - Manually Create a Physical Standby Database Using Data Guard
  2. How to setup Active Data Guard in oracle 11gR2
• Database Import & Export
  • imp & exp: Import Export FAQ
  • impdp & expdp: Oracle Data Pump (expdp and impdp) in Oracle Database 10g
• 使 SQL*Plus 可以切換歷史指令及 TAB 指令校正功能 - rlwrap
• Top DBA Shell Scripts for Monitoring the Database
• 許多維護技巧及故障排除 - http://blog.itpub.net/22664653/cid-80392-list-1/
• Oracle 教學
  • http://www.111cn.net/list-111/
• 很多好用的 SQL 腳本
• Swingbench - Stress Test & Benchmark for Oracle 10g
  • http://fecbob.pixnet.net/blog/post/3...B8%AC%E8%A9%A6