-
Perform a complete restoration of the full-table archive:
RESTORE DATA TABLES (SYSDBA.TransactionHistory), RELEASE LOCK, FILE=ARCHIVE;
-
Perform a full restoration of the differential and incremental archives (in order):
RESTORE DATA TABLES(SYSDBA.TransactionHistory) (ALL PARTITIONS), RELEASE LOCK, FILE=ARCHIVE;
-
(Optional) If a separate partition backup is performed due to an update of a non-active partition, restore the separate partition backup after (or instead of) the differential or incremental backup that contains the updated partition:
RESTORE DATA TABLES (SYSDBA.TransactionHistory) ( PARTITIONS WHERE (! TransactionDate = DATE ‘2004-03-15’ !) ), RELEASE LOCK, FILE=ARCHIVE;
Individual partitions can also be restored from a full-table or selected-partition archive. To restore individual partitions, specify the partitions to be restored in a PARTITIONS WHERE expression:
RESTORE DATA TABLES (SYSDBA.TransactionHistory) ( PARTITIONS WHERE (! TransactionDate BETWEEN DATE ‘2004-05-01’ AND DATE ‘2004-05-31’!) ), RELEASE LOCK, FILE=ARCHIVE;