Please enable JavaScript.
Coggle requires JavaScript to display documents.
Performing Database Backups (RMAN (integrated with enterprise manager,…
Performing Database Backups
backups can be performed by using:
oracle secure backup
user-managed backup
recovery manager RMAN (recommended)
oracle secure backup
media management
backup anywhere on network
backup from any source
can handle any network configuration
complete backup solution
provides data protection and security
RMAN + OSB = fully integrated backup solution
user managed backup(scenario):
typically uses your own written scripts
requires that database files be put in correct mode for backup
is a manual process of tracking backup needs and status
relies on operating system commands to make backup of files
terminology
backup type may indicate inclusion of
all data blocks within your chosen files
only information that has changed since previous backup
cumulative(changes since last level 0)
differential (changes since last incremental)
backup mode may be: offline(consistent, cold) or online(inconsistent, hot)
backup strategy may include
entire db
portion of the db
backups may be stored as
image copies
backup sets
RMAN
integrated with enterprise manager
published API that enables interface with most popular backup software
provides MML to allow backups on tape (long term storage)
backing up data, control, archived log, and server parameter files
uses job control scripting language
backing up files to the disk or tape
monitoring the fast recovery area
verifies how much of fast recovery area is consumed
location and size defined, configure the flashback db, specify retention time