For more information about the different types of backups and variations on these
types, please refer to your Oracle documentation as well as the third-party books
listed in Appendix B.
Using Backups to Recover
Two basic types of recovery are possible with Oracle, based on whether or youare
archiving the redo logs:
Complete database recovery
If the database did not archive redo logs, only a complete cold backup is possible.
Correspondingly, only a complete database recovery can be performed. You
restore the database files, redo logs, and control files from the backup. The database
is essentially restored as of the time of the backup. All work done since the
time of the backup is lost and a complete recovery must be performed even if only
one of the datafiles is damaged. The potential for lost work, coupled with the need
to restore the entire database to correct partial failure, are reasons most shops avoid
this situation by running their databases in ARCHIVELOG mode. Figure 11-8 illustrates
backup and recovery for a database without archived redo logs.
Pages:
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605