timbolesdatabaseadministratorseniorstaff-文庫吧
2025-09-08 14:53 本頁面
【正文】 ? What’s Your Plan? 12 Software Corruption ? Customized COTS / InHouse ? COTS – Leopard OS – Oracle BUG 13 How Would You Recover? ? DROP SCHEMA CASCADE ? Oracle software deletion ? Wrong data deletion – detected immediately – detected several hours later ? Batch Job corruption ? Software Upgrade ? Block Corruption Detected in Backup 14 Counting the Cost Industry Sector Revenue/Hour (Millions) Energy $ Telemunications $ Manufacturing $ Information Technology $ Pharmaceuticals $ Meta Group of Stanford, CT in October of 2020: IT Performance Engineering amp。 Measurement Strategies: Quantifying Performance Loss. 15 BASICS OF A BACKUP 16 What The? 17 RMAN Does Not Back Up ? Oracle Software Home (binaries) ? BFILES ? Password Files ? pfiles (spfiles are covered with newer versions) ? ? ? ? /etc/oratab ? scripts (shell, sql) 18 The Basics ? Backup and Recovery Plan ? Physical Backups – Data Storage ? data files, contol files, Archived Redo – Support Files ? Binaries, Initialization Files, Scripts, .ora, password ? Logical Backups (Exports) – Logical data structure such as tables, tablespaces, objects, users, data within tables 19 BUILDING A BACKUP POLICY 20 Where to Start? ? Stake Holders – Who Cares About The Data? ? Users ? Auditor, Lawyer, Regulator ? Security System Administrators – Who Touches The Data? ? System / Backup Administrators ? Database Administrators 21 Basic Concerns ? Size of Database (growth potential) ? Backup Window ? Space Available for Backup Storage ? Media Used ? Tools Available
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1