Website : www.unitedglobalsoft.com
#307, 5th Floor,
Liberty Plaza,
opp: Stanza,Himayat Nagar,
Hyderabad - 500029.
Phone No : 040- 6644 4122
Email : info@unitedglobalsoft.com
Backup And Recovery Considerations
• Oracle Suggested Backup Strategy
• Plan and Implement a Backup and Recovery Strategy
• Define a Backup Strategy
• Define a Disaster Recovery Plan
• The Advantages and Disadvantages of Different Backup Methods
• Test a Backup and Recovery Plan
• Backup Strategy
• Recovery Strategy
• Validate the Recovery Strategy
Oracle Recovery Structures And Processes
• Architectural Components of Backup and Restore
• Redo Logs, Checkpoints and Archives
• Multiplexing Control Files and Redo Logs
• Types of Database Failure
Memory Management
• Automatic Shared Memory Management
• PGA Memory Management
• Automatic Memory Management
• The Memory Advisor
• Memory Allocation Advisors
• Memory Management Data Dictionary Views
Using Archivelog And Noarchivelog Modes
• The Archive Modes of a Database
• Altering the Archive Mode of a Database
• Configuring Multiple Archival Destinations
• Configuring Multiple ARCH Processes
• Data Dictionary Tables for Archiving
Troubleshooting Utilities
• Database Synchronization
• Automatic Block Corruption reporting
• Automatic Quarantine of Corrupt Redo Segments
• Protection from Data Corruptions
• Analyze Validate Structure
• Automatic Diagnostic Repository (ADR)
• The ADR Command Line Tool (ADRCI)
• Proactive Monitoring with the Health Monitor
Recovery Manager Overview
• Overview of Recovery Manager
• RMAN Features and Components
• Connect to RMAN
• Start Up and Shut Down a Target Database Using RMAN
Create A Recovery Catalog
• Recovery Catalog Overview
• Create a Recovery Catalog
• Use a Flashback Recovery Area
• Register and Unregister a Database
• Control File Information
• RESYNC CATALOG command
• Virtual Private Catalogs
• Merge Catalogs
• Backup a Recovery Catalog
Backing Up With RMAN
• Channel Allocation
• The Configure Channel Command
• Types of RMAN Backup
• Recovery Manager Commands
• Performing Backups with RMAN
• The Backup Command
• The Copy Command
• Backup File Image Copies
• Perform Full, Incremental and Cumulative Backups
• Use Data Dictionary Tables
Maintain A Recovery Catalog
• Reset Database Command
• Change the Availability Status of Backups and Copies
• Catalog Backups Made with Operating System Commands
• Generate Reports and Lists
• Configuration Values
• Cross Check Backups and Copies
• Delete Backups
• Drop Database and Archival Backups
Restore And Recover With RMAN
• Overview of Restore
• The Restore Command
• Restore a Database in Noarchivelog Mode
• Restore and Recover a Database in Archivelog Mode
• Incomplete Recovery using Until Time and Until Sequence
• Restore and Recover a Tablespace
• Automatic tempfile Recovery
• Restore and Recover a Datafile
• Recover a Datafile Not Backed Up
• Recover Individual Data Blocks
• Recover a Lost Redo Log Group
• Re-create a Password Authentication File
• Apply Incremental Backups to Restore Datafile Image Copies
• The Switch command
• The Data Recovery Advisor (DRA)
• Restore and Recover the Database on a New Host
Create A Duplicate Database With RMAN
• Overview of Database Duplication
• Database Duplication
• Duplication Options
• Create Files for the Duplicate Database
• Prepare an Auxiliary Instance for Duplication
• Create a Duplicate Database
• Clone a Running Database without a Backup
• Targetless duplication of a database
Manage Space For The Database
• Transport Tablespaces
• Transport Databases
Monitor & Tune RMAN
• Recovery Manager Tuning Overview
• Tuning RMAN Backup Performance
• Synchronous and Asynchronous I/O
• Instance Recovery Performance Tuning
• RMAN Messages
• Troubleshoot RMAN
• RMAN Detected Block Corruptions
• Performance impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION
Flashback
• Configure and Use Flashback Database
• Monitor Flashback Database
• Flash Recovery Area Space Usage
• Flashback Query
• Retrieve Row History with Flashback Versions Query
• Audit or Recover from Transactions with Flashback Transactions Query
• Flashback Table
• Recover Dropped Tables with Flashback Drop
• The Recycle Bin
• Recover Tables to a Point in Time with Flashback Table
• Flashback Database
• Flashback Restore Points
• Flashback Transaction Backout
Oracle Total Recall
• Overview of Oracle Total Recall
• Manage Flashback Archives
• Flashback Data Archive and Auditing
• Flashback Data Archive Uses
Automate Tasks With The Scheduler
• Introduction to the Scheduler
• Scheduler Related Parameters
• Access Rights
• Create and enable a Program
• Drop a Program
• Create a Schedule
• Create a Job
• Job Classes
• Windows
• Window Group
• Monitoring and Logging
• Use Time Based, Event Based and Complex Schedules
• Multi Destination Jobs
Manage Space In Segments
• Tablespace Monitoring
• Segment Management Enhancements
• Segment Advisor
• Segment Space Estimation
• Online Segment Shrink
• Proactive Tablespace Management
Manage Space In Blocks
• Free Space Management
• Monitor Space
• Compress Data
Manage Database Performance
• Tuning Activities
• Use Statistic Preferences
• Optimizer Statistics Collection
• Monitor The Performance of Sessions And Services
• Automatic Workload Repository (AWR)
• The Benefits of Automatic Database Replay
Database Performance By SQL Tuning
• Application and SQL Tuning
• SQL Tuning Advisor
• SQL Access Adviso
• SQL Performance Analyzer
Overview Of Automatic Storage Management
• Overview of ASM
• ASM Instance Creation
• SYSASM Role
• Administer ASM Disk Groups
• ASM Files
• ASM Startup and Shutdown
• ASM Disk Failure
• ASM Data Dictionary Views
• Migrate a Database to ASM Using RMAN
• The ASM Command Line Tool
Managing Resources With Resource Manager
• Overview of the Database Resource Manager
• Create Resource Plans
• Create Resource Consumer Groups
• Create Resource Plan Directives
• Limit CPU Utilization at the Database Level
• Instance Caging
• Control Resources by User Groups
• Specify an Instance Plan
• Monitor the Resource Manager
• Data Dictionary Views
