Database Reference
In-Depth Information
Figure 13-29.
Software Library setup
Backup
In a highly available Enterprise Manager Cloud Control configuration, the three components—OMS, repository, and
agent—are individually configured to reduce downtime. Although we recommend that the highest level of availability
be implemented, the associated costs and required resources may be prohibitive. Also, in any IT framework, failure
of components is likely to happen over time. As such, no high-availability architecture is complete without discussing
backup and recovery strategies.
Backing up the Enterprise Manager ecosystem requires a solution that encompasses the repository, OMS, and
agents. Each component is individually backed up based on its available methods. The management repository
database stores metrics and data provided by agents. It should be backed up according to recommended backup
strategies for Oracle databases using RMAN.
Repository Backup
The first step in configuring a backup strategy for the repository database is to ensure that it is in
ARCHIVELOG
mode.
This will allow consistent online backups to be taken and also facilitates point-in-time recovery of the database. Hot
backups should be taken regularly using recommended backup strategies. Database high-availability features such as
the Fast Recovery Area and flashback database should also be enabled to allow for faster recovery of the database in
the event of a failure. Backups can be configured by using the Enterprise Manager Cloud Control console. Consider
using Enterprise Manager's Recommended Backup Strategy option to back up the repository database.
To schedule a database backup using Enterprise Manager, follow these steps:
1.
Go to the repository database home page and choose Availability
➤
Backup & Recovery
➤
Schedule Backup.
2.
Log in as a user with SYSDBA credentials.
3.
Click the Schedule Oracle-Suggested Backup button to create a fully automated backup
strategy based on the destination for the backups (Disk, Tape, and so forth), as shown in
Figure
13-30
. The Oracle-suggested backup is based on an incrementally updated backup
strategy. It will schedule a full backup first, after which incremental backups will be
scheduled. Based on the backup, a recovery to any point in a day will be possible.
