managing enterprise-wide backup and recovery operations

Media Recovery via Media Recovery via Enterprise ManagerEnterprise Manager

Matthew HartMatthew HartJuly 2006July 2006TCOUGTCOUG

22

AgendaAgenda

Configuring Backup SettingsConfiguring Backup Settings Configuring Recovery SettingsConfiguring Recovery Settings Configure Recovery Catalog SettingsConfigure Recovery Catalog Settings EM and Oracle Suggested BackupsEM and Oracle Suggested Backups Scheduling Customized Backup JobsScheduling Customized Backup Jobs Recovery from EMRecovery from EM Managing Existing Backups in EMManaging Existing Backups in EM Database cloning (duplication)Database cloning (duplication)

Configure Backup Configure Backup Settings in EMSettings in EM

44

Configure Backup SettingsConfigure Backup Settings

Device TabDevice Tab Disk SettingsDisk Settings

Set compression hereSet compression here

Tape SettingsTape Settings Set compression hereSet compression here

Media Management SettingsMedia Management Settings Host CredentialsHost Credentials

77


Backup Set TabBackup Set Tab Max piece sizeMax piece size Tape settingsTape settings Host CredentialsHost Credentials

99


Policy TabPolicy Tab Set autobackup onSet autobackup on Backup optimizationBackup optimization Enable block change trackingEnable block change tracking Tablespace exclusionsTablespace exclusions Retention policyRetention policy Host CredentialsHost Credentials

1212


What’s missing?What’s missing? EncryptionEncryption Default Device typeDefault Device type Archive Deletion PolicyArchive Deletion Policy Snapshot Controlfile LocationSnapshot Controlfile Location No throttling valuees available for permanent No throttling valuees available for permanent

configurationconfiguration

Configure Recovery Configure Recovery SettingsSettings

1414

Configure Recovery SettingsConfigure Recovery Settings

FAST_START_MTTR_TARGETFAST_START_MTTR_TARGET Archivelog ModeArchivelog Mode Archivelog destinationsArchivelog destinations Flash Recovery AreaFlash Recovery Area

Note the nice little graph of used space in Note the nice little graph of used space in FRAFRA

Flashback DatabaseFlashback Database

Configuring the Recovery Configuring the Recovery CatalogCatalog

1919

Configure Recovery Catalog Configure Recovery Catalog SettingsSettings

Enterprise Manager is incapable of Enterprise Manager is incapable of creating a recovery catalog. It can only creating a recovery catalog. It can only register a catalog that has already been register a catalog that has already been created from the command linecreated from the command line

EM will only register an existing catalog in EM will only register an existing catalog in the EM repositorythe EM repository

EM Suggested Backup EM Suggested Backup StrategyStrategy

2222

Oracle-Suggested Backup Oracle-Suggested Backup StrategiesStrategies

Oracle has built-in backup strategies Oracle has built-in backup strategies within EM within EM

Utilizes EM job systemUtilizes EM job system Takes advantage of RMAN 10g Takes advantage of RMAN 10g

innovationsinnovations Take them or leave them: they are not Take them or leave them: they are not

‘tweakable’‘tweakable’

2323

EM and Oracle Suggested EM and Oracle Suggested Backups: Disk-only strategyBackups: Disk-only strategy

Oracle-Suggested Strategy uses Oracle-Suggested Strategy uses incrementally updated image copiesincrementally updated image copies Takes one image copyTakes one image copy Takes a new level 1 next dayTakes a new level 1 next day Day 2, level 1 is applied to image copy, new Day 2, level 1 is applied to image copy, new

level 1 is takenlevel 1 is taken Backup remains at least 24 hours behind Backup remains at least 24 hours behind

current time, up to 48 hourscurrent time, up to 48 hours

2525

Oracle Suggested Backup Oracle Suggested Backup Strategy: Tape OnlyStrategy: Tape Only

No backups ever created in the FRANo backups ever created in the FRA No incremental apply functionalityNo incremental apply functionality Two rman scripts: daily and weeklyTwo rman scripts: daily and weekly Weekly: full database backup plus Weekly: full database backup plus

archivelogsarchivelogs Daily: incremental backup of changed Daily: incremental backup of changed

blocks, plus archivelogs (if desired)blocks, plus archivelogs (if desired)

2626

Oracle Suggested Backup Oracle Suggested Backup Strategy: Disk and TapeStrategy: Disk and Tape

Disk strategy is the same as disk-only strategyDisk strategy is the same as disk-only strategy Full image copy in the FRAFull image copy in the FRA Incremental backups, incremental applyIncremental backups, incremental apply

Tape strategy requires a decision: what do you Tape strategy requires a decision: what do you want daily?want daily? Weekly, all recovery files are backed up to tapeWeekly, all recovery files are backed up to tape Daily, you choose: nothing, archivelogs only, Daily, you choose: nothing, archivelogs only,

archivelogs + incrementals, or archivelogs + full archivelogs + incrementals, or archivelogs + full database backupsetdatabase backupset

2727

Oracle-Suggested Strategies: Right Oracle-Suggested Strategies: Right for You and Yours?for You and Yours?

Benefits: ‘set and forget’Benefits: ‘set and forget’ Good for low priority dev databases with Good for low priority dev databases with

permissive or non-existent SLAspermissive or non-existent SLAs May not provide level of detail or control May not provide level of detail or control

required for enterprise-dependent systemsrequired for enterprise-dependent systems

Scheduling Customized Scheduling Customized Backups in EMBackups in EM

2929

Scheduling Customized Backup Scheduling Customized Backup JobsJobs

Always starts with type of backupAlways starts with type of backup DatabaseDatabase TablespaceTablespace DatafileDatafile ArchivelogArchivelog All recovery filesAll recovery files

Performing Recovery in Performing Recovery in EMEM

3636

Performing Recovery from EMPerforming Recovery from EM

Displayed as an option if the database is not Displayed as an option if the database is not upup

In 10gR2, there is guided recovery based on In 10gR2, there is guided recovery based on health checkshealth checks

Some intelligence concerning what type of Some intelligence concerning what type of recovery should be undertakenrecovery should be undertaken

Recovery includes object level recovery optionRecovery includes object level recovery option If tables is chosen, flashback recovery options are If tables is chosen, flashback recovery options are

made availablemade available

3737

Should I use EM for critical Should I use EM for critical database recovery?database recovery?

EM and panic don’t go hand in handEM and panic don’t go hand in hand Down databases are no time for a big read Down databases are no time for a big read

‘Easy’ button‘Easy’ button Control is desired at every decision Control is desired at every decision

momentmoment It’s a good complement for databases that It’s a good complement for databases that

use the Oracle Suggested Backup use the Oracle Suggested Backup StrategyStrategy

Managing Current Managing Current Backups in EMBackups in EM

4040

Manage Current BackupsManage Current Backups

Perform common admin tasksPerform common admin tasks Catalog filesCatalog files CrosscheckCrosscheck Delete obsoleteDelete obsolete Delete expiredDelete expired

Manage all files with quick links, or administer Manage all files with quick links, or administer individual backupsets or image copiesindividual backupsets or image copies

Perform a search based on type of backup, Perform a search based on type of backup, and completion timeand completion time

Backup ReportsBackup Reports

4444

Backup ReportsBackup Reports

Backups can be viewed based on multiple Backups can be viewed based on multiple criteriacriteria

Drill-down allows user to see which files Drill-down allows user to see which files are in which backupsetsare in which backupsets

In Grid Control, can view multiple-target In Grid Control, can view multiple-target report report This only works for 10.2 databasesThis only works for 10.2 databases

Oracle Database CloningOracle Database Cloning

4848

Database CloningDatabase Cloning

Database cloning uses RMAN backups Database cloning uses RMAN backups and the duplication process to build a and the duplication process to build a cloneclone

All RMAN use is ‘behind the scenes’ from All RMAN use is ‘behind the scenes’ from EM EM

Clone from the deployments pageClone from the deployments page

4949

Database Cloning (cont.)Database Cloning (cont.)

Grid Control onlyGrid Control only Can clone from a running db, or form a Can clone from a running db, or form a

‘working directory’ created from a previous ‘working directory’ created from a previous cloneclone

Existing RMAN backups cannot be usedExisting RMAN backups cannot be used

5151


Choose a source host working directoryChoose a source host working directory Choose to compress the backupChoose to compress the backup Choose to retain the working dir, or delete Choose to retain the working dir, or delete

on completionon completion

5353


Choose Destination database Choose Destination database global_name, SIDglobal_name, SID

Choose storage type (files, ASM, raw)Choose storage type (files, ASM, raw) Choose hostChoose host

5555


Choose Destination file locationsChoose Destination file locations Provide information about networking filesProvide information about networking files Decide if new clone will be registered with Decide if new clone will be registered with

EM Grid ControlEM Grid Control

5757


Schedule and review Schedule and review the jobthe job

5959

Q & AQ & A

Q & AQ & A

managing enterprise-wide backup and recovery operations

Documents