Oracle RMAN 11g Backup and Recovery (3 page)

PLATFORM (check all that apply)

o 19 Intel x86(32)

o 06 J++/J#

o 18 Visual Basic

one only)

o 01 Digital Equipment Corp UNIX/VAX/VMS

o 20 Intel x86(64)

o 07 Java

o 98 Other

o 21 Network Computer

o 08 JSP

o 01 Aerospace and Defense Manufacturing

o 02 HP UNIX

o 22 Symmetric Multiprocessing

o 09 .NET

o 02 Application Service Provider

o 03 IBM AIX

o 23 Workstation Services

o 10 Perl

o 03 Automotive Manufacturing

o 04 IBM UNIX

o 04 Chemicals

o 05 Linux (Red Hat)

SERVICES

o 11 PHP

o 05 Media and Entertainment

o 06 Linux (SUSE)

o 24 Consulting

o 12 PL/SQL

o 06 Construction/Engineering

o 07 Linux (Oracle Enterprise)

o 25 Education/Training

o 07 Consumer Sector/Consumer Packaged

o 08 Linux (other)

o 26 Maintenance

10
WHAT ORACLE PRODUCTS ARE IN USE AT YOUR

Goods

o 09 Macintosh

o 27 Online Database

SITE? (check all that apply)

o 08 Education

o 10 MVS

o 28 Support

o 09 Financial Services/Insurance

o 11 Netware

o 29 Technology-Based Training

ORACLE DATABASE

o 10 Health Care

o 12 Network Computing

o 30 Other

o 01 Oracle Database 11g

o 11 High Technology Manufacturing, OEM

o 13 SCO UNIX

99 o None of the Above

o 02 Oracle Database 10g

o 12 Industrial Manufacturing

o 14 Sun Solaris/SunOS

o 03 Oracle9i Database

o 13 Independent Software Vendor

o 15 Windows

o 04 Oracle Embedded Database

o 14 Life Sciences (biotech, pharmaceuticals)

o 16 Other UNIX

6

WHAT IS YOUR COMPANY’S SIZE?

(Oracle Lite, Times Ten, Berkeley DB)

o 15 Natural Resources

o 98 Other

(check one only)

o 05 Other Oracle Database Release

o 16 Oil and Gas

99 o None of the Above

o 01 More than 25,000 Employees

ORACLE FUSION MIDDLEWARE

o 17 Professional Services

o 02 10,001 to 25,000 Employees

o 06 Oracle Application Server

o 18 Public Sector (government)

o 03 5,001 to 10,000 Employees

4

o 07 Oracle Portal

o 19 Research

DO YOU EVALUATE, SPECIFY, RECOMMEND,

o 04 1,001 to 5,000 Employees

o 08 Oracle Enterprise Manager

o 20 Retail/Wholesale/Distribution

OR AUTHORIZE THE PURCHASE OF ANY OF

o 05 101 to 1,000 Employees

o 09 Oracle BPEL Process Manager

o 21 Systems Integrator, VAR/VAD

THE FOLLOWING? (check all that apply)

o 06 Fewer than 100 Employees

o 10 Oracle Identity Management

o 22 Telecommunications

o 01 Hardware

o 11 Oracle SOA Suite

o 23 Travel and Transportation

o 02 Business Applications (ERP, CRM, etc.)

o 12 Oracle Data Hubs

o 24 Utilities (electric, gas, sanitation, water)

o 03 Application Development Tools

7

DURING THE NEXT 12 MONTHS, HOW MUCH

o 98 Other Business and Services _________

o 04 Database Products

DO YOU ANTICIPATE YOUR ORGANIZATION

ORACLE DEVELOPMENT TOOLS

o 05 Internet or Intranet Products

WILL SPEND ON COMPUTER HARDWARE,

o 13 Oracle JDeveloper

o 06 Other Software

SOFTWARE, PERIPHERALS, AND SERVICES FOR

o 14 Oracle Forms

2

WHICH OF THE FOLLOWING BEST DESCRIBES

o 07 Middleware Products

YOUR LOCATION? (check one only)

o 15 Oracle Reports

YOUR PRIMARY JOB FUNCTION?

99 o None of the Above

o 16 Oracle Designer

(check one only)

o 01 Less than $10,000

o 17 Oracle Discoverer

o 02 $10,000 to $49,999

CORPORATE MANAGEMENT/STAFF

o 18 Oracle BI Beans

5

o 03 $50,000 to $99,999

o 01 Executive Management (President, Chair,

IN YOUR JOB, DO YOU USE OR PLAN TO PUR-

o 19 Oracle Warehouse Builder

o 04 $100,000 to $499,999

CEO, CFO, Owner, Partner, Principal)

CHASE ANY OF THE FOLLOWING PRODUCTS?

o 20 Oracle WebCenter

o 05 $500,000 to $999,999

o 02 Finance/Administrative Management

(check all that apply)

o 21 Oracle Application Express

o 06 $1,000,000 and Over

(VP/Director/ Manager/Controller,

SOFTWARE

ORACLE APPLICATIONS

Purchasing, Administration)

o 01 CAD/CAE/CAM

o 22 Oracle E-Business Suite

o 03 Sales/Marketing Management

o 02 Collaboration Software

8

WHAT IS YOUR COMPANY’S YEARLY SALES

o 23 PeopleSoft Enterprise

(VP/Director/Manager)

o 03 Communications

REVENUE? (check one only)

o 24 JD Edwards EnterpriseOne

o 04 Computer Systems/Operations

o 04 Database Management

o 25 JD Edwards World

Management

o 05 File Management

o 01 $500, 000, 000 and above

o 26 Oracle Fusion

(CIO/VP/Director/Manager MIS/IS/IT, Ops)

o 06 Finance

o 02 $100, 000, 000 to $500, 000, 000

o 27 Hyperion

IS/IT STAFF

o 07 Java

o 03 $50, 000, 000 to $100, 000, 000

o 28 Siebel CRM

o 05 Application Development/Programming

o 08 Multimedia Authoring

o 04 $5, 000, 000 to $50, 000, 000

Management

ORACLE SERVICES

o 09 Networking

o 05 $1, 000, 000 to $5, 000, 000

o 06 Application Development/Programming

o 28 Oracle E-Business Suite On Demand

o 10 Programming

Staff

o 29 Oracle Technology On Demand

o 11 Project Management

o 07 Consulting

o 30 Siebel CRM On Demand

o 12 Scientific and Engineering

9

WHAT LANGUAGES AND FRAMEWORKS DO

o 08 DBA/Systems Administrator

o 31 Oracle Consulting

o 13 Systems Management

YOU USE? (check all that apply)

o 09 Education/Training

o 32 Oracle Education

o 14 Workflow

o 10 Technical Support Director/Manager

o 33 Oracle Support

o 01 Ajax

o 13 Python

o 11 Other Technical Management/Staff

HARDWARE

o 98 Other

o 02 C

o 14 Ruby/Rails

99

o 98 Other

o 15 Macintosh

o None of the Above

o 16 Mainframe

o 03 C++

o 15 Spring

08014004

o 17 Massively Parallel Processing

o 04 C#

o 16 Struts

This book is dedicated to all the people who make my life great. My kids,
my wife, my cat, my father, my friends, co-workers past and present.

—Robert

This book is dedicated to the team of professionals around the globe that
I have the privilege of working with every day.

—Matthew

About the Authors

Robert G. Freeman
has been an Oracle DBA for so long he can’t remember now when he actually entered SQL*Plus for the first time. In his spare time (what’s that?) Robert flies airplanes and loves to ride trains. Robert has written a number of books, including previous titles for Oracle Press on
Oracle Database 11
g
New Features
.

Matthew Hart
is the coauthor of six books for Oracle Press, most recently
Oracle 10
g
High
Availability with RAC, Flashback, and DataGuard
,
Oracle Enterprise Manager 10
g
Handbook
, and the tome you now hold in your hands. He has worked with high availability technologies in Oracle since version 7.3, and has worked with RMAN since its inception. Matthew currently works and lives in Kansas City, Missouri.

About the Contributors

Emre Baransel
received his B.S. degree from Istanbul University in Electric and Electronic Engineering. He started his career in information technology and became an Oracle addict. He worked for Turkey’s leading Telco and GSM operators as an Oracle DBA. His special focus is on grid technologies, disaster recovery, and security. He writes articles on his Oracle blog and also supervises a web page that publishes Oracle-related writings in Turkish. He’s an OCP (Oracle Certified Professional) and CCNP (Cisco Certified Network Professional).

Scott Black
has worked in information technology for over ten years, mostly in the e-commerce, and healthcare industries. His main areas of focus were networking and server administration when he started his career, and he has spent the last six years in database administration focusing on Oracle and SQL Server. With Oracle, his main interests are large-scale database performance tuning, RAC, and enterprise management of large numbers of databases.

Alan Bort
started working as first-line support for Oracle customers before the support model switched to web-based Oracle support. In the beginning, his area of interest was Linux System Administration, Oracle Database, and Oracle Applications, but later focused only on Oracle Database with a special interest in large-scale high availability and disaster recovery scenarios.

He currently works for IBM’s Service Delivery structure for several companies and has worked on several projects to overhaul their Disaster Recovery capabilities.

Jeremiah Wilton
has over fifteen years of Oracle administration and architecture experience.

As Amazon.com’s first DBA, he helped lead Amazon.com’s database group from pre-IPO times through the years of exponential growth. He now directs education and emergency support services for Blue Gecko, a leader in remote database administration and managed hosting for Oracle, Oracle Applications, and MySQL. Jeremiah is a recognized expert in scalability, high availability, stability, and complex recoveries. He also teaches the Oracle Certificate Program at the University of Washington and independent seminars on a variety of Oracle subjects. In 2001

at Oracle Openworld, Oracle Education honored Jeremiah as one of the first eight Oracle Certified Masters in the world. Jeremiah is a member of the Oak Table and has presented at numerous conferences including Oracle Openworld, Collaborate, and UKOUG. He is the author of a

variety of technical whitepapers and articles available at www.bluegecko.net.

Alisher Yuldashev
has been an Oracle DBA for more than twelve years. Currently, he is a Senior Oracle DBA at The Pythian Group, a global industry leader in remote database administration services and consulting for Oracle and Oracle Applications. Alisher is an Oracle Certified Professional DBA and is responsible for all aspects of database administration for Pythian’s wide range of multinational clients, from migrations and performance tuning to disaster recovery, and data warehousing. Alisher lives in Ottawa, Canada, with his wife, Anna, and their child, Rihanna.

When he is not working with Oracle, he spends his time with his wonderful family, and enjoys snowboarding the Canadian mountains and reading books.

About the Technical Editor

Matt Arrocha
started in the computer industry as a hardware technician. He spent 5 years at NASA in Florida repairing hardware for all manned and unmanned space flight. He worked for 2 years with Seagate in their tape backup division (previously Conner/Maynard). He has been with Oracle now since 1996 and has been working with Recovery Manager since its release in Oracle Database 8.0.3. He is currently the Advanced Resolution Lead for Backup & Recovery in the United States and Canada and the RMAN Global Technical Lead.

This page intentionally left blank

Contents at a Glance

PART I

Getting Started with RMAN in Oracle Database 11
g

1 Oracle Database 11
g
Backup and Recovery Architecture Tour . . . . . . . . . . . . . .

3

2 Introduction to the RMAN Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33

PART II

Setup Principles and Practices

3 RMAN Setup and Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61

4 Media Management Considerations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101

5 Oracle Secure Backup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113

6 Backing Up to Amazon Web Services Using the Oracle Secure

Backup Cloud Module . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143