Syllabus for backup and recovery

Document Sample
Syllabus for backup and recovery Powered By Docstoc
					        ORACLE 10G – NETWORK OVERVIEW, BACKUP & RECOVERY
                           SKY IT SOLUTIONS


Course scheduled to                          Duration : 14 Days (daily 2hrs)


Day 1 (HO)
====
Networking Overview
   • Single tier Architecture
   • 2-tier network
   • N-tier network

Basic Oracle Net Architecture

Basic Oracle Net Server-Side Configuration
   • Listener
   • Listener Configuration
   • Listener Control Utility

Basic Oracle Net Client-Side Configuration
   • Local Naming
   • Local Net Service Names
   • The TNSNAMES.ORA File

Usage and Configuration of the Oracle Shared Server
   • Server Configuration
   • Dedicated Server Process
   • Shared Server Process
   • The SGA and PGA
   • Configuring Oracle Shared Server

Day 2
====
Backup and Recovery Issues
   • Overview
   • Increase MTBF (Mean-Time-Between-Failures)
   • Decrease MTTR (Mean-Time-To-Recover) and minimize data loss
   • Types of failures

Instance and Media Recovery Structures
                                SKY IT SOLUTIONS
         K 30, B2, Shakti Apartments,Anna Nagar East,Chennai 600 102
                        Ph : 91-44-26202037, 9840457811
    Web site : www.skyit.co.in Mail: oradin@skyit.co.in, emailskyit@gmail.com
                                     Page : 1
       ORACLE 10G – NETWORK OVERVIEW, BACKUP & RECOVERY
                          SKY IT SOLUTIONS
   •   Online Redo Log File Contents
   •   How Online Redo Log Files Are Written
   •   Active (Current) and Inactive Online Redo Log Files
   •   Log Switches and Log Sequence Numbers
   •   Multiplexed Online Redo Log Files
   •   Checkpoints
   •   Database Synchronization
   •   Instance Recovery
   •   Tuning Instance Recovery Performance

Day 3 (HO)
====
About Backups Methods (HO)
   • Types of backups
   • Whole Database Backup
   • Partial Database Backup
   • User Managed Backup and Recovery

Configuring the Database Archiving Mode
   • Archivelog Mode (Media Recovery Enabled)
   • Archive Parameters
   • Duplexing the Archived Redo Log

   •   Hot Backup
   •   Cold Backup

Day 4 (HO)
====
Oracle Recovery Manager (RMAN)
   • Overview and Configuration
   • Overview of Recovery Manager
   • Deciding Whether to Use a Recovery Catalog
   • Consequences of Using the Recovery Catalog for RMAN Metadata
   • Backup piece
   • Backup set
   • Multiplexed Backup Sets
   • Duplexed Backup Sets

Taking backups using RMAN
   • Hot Backup
                                SKY IT SOLUTIONS
         K 30, B2, Shakti Apartments,Anna Nagar East,Chennai 600 102
                        Ph : 91-44-26202037, 9840457811
    Web site : www.skyit.co.in Mail: oradin@skyit.co.in, emailskyit@gmail.com
                                     Page : 2
        ORACLE 10G – NETWORK OVERVIEW, BACKUP & RECOVERY
                           SKY IT SOLUTIONS
   •   Incremental – Differential and cumulative
   •   Cold Backup (noarchivelog mode db)

Overview about LogMiner Utility

Day 5 (HO)
====
User Managed Restoration
   •     Using cold backup to restore
User managed Recovery (archivelog mode)
   •     Using hot backup to restore and then doing recovery
Resoration and Recovery using RMAN - scenarios
   • Both Online and offline
   • All controlfiles are lost
   • Complete and incomplete
Dataguard

Day 6 (HO)
====
Switching the database to Flashback mode
    • Flash Recovery Area
    • Fast Incremental Backups
    • Cross platform tablespace conversion
    • Enhanced Stored Scripts Comands
    • Backupset compression
Flashback
    • Flashback Query
    • Flashback Version Query
    • Flashback Transaction Query
    • Flashback Table
    • Flashback Drop (Recycle Bin)
    • Flashback Database
    • Flashback Query Functions

Day 7
=====
SQL*Loader
   • Different type of files used in SQL*Loader
   • Advantage using SQL*Loader
   • Loading data from a Fixed Record Format
                                SKY IT SOLUTIONS
         K 30, B2, Shakti Apartments,Anna Nagar East,Chennai 600 102
                        Ph : 91-44-26202037, 9840457811
    Web site : www.skyit.co.in Mail: oradin@skyit.co.in, emailskyit@gmail.com
                                     Page : 3
       ORACLE 10G – NETWORK OVERVIEW, BACKUP & RECOVERY
                          SKY IT SOLUTIONS
   •   Loading data from a Variable Record Format
   •   Conventional Path Load versus Direct Path Load

Oracle Data Pump in Oracle Database 10g
   • Getting Started
   • Table Exports/Imports
   • Schema Exports/Imports
   • Database Exports/Imports
   • Miscellaneous Information
   • Data Pump API
   • External Tables

Scheduler in Oracle Database 10g
   • Programs
   • Schedules
   • Jobs



                                            *****************




                                SKY IT SOLUTIONS
         K 30, B2, Shakti Apartments,Anna Nagar East,Chennai 600 102
                        Ph : 91-44-26202037, 9840457811
    Web site : www.skyit.co.in Mail: oradin@skyit.co.in, emailskyit@gmail.com
                                     Page : 4

				
DOCUMENT INFO
Shared By:
Tags: backup
Stats:
views:35
posted:5/31/2011
language:English
pages:4
Description: Hot backup technology is a combination of high fault-tolerant hardware and software applications. The program is composed of two server system and an external shared disk array cabinet (also not, but taken in their respective server RAID card) and the corresponding hot backup software. In the fault-tolerant scheme, the operating system and applications installed on two servers on the local system disk, the entire network system data is centralized through the disk array management and data backup. Centralized management of data through the hot backup system, data for all sites to read directly from the central storage device and storage, managed by professionals, which greatly protect the data security and confidentiality. User data stored in the external shared disk array, a single server fails, take the initiative to prepare alternative host machine work to ensure uninterrupted network service.