Database Backups[19]
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 Database Backups[19] as PDF for free.
More details
- Words: 566
- Pages: 20
19 Database Backups
Copyright © 2004, 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
19-2
Copyright © 2004, 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)
19-3
Copyright © 2004, 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
19-4
Copyright © 2004, Oracle. All rights reserved.
Recovery Manager (RMAN) Enterprise Manager uses Recovery Manager (RMAN) to perform backup and recovery operations. • Command-line client for advanced functions • Powerful control and scripting language • Published API that allows interface with most popular backup software • Backs up data, control, archived log, and server parameter files • Backs up files to disk or tape
19-5
Copyright © 2004, Oracle. All rights reserved.
Configuring Backup Settings
19-6
Copyright © 2004, Oracle. All rights reserved.
Configuring Backup Settings
19-7
Copyright © 2004, Oracle. All rights reserved.
Scheduling Backups: Strategy Choose whole or partial database backup.
19-8
Copyright © 2004, Oracle. All rights reserved.
Scheduling Backups: Options
19-9
Copyright © 2004, Oracle. All rights reserved.
Scheduling Backups: Settings
Persistent backup configuration settings can be overridden for this backup by clicking Override Current Settings. 19-10
Copyright © 2004, Oracle. All rights reserved.
Scheduling Backups: Schedule
19-11
Copyright © 2004, Oracle. All rights reserved.
Scheduling Backups: Review
Click Edit RMAN Script to review RMAN commands.
19-12
Copyright © 2004, Oracle. All rights reserved.
Backup Control File to Trace Control files have an additional backup option.
Control file trace backups may be used to recover from loss of all control files.
19-13
Copyright © 2004, Oracle. All rights reserved.
Backup Control File To Trace Full Notes Page
19-14
Copyright © 2004, Oracle. All rights reserved.
Manage Backups
Click Edit RMAN Script to review RMAN commands. 19-15
Copyright © 2004, Oracle. All rights reserved.
Flash Recovery Area Monitor the Flash Recovery Area • Configure flashback logging • Size the recovery area • Monitor current space consumption
19-16
Copyright © 2004, 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
19-17
Copyright © 2004, Oracle. All rights reserved.
Practice 19: Database Backups This practice covers the following: • 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
19-18
Copyright © 2004, Oracle. All rights reserved.
Practice Lesson 19 Full Notes Page
19-19
Copyright © 2004, Oracle. All rights reserved.
19-20
Copyright © 2004, Oracle. All rights reserved.
Copyright © 2004, 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
19-2
Copyright © 2004, 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)
19-3
Copyright © 2004, 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
19-4
Copyright © 2004, Oracle. All rights reserved.
Recovery Manager (RMAN) Enterprise Manager uses Recovery Manager (RMAN) to perform backup and recovery operations. • Command-line client for advanced functions • Powerful control and scripting language • Published API that allows interface with most popular backup software • Backs up data, control, archived log, and server parameter files • Backs up files to disk or tape
19-5
Copyright © 2004, Oracle. All rights reserved.
Configuring Backup Settings
19-6
Copyright © 2004, Oracle. All rights reserved.
Configuring Backup Settings
19-7
Copyright © 2004, Oracle. All rights reserved.
Scheduling Backups: Strategy Choose whole or partial database backup.
19-8
Copyright © 2004, Oracle. All rights reserved.
Scheduling Backups: Options
19-9
Copyright © 2004, Oracle. All rights reserved.
Scheduling Backups: Settings
Persistent backup configuration settings can be overridden for this backup by clicking Override Current Settings. 19-10
Copyright © 2004, Oracle. All rights reserved.
Scheduling Backups: Schedule
19-11
Copyright © 2004, Oracle. All rights reserved.
Scheduling Backups: Review
Click Edit RMAN Script to review RMAN commands.
19-12
Copyright © 2004, Oracle. All rights reserved.
Backup Control File to Trace Control files have an additional backup option.
Control file trace backups may be used to recover from loss of all control files.
19-13
Copyright © 2004, Oracle. All rights reserved.
Backup Control File To Trace Full Notes Page
19-14
Copyright © 2004, Oracle. All rights reserved.
Manage Backups
Click Edit RMAN Script to review RMAN commands. 19-15
Copyright © 2004, Oracle. All rights reserved.
Flash Recovery Area Monitor the Flash Recovery Area • Configure flashback logging • Size the recovery area • Monitor current space consumption
19-16
Copyright © 2004, 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
19-17
Copyright © 2004, Oracle. All rights reserved.
Practice 19: Database Backups This practice covers the following: • 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
19-18
Copyright © 2004, Oracle. All rights reserved.
Practice Lesson 19 Full Notes Page
19-19
Copyright © 2004, Oracle. All rights reserved.
19-20
Copyright © 2004, Oracle. All rights reserved.
