with standby_access causes dump transaction to dump only completed transactions. It dumps the transaction log up to the point at which there are no active transactions. If you do not use with standby_access, the entire transaction log, including records for all open transactions is dumped. A transaction log dump using with standby_access is illustrated in Figure 12-3.
Figure 12-3: Dump cut-off point for dump transaction with standby_access
In Figure 12-3, a dump transaction...with standby_access command is issued at a point where transactions T1 through T5 have completed and transaction T6 is still open. The dump cannot include T5 because T6 is still open, and it cannot include T4, because T5 is still open. Thus, the dump must stop at the end of transaction T3, where it includes completed transactions T1 through T3.
The syntax for with standby_access is:
dump tran[saction] database_name to... [with standby_access]
For more information about the with dump tran...with standby_access option, see the Reference Manual.
