Performing Database Backups
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Performing Database Backups as PDF for free.
More details
- Words: 714
- Pages: 22
15
Performing Database Backups
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 endto-end backup solution for Oracle environments: – Centralized backup management to tape for file system data and the Oracle database – Provides most well-integrated media management layer for RMAN backups – Backup of any data anywhere on the network
• •
15-4
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.
User-Managed Backup A user-managed scenario: • It is a manual process of tracking backup needs and status. • It requires the DBA to write scripts. • Database files must be put in the correct mode for backup. • Operating system commands are used 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 be: – 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 #1
Data file #2
Data file #2
Data file #3
Data file #4
Data file #3
Data file #5
Data file #6
Data file #4
Backup set
Data file #5 Data file #6 Image copies
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.
Back 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.
Back 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.
Performing Database Backups
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 endto-end backup solution for Oracle environments: – Centralized backup management to tape for file system data and the Oracle database – Provides most well-integrated media management layer for RMAN backups – Backup of any data anywhere on the network
• •
15-4
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.
User-Managed Backup A user-managed scenario: • It is a manual process of tracking backup needs and status. • It requires the DBA to write scripts. • Database files must be put in the correct mode for backup. • Operating system commands are used 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 be: – 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 #1
Data file #2
Data file #2
Data file #3
Data file #4
Data file #3
Data file #5
Data file #6
Data file #4
Backup set
Data file #5 Data file #6 Image copies
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.
Back 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.
Back 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.
Related Documents
Performing Database Backups
May 2020 5
Performing Database Backups
December 2019 14
Database Backups[19]
June 2020 6
Backups
October 2019 16
Backups
June 2020 6
Meridian1 Backups
November 2019 13More Documents from ""
Less03 Db Dbca Mb3
December 2019 18
Less12 Proactivem Mb3
December 2019 11
Less17 Flashback Tb3
December 2019 18
Less14 Br Concepts Mb3
December 2019 13
Less04 Instance Tb3
December 2019 12