Oracle 9i,10g,11g RDBMS & RAC & DataGuard



This page contains some selected links on Oracle RDBMS 9i,10g,11g and RAC 10g, 11g.
Maybe you need to refresh your cache to see any updates.


SECTION 1: My own notes:

1.1 Short Overviews:

Examples of some often used SQL statements (version 2.4, html)


1.2 Some docs on how to deal with block corruption:


Extremely short note on quick fixing Oracle block corruption (version 0.3, Excel)
Better descriptions on handling Oracle corruption (version 1.1, html)


1.3 Overview RAC:

Simplified Overview of Oracle 10g RAC Architecture (Excel format)
Some notes about Oracle 10g and 11g RAC (txt file)


1.4 Some general subjects:

Listing of some Oracle 10g/11g facts & structures (for exam 1Z0-052, excel format)
Oracle 9i and 10g commands and queries (txt file)
How to view locks and transactions in Oracle 9i,10g,11g (Excel format)
How to investigate events and waits in Oracle 9i,10g,11g (Excel format)
How to setup CDC in Oracle 10g,11g (Excel format)
A few notes on backup and recovery Oracle with RMAN in 9i,10g (Excel format)
Some notes about undocumented Oracle init.ora parameters (txt file)
PLSQL info txt file (txt file)


SECTION 2: Other Documents:

2.1: Technical documents on the Oracle Block (page) architecture:

Header and Tail - Oracle Block format article (1)
Data Block Internals - Oracle Block format article(2)
The Data Block and BBED - Oracle Block format article (3)
The structure of a row - Oracle Block format article (4)
How to dump Blocks - Oracle Block format article (5)


2.2: Documents on corruption and crashes:

Very Good Document on Dumps, crashes and corruptions (pdf)
Quick link to DBMS_REPAIR package 11gR2
Quick link to DBMS_REPAIR package 10gR2
DBA Support article (dbasupport.com)
Good article using SQL to retrieve rows from corrupt objects.
Nice article using 11g Data Recovery Advisor


2.3 Quick Links To: The "Official" Oracle Documentation Libraries:

-- Libraries:
Product Documentation Library
11gR2 RDBMS Documentation Library
11gR1 RDBMS Documentation Library
10g RDBMS Documentation Library
9.2i RDBMS Documentation Library
Oracle RDBMS Documentation Index
Oracle RDBMS 10g Database Error Messages
Oracle 10g Application Server Documentation Index
Oracle WebLogic Server 10g Documentation Index
Oracle Internet File System (IFS) and Content Management SDK Index


-- Quick links to some Admin Guides:
Quick Link To: 10gR2 Admin Guide (general)
Quick Link To: 10gR2 Admin Guide on UNIX systems
Quick Link To: 11gR2 Admin Guide (general)


2.4: Free data dictionary maps:

Large Oracle Dictionary Poster (1) (you should download the pdf)


2.5: Some good Oracle faq's, support sites:

Oracle Base (www.oracle-base.com)
Many Oracle errors and solutions (idError.com)
AskTom: Many answers by Tom on rdbms, plsql, java etc..
orafaq.com: Oracle faq + search (1)
dbasupport.com: Oracle faq + search (2)
Oracle articles + tips (2)
Many good articles + presentations
(oracle.com) Quick link to 9iR2 DBA_ and v$ views (1)
(oracle.com) Quick link to 10gR1 DBA_ and v$ views (2)
(oracle.com) Quick link to 10gR2 DBA_ and v$ views (3)
Quick link to 9iR2 DBA_ and v$ views (4)


2.6: Quick Links To: Resource Management, plans:

Resource Management - resource plans - Oracle 11g 11.1 (1)
Resource Management - resource plans - Oracle 10g 10.2 (1)
Resource Management - resource plans - Oracle 10g 10.1 (1)
Resource Management - resource plans - Oracle 9i (1)
Resource Management - resource plans - good example Oracle 9i (1)
Resource Management - resource plans - reasonable example 9i/10g (2)


2.7: Quick Links To: Tracing:

Very Fast intro in Oracle Tracing
Oracle Session Tracing


2.8: Quick Links To: exp, expdp, imp, impdp

Good simple overview of the expdp and impdp utilities
Orafaq: Good simple overview of the exp and imp utilities
Orafaq: Good simple overview of the expdp and impdp utilities
Short intro on expdp, impdp
AskTom: Interesting article on DBMS_DATAPUMP


2.9: Quick Links To: 10g/11g Automatic Diagnostic Repository, ADR, and Packaging system:

Oracle pdf, explaining AWR, ASH, ADDM on 10gR2
Nice Intro on 11g ADR, adrci, and packaging diagnostic information.
Quick link to: Oracle documentation on adrci and ADR


2.10: Quick Links To: 11g Health Monitoring HM:

Quick link to: Oracle documentation on HM


2.11: Quick Links To: Tuning:

Good overview from Quest


2.12: Using SVRCTL and CRSCTL to manage RAC :

Good examples: Using SVRCTL to manage your RAC (1)
Good examples: Using SVRCTL to manage your RAC (2)
Good examples: Using CRSCTL to manage your Clusterware (1)
Good examples: Using CRSCTL to manage your Clusterware (2)


2.13: Docs on RAC (html, pdf's, ppt):

Step by step installing RAC 11g on CentOS (a free RedHat)
Simplified but good introduction to 10g RAC
2 Day DBA course 10.2 RAC on Linux
10gR1 RAC Administration Guide
10gR2 RAC Administration and Deployment Guide
10gR2 RAC Troubleshooting (from Admin. & Depl. Guide)


2.14: Short notes starting / stopping CRS and RAC:

Note on starting / stopping CRS, Instances, Database (txt file)


2.15: Docs on Extended RAC (html, pdf's, ppt):

Extended RAC 10gR2 (1) (oracle.com)
Extended RAC 10gR2 (2) (oracle.com)
Oracle RAC Extended architecture (levipereira.files.wordpress.com)
Oracle RAC Extended architecture (pcnet.com.pl)
Oracle RAC Extended architecture (oracle.com)
Oracle RAC Extended architecture (databasejournal.com)
11g HA solutions (unixservers.eu)
11g RAC resource center (oracle.com)
Document on TAF and RAC and Extended RAC (easyoradba.wordpress.com)


2.16: Docs on Extended RAC using HP solutions SLVM and/or SGeRAC:

HP Metrocluster for RAC
SGeRAC (1) (hp.com)
SGeRAC (2) (hp.com)
SGeRAC (3) (hp.com)


2.17: Other RAC / Extended RAC notes:

How to build Extended RAC on Oracle VM and Linux
Deploying RAC with cisco (www.cisco.com)
Building an Inexpensive Oracle RAC 10g R2 on Linux




Last update: 16 June, 2011