“Hand’s on Guide for Oracle DBA’s”

“Hand’s on Guide for Oracle DBA’s”

I am glad to inform you that I have published Hand’s on Guide for Oracle DBA’s. This book’s covers all the pertinent aspects of administrating Oracle Database—from installation to day-to-day maintenance. It covers Implementation, upgrading, maintenance and troubleshooting of the database system
Click Here for Preview

Content

Description of Content

1. Oracle Architecture
How to Oracle work
Oracle Architecture (Diagram)
Basics of Oracle Architecture
Starting up a database
Shutdown the database
Managing an Oracle Instance
Oracle Background Processes

2. Oracle 10gR12 Software/binary installation
10gR2 Installation on Linux
10gR2 installation on Solaris

3. Database Creation (Manually)
For File System Storage Mechanism on Linux/Solaris
For ASM Mechanism on Linux
For ASM Mechanism on Solaris
For ASM Mechanism on Windows
For RAW Device on Linux
For RAW Device on Solaris
For OMF Enable Database on Linux/Solaris

4. Managing Tablespace
How to Manage Tablespace
Query Related to Tablespace

5. Managing Database
Managing Data file
How to Drop Data file
Managing Control File
Managing Redo Log File
Managing Undo Tablespace
Managing Temporary Tablespace

6. Creating and Managing 10G ASM
About ASM, Functionality and Advantage
ASM instance, archicture and management
Managing ASM Directory
Managing ASM Disk Group
Move Non-ASM database to ASM
How to access ASM file
ASM Disk Crash Case Study
Useful Query for ASM

7. User Managed Backup/recovery
User-Managed Backup Terminology
Type of Recovery and Diff. between Resetlog and No resetlogs Option
Recovery from missing or corrupted datafile
Recovery from missing or corrupted redo log group
Disaster recovery
How to Perform User Managed Inconsistent Backup & Recovery (With Example)

8. Recovery Manager (RMAN)
Basic RMAN Tutorial
Type of RMAN Backup
RMAN: RESTORE Concept
Use RMAN with a Recovery Catalog
How to Configure RMAN
Complete Steps for Using RMAN through Catalog

9. RMAN Recovery Case Study
Datafile Recovery
Controlfile Recovery
Redolog file Recovery
Disaster Recovery

10 Standby Database
Creating standby database using Manual
Creating standby database using RMAN
Standby Database Maintenance
Database Switchover/Failover
Standby Diagnosis Query for Primary Node
Standby Diagnosis Query for Standby Node

11. Oracle Database Up-gradation
Why upgrade oracle database to higher version
Role of DBA during database up-gradation
Different option for upgrade method, difference and process
Difference between Up-gradation and Migration
About Oracle release and Upgrade path
Converting database to 64 bit
Moving from standard edition to enterprise edition and via-verse
Upgrade Project

Project A
Upgrade 8.1.x(x>7) to 8.1.7

Project B
Upgrade 8.1.7 to 9.2.0

Project C
Upgrade 8.1.7 to 10.2.0

Project D
Upgrade 9.2.0 to 10.2.0

12. Migration of Oracle Database Instances across OS Platforms

Migrate through Export / Import
Migrate through “RMAN Convert database” on source host
Migrate through “RMAN Convert database” on destination host
Migrate by using Transporting Tablespace


Thanks
Anup