Oracle   Home  

 

Oracle Database 9i, 10g, 11g

Oracle Data Warehouse & BI

Oracle Applications EBS 11i, R12

 Oracle Middleware

SQL & PL/SQL

UNIX/ Linux

   Home  >  Oracle Database Administration (DBA)

 

 Oracle Database Administration (DBA)

 

Architecture    Backup & Recovery    Maintenance    Replication     Tuning    RAC    10g New Features    11g New Features 

 

 

 

Oracle Database Architecture

  1. Oracle Server Architecture (Q&A)

  2. Oracle Shared vs. Dedicated Server Architecture (Q&A)

  3. Oracle Physical Database Structure (Q&A)

  4. Oracle Database Listener  (Q&A)

  5. XPT Oracle database service

  6. PLSExtProc Oracle database service

  7. Oracle service name

  8. Oracle Heterogeneous Services

 

Oracle Database Backup & Recovery

  1. Backup & Recovery Overview

  2. EXP/ IMP utility

  3. User-Managed Backups

  4. RMAN Overview

  5. How to create the RMAN Catalog

  6. FULL online database backup using RMAN Recovery Catalog

  7. Incremental database backup using RMAN

  8. Recovering a file using a cumulative backup (with RMAN) 

  9. Testing Media Block Recovery (MBR) using RMAN

  10. RMAN Incomplete Recovery (in NOARCHIVELOG mode)

  11. RMAN Incomplete Recovery (in ARCHIVELOG mode)

  12. RMAN Catalog Maintenance

  13. How to validate a backup

  14. RMAN configuration

 

Oracle Database Maintenance

  1. Managing Tablespaces and Datafiles

  2. Managing Database Tables and Indexes

  3. Managing Data Security 

  4. Database ARCHIVELOG mode

  5. Managing Oracle database jobs

  6. Killing Oracle a particular job at the OS level

  7. PFILE vs. SPFILE

  8. SQL * Loader

  9. Table & Index Partitioning

  10. Partitioning an online table

  11. What Database & OS version I use ?

  12. "Strange" behavior: System can change sys password

  13. Oracle restart

  14. ORA-12514 after service creation with Entreprise Manager 11.2

 

Oracle 10g New Features

  1. Oracle 10g New Features Overview

  2. Speed up the schema refresh over a DBlink with Data Pump

  3. Oracle Grid Control

  4. Oracle Flashback 

  5. Virtual Private Database (VPD)

  6. Preparing UNIX/ Solaris/ Linux for Oracle 10g Installation

 

Oracle Real Application Cluster 

  1. Oracle RAC (10g) Architecture Picture

  2. Oracle RAC (10g) Architecture Q&A

  3. Installing the Real Application Cluster (10g)

  4. Adding a node to a 10g RAC

  5. Oracle Real Application Cluster (Q&A)

  6. Oracle Clusterware components

  7. Oracle RAC clusterware OCR and the Voting disk.html

  8. 11gR2 Clusterware startup sequence

  9. 11gR2 RAC CRSCTL command

  10. 11gR2 RAC SRVCTL command

  11. 11gR2 RAC Services Administration

  12. Oracle 11gR2 Clusterware log files

  13. Startup the Oracle 11gR2 clusterware

  14. Stop the Oracle 11gR2 clusterware

 

 

Oracle Replication 

  1. Materialized views  

  2. Oracle Streams: How to Replicate a Table

  3. How to create a Physical Standby database with RMAN

  4. How to create a Physical Standby Database (step-by-step) 

  5. How to create a Logical Standby database (step-by-step)

  6. Monitor a Standby Database 

  7. Failover & Swichover (Basics)

 

Oracle Database Tuning

  1. Tuning Overview

  2. Instance Tuning: SGA Tuning

  3. Objects Tuning

  4. SQL statement Tuning

  5. tkprof utility

  6. Statspack utility

  7. The "Explain Plan" Command

  8. I/O tuning

  9. Enable the tracing in the database

  10. AUTOTRACE feature

 

Oracle 11g New Features

  1. Oracle Database 11g Step-by-step Installation on Windows

  2. The Top New Features for DBAs and Developers

  3. Database Replay

  4. Partitioning: New Features, Virtual Columns, Invisible Indexes

  5. Caching and Pooling

 

 

 

 

 

   Other links related to Oracle DBA field:

 

 

   Home  >  Oracle Database Administration (DBA)

Oracle Database 9i, 10g, 11g

Oracle Data Warehouse & BI Oracle Applications EBS 11i, R12  Oracle Middleware

SQL & PL/SQL

UNIX/ Linux

 

 

Different Romanian Links/ Linkuri romanesti diferite

  1. Invata limba engleza (Learn English language if you are Romanian)

  2. Translator Englez - Roman           Translator Roman- Englez

  Doresti un proiect de arhitectura ieftin (pentru zonele Buzau, Bucuresti sau Prahova) ?

 

Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk. Copyright(c) 2009-2011 Paul Catalin Tomoiu. All rights reserved.

Powered by  MyPagerank.Net