Creating an efficient backup strategy is important to reduce your recover time. If your system is critical, the backup procedure must be setup accordingly to meet the SLA requirements.
For OCM exam, I have no idea what they will ask. Keep in mind to trace some plan to restore/recover what you need in the most efficient way.
Thus, practice:
- Back up the whole system or single tablespaces / datafiles
- Back up archive logs
- Creating backup as copy / backupset / compressed backupset
- Recover your backups to gain time during restore/recover
- Switch datafiles to copy to avoid the time need to restore
- Backup full / incremental (diferential/cumulative)
- Crosscheck backup / archive log
- Validate / Backup Validate / Restore Validate (including LOGICAL check)
- "List" / "Report" syntax
- DBA views to check corruption / free FRA space / configuration / backup files
Path to Documentation:
Oracle Database Backup and Recovery User's Guide -> 9 Backing Up the Database
Oracle Database Backup and Recovery User's Guide -> 10 Backing Up the Database: Advanced Topics
Oracle Database Backup and Recovery User's Guide -> 16 Validating Database Files and Backups
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!
