Bringing databases online with standby_access

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

Graphic showing a bar graph of transaction dumps and the placement of the dump cut-off point during these dumps.

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.

Syntax

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.