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