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: 715
- 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 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
• •
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: • 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 #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.
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.
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 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
• •
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: • 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 #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.
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.
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 ""
Les 05
May 2020 15
Les 07
May 2020 12
Less05 Storage Tb3
May 2020 16
Installing The Oracle Database Software
May 2020 15
Les 09
May 2020 13