In the following sections, you will see how to choose the primary backup method for your
database, how to integrate logical and physical backups, and how to integrate database backups
with file system backups. For backup strategies specific to very large databases, see Chapter 16.
For details on RMAN, see Chapter 12.
Integration of Logical and Physical Backups
Which backup method is appropriate to use as the primary backup method for your database?
When deciding, you should take into account the characteristics of each method:
Method Type Recovery Characteristics
Data Pump Export Logical Can recover any database object to its status as
of the moment it was exported.
Offline backups Physical Can recover the database to its status as of the
moment it was shut down. If the database is
run in ARCHIVELOG mode, you can recover
the database to a status at any point in time.
Online backups Physical Can recover the database to its status at any
point in time.
Offline backups are the least flexible method of backing up the database if the database is
running in NOARCHIVELOG mode. Offline backups are a point-in-time snapshot of the database.
Also, because they are a physical backup, DBAs cannot selectively recover logical objects (such
as tables) from them. Although there are times when they are appropriate (such as for disaster
recovery), offline backups should normally be used as a fallback in case your primary method
fails.
Pages:
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647