Read Oracle RMAN 11g Backup and Recovery Online
Authors: Robert Freeman
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