Advanced Oracle DBA

Backup and recovery using RMAN and rman with shell scripting

  • Rman overview
  • Archivelog configuration
  • Rman configuration

RMAN Recovery catalog

  • Recovery catalog configuration
  • Recovery catalog upgradation
  • Rman views and logs

Backups using rman

  • Full Backups
  • Incremental backups
  • Backup copies
  • Compressed and Encrypted backups
  • Listing backups
  • Handling backup failures
  • Recovery catalog scripts

Backup validation and Recovery

  • Database and backup validation
  • Block level corruption and recovery
  • Rman maintenance commands

Recovery scenarios

  • Performing various recoveries
  • Handling online redo log failures

Rman new features in 11g

Rman with shell scripting and scheduling backups

DB cross platform Migration (linux to solaris)

Automatic storage management (ASM)

  • ASM overview
  • Configuring ASM in 10g
  • Managing ASM
  • Administrating ASM diskgroups
  • Database creation
  • Migrating DB to ASM storage
  • Troubleshooting ASM
  • Kfed and kfod
  • ASM in 11g (GI)
  • ASM new features in 11g
  • Asmca, acfs,asmcmd,advm
  • Mdbackup, mdrestore
  • Oracle restart options
  • Upgrading 10g ASM to 11g

Cloning

  • Cloning rdbms
  • Cloning DB
  • Cloning DB using rman 10g
  • Cloning DB using rman in 11g
  • Active database cloning
  • RMAN DUPLICATE DATABASE From File System to ASM
  • RMAN DUPLICATE DATABASE From ASM to ASM
  • RMAN DUPLICATE DATABASE at a Past Point in Time
  • RMAN DUPLICATE DATABASE without connecting to target

Patching and upgradation

  • Applying various types of patches
  • Upgrading from 10g to 11g

Dataguard

  • Introduction to Data Guard
  • Data Guard Architecture
  • Dataguard services
  • Physical Standby Database
  • Logical Standby Database Pros and Cons
  • Physical Standby Database implementation
  • Standby Database Administration
  • Real time apply 
  • Dataguard scenarios
  • Protection modes
  • Upgrading DB in a dataguard configuration
  • Role Transition -Failover and Switchover
  • Configuration and administration of Dataguard broker
  • Using RMAN for standby databases.
  • Active Dataguard
  • Snapshot standby database
  • Implementing logical standby
  • Monitoring logical standby
  • FSFO configurations

Data Migration and Replication

  • Export & Import , Datapump
  • SQL Loader
  • DB Links and Materialized views

Faculty           :           (18 yrs exp)

Duration         :           4 weeks