Less15 Backups TB3
Content
Performing Database Backups
15
Copyright © 2005, Oracle. All rights reserved.
Objectives
After completing this lesson, you should be able to do the following: • Create consistent database backups • Back up your database without shutting it down • Create incremental backups • Automate database backups • Monitor the flash recovery area
15-2
Copyright © 2005, Oracle. All rights reserved.
Backup Solutions: Overview
Backups can be performed by using: • Recovery Manager • Oracle Secure Backup • A user-managed scenario
15-3
Copyright © 2005, Oracle. All rights reserved.
Oracle Secure Backup
• Oracle Secure Backup and RMAN provide an end-to-end backup solution for Oracle environments:
– Centralized tape backup management for file system data and the Oracle database – Most well-integrated media management layer for RMAN backups – Backup of any data anywhere on the network
• •
A single technical support resource for the entire backup solution expedites problem resolution. This ensures reliable data protection at lower cost and complexity.
Copyright © 2005, Oracle. All rights reserved.
15-4
User-Managed Backup
A user-managed scenario: • Is a manual process of tracking backup needs and status. • Requires the DBA to write scripts. • Requires that database files be put in the correct mode for backup. • Relies on operating system commands to make backups of files.
15-5
Copyright © 2005, Oracle. All rights reserved.
Terminology
• Backup strategy may include:
– The entire database (whole) – A portion of the database (partial)
•
Backup type may indicate inclusion of:
– All information from all data files (full) – Only information that has changed since some previous backup (incremental)
•
Backups mode may be:
– Offline (consistent, cold) – Online (inconsistent, hot)
15-6
Copyright © 2005, Oracle. All rights reserved.
Terminology
Backups may be stored as: • Image copies • Backup sets
Data file #1 Data file #2 Data file #3 Data file #4 Data file #5 Data file #6 Image copies Data file #1 Data file #3 Data file #5 Data file #2 Data file #4 Data file #6
Backup set
15-7
Copyright © 2005, Oracle. All rights reserved.
Recovery Manager (RMAN)
• Enterprise Manager uses Recovery Manager (RMAN) to perform backup and recovery operations. RMAN:
– Is a command-line client for advanced functions – Has powerful control and scripting language – Has a published API that enables interface with most popular backup software – Backs up data, control, archived log, and server parameter files – Backs up files to the disk or tape
•
15-8
Copyright © 2005, Oracle. All rights reserved.
Configuring Backup Settings
15-9
Copyright © 2005, Oracle. All rights reserved.
Configuring Backup Settings
15-10
Copyright © 2005, Oracle. All rights reserved.
Scheduling Backups: Strategy
Select whole or partial database backup.
15-11
Copyright © 2005, Oracle. All rights reserved.
Scheduling Backups: Options
15-12
Copyright © 2005, Oracle. All rights reserved.
Scheduling Backups: Settings
15-13
Copyright © 2005, Oracle. All rights reserved.
Scheduling Backups: Schedule
15-14
Copyright © 2005, Oracle. All rights reserved.
Scheduling Backups: Review
Click Edit RMAN Script to review RMAN commands.
15-15 Copyright © 2005, Oracle. All rights reserved.
Backing Up the Control File to a Trace File
Control files have an additional backup option.
Control file trace backups may be used to recover from loss of all control files.
15-16 Copyright © 2005, Oracle. All rights reserved.
Backing Up the Control File to a Trace File Full Notes Page
15-17
Copyright © 2005, Oracle. All rights reserved.
Managing Backups
15-18
Copyright © 2005, Oracle. All rights reserved.
Flash Recovery Area
Monitor the flash recovery area to: • Configure flashback logging • Size the recovery area • View current space consumption
15-19
Copyright © 2005, Oracle. All rights reserved.
Summary
In this lesson, you should have learned how to: • Create consistent database backups • Back up your database without shutting it down • Create incremental backups • Automate database backups • Monitor the flash recovery area
15-20
Copyright © 2005, Oracle. All rights reserved.
Practice Overview: Creating Database Backups
This practice covers the following topics: • Configuring your database for backups • Backing up your database while the database is open for user activity • Scheduling automatic nightly incremental backups for your database
15-21
Copyright © 2005, Oracle. All rights reserved.
15-22
Copyright © 2005, Oracle. All rights reserved.
15
Copyright © 2005, Oracle. All rights reserved.
Objectives
After completing this lesson, you should be able to do the following: • Create consistent database backups • Back up your database without shutting it down • Create incremental backups • Automate database backups • Monitor the flash recovery area
15-2
Copyright © 2005, Oracle. All rights reserved.
Backup Solutions: Overview
Backups can be performed by using: • Recovery Manager • Oracle Secure Backup • A user-managed scenario
15-3
Copyright © 2005, Oracle. All rights reserved.
Oracle Secure Backup
• Oracle Secure Backup and RMAN provide an end-to-end backup solution for Oracle environments:
– Centralized tape backup management for file system data and the Oracle database – Most well-integrated media management layer for RMAN backups – Backup of any data anywhere on the network
• •
A single technical support resource for the entire backup solution expedites problem resolution. This ensures reliable data protection at lower cost and complexity.
Copyright © 2005, Oracle. All rights reserved.
15-4
User-Managed Backup
A user-managed scenario: • Is a manual process of tracking backup needs and status. • Requires the DBA to write scripts. • Requires that database files be put in the correct mode for backup. • Relies on operating system commands to make backups of files.
15-5
Copyright © 2005, Oracle. All rights reserved.
Terminology
• Backup strategy may include:
– The entire database (whole) – A portion of the database (partial)
•
Backup type may indicate inclusion of:
– All information from all data files (full) – Only information that has changed since some previous backup (incremental)
•
Backups mode may be:
– Offline (consistent, cold) – Online (inconsistent, hot)
15-6
Copyright © 2005, Oracle. All rights reserved.
Terminology
Backups may be stored as: • Image copies • Backup sets
Data file #1 Data file #2 Data file #3 Data file #4 Data file #5 Data file #6 Image copies Data file #1 Data file #3 Data file #5 Data file #2 Data file #4 Data file #6
Backup set
15-7
Copyright © 2005, Oracle. All rights reserved.
Recovery Manager (RMAN)
• Enterprise Manager uses Recovery Manager (RMAN) to perform backup and recovery operations. RMAN:
– Is a command-line client for advanced functions – Has powerful control and scripting language – Has a published API that enables interface with most popular backup software – Backs up data, control, archived log, and server parameter files – Backs up files to the disk or tape
•
15-8
Copyright © 2005, Oracle. All rights reserved.
Configuring Backup Settings
15-9
Copyright © 2005, Oracle. All rights reserved.
Configuring Backup Settings
15-10
Copyright © 2005, Oracle. All rights reserved.
Scheduling Backups: Strategy
Select whole or partial database backup.
15-11
Copyright © 2005, Oracle. All rights reserved.
Scheduling Backups: Options
15-12
Copyright © 2005, Oracle. All rights reserved.
Scheduling Backups: Settings
15-13
Copyright © 2005, Oracle. All rights reserved.
Scheduling Backups: Schedule
15-14
Copyright © 2005, Oracle. All rights reserved.
Scheduling Backups: Review
Click Edit RMAN Script to review RMAN commands.
15-15 Copyright © 2005, Oracle. All rights reserved.
Backing Up the Control File to a Trace File
Control files have an additional backup option.
Control file trace backups may be used to recover from loss of all control files.
15-16 Copyright © 2005, Oracle. All rights reserved.
Backing Up the Control File to a Trace File Full Notes Page
15-17
Copyright © 2005, Oracle. All rights reserved.
Managing Backups
15-18
Copyright © 2005, Oracle. All rights reserved.
Flash Recovery Area
Monitor the flash recovery area to: • Configure flashback logging • Size the recovery area • View current space consumption
15-19
Copyright © 2005, Oracle. All rights reserved.
Summary
In this lesson, you should have learned how to: • Create consistent database backups • Back up your database without shutting it down • Create incremental backups • Automate database backups • Monitor the flash recovery area
15-20
Copyright © 2005, Oracle. All rights reserved.
Practice Overview: Creating Database Backups
This practice covers the following topics: • Configuring your database for backups • Backing up your database while the database is open for user activity • Scheduling automatic nightly incremental backups for your database
15-21
Copyright © 2005, Oracle. All rights reserved.
15-22
Copyright © 2005, Oracle. All rights reserved.
