Database Reference
In-Depth Information
Table 3-7. RAP Phase IV Database Backup Strategy
Schedule
Level 0
Saturday at 1700 hours
Level 1
Sunday thru Friday at 1700 Hours
Archive log backup
Daily at 100, 400, 700, 1000, 1300, 1500, 2200 hours
Destination
Backup to ASM diskgroup +PRDDB_FRA
Retention
Keep the most recent 7 days backup at +PRDDB_FRA
Keep the most recent 1 day's archive log backups in +PRDDB_FRA
Size
RMAN backup : Average 1 TB
Step 2
After the backup strategy is completed and reviewed with the team, the next step is to test the backup process. Either
using scripts or using Oracle Grid Control, the database and other related components should be backed up. Along
with the logs from the backup operations, the time taken to complete each stage of the backup should be recorded.
Table 3-8 lists the various components to be backed up and the time taken for backing up these components.
Table 3-8. RAP Phase IV Backup Components
Backup Component
Location
Method
Time
Software
Tape backup
Grid Infrastructure
$GRID_HOME
RDBMS Binaries
$ORACLE_HOME
ASM
SPFile
Disk/Tape backup
Metadata
Disk/Tape backup
OCR
$GRID_HOME/cdata/PRDDBCW/
Disk/Tape backup
OLR
$GRID_HOME/cdata/PRDDBCW/
Disk/Tape backup
Database
Disk/Tape backup
Level 0
+PRDDB_FRA
Level 1
+PRDDB_FRA
Archive logs
+PRDDB_FRA
Note: RDBMS = relational database management system; SPFile = server parameter file.
In addition to the time taken to back up the various components, it's also important to record the scalability of
these backup operations. How many parallel slaves were used to back up the database? How many RAC instances
participated in the backup operation? How many backup sets and how many backup sets per instance were used?
 
Search WWH ::




Custom Search