BackupxRecovery_with_RMANppt：backupxrecovery_with_rman.pptVIP

CERN - IT Department CH-1211 Genève 23 Switzerland www.cern.ch/it LCG 3D Workshop, Bologna, June 2007 - * CERN - IT Department CH-1211 Genève 23 Switzerland www.cern.ch/it Backup Recovery with RMAN LCG 3D Workshop, Bologna June 12th, 2007 Jacek Wojcieszuk LCG LCG 3D Workshop, Bologna, June 2007 - * Agenda Types of failures and backups in Oracle RMAN Architecture Manual vs. RMAN backups On-tape backups with RMAN RMAN Configuration RMAN backup strategies RMAN backups at Tier0 Exemplary recovery scanarios Demo LCG 3D Workshop, Bologna, June 2007 - * Types of failures Instance Failure Usually connected with an Oracle process failure Media Failure Disk failure, storage array controller failure etc. Block Corruption Usually caused by bugs in Oracle software Human error In most cases accidentally deleted/updated data Database user or DBA Disaster Fire, flood, earthquake, plane crash etc. LCG 3D Workshop, Bologna, June 2007 - * Backup options in Oracle Physical backups Cold (off-line) backups Full database only Require downtime Do not provide flexibility for point in time recovery (PiTR) Hot (on-line) backups Different types of backups: full, incr. (cumulative, differential), archivelogs Different scopes: full database, tablespace(s) or datafile(s) Do not require database downtime Can be used to recover full database, single/multiple tablespace(s)/datafile(s) or a corrupted block Database can be recovered to any point in time within assumed backup retention period LCG 3D Workshop, Bologna, June 2007 - * Backup options in Oracle (2) Logical backups Logical copy of data in the database Support for different backup granularity Can be taken either with legacy Export/Import tools or with Data Pump (10g) Standby systems (Data Guard) Physical and logical standby databases LCG 3D Workshop, Bologna, June 2007 - * How hot backups are possible? SGA Server proc. DBWR LGWR RedoLog RedoLog Db file Db file Db file Db file Log archiver Archived redo logs Backup proc. Tapes or