Bringing Databases Online with standby_access

Use the with standby_access parameter of 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.

In this example, 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. The dump must stop at the end of T3 (which is just before the dump cut-off point), where it includes completed transactions T1 through T3.

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.
Use dump tran[saction]...with standby_access when you are loading two or more transaction logs in sequence, and you want the database to be online between loads; for example, if you have a read-only database that gets its data by loading transaction dumps from a primary database.
  1. On the primary database: dump tran[saction]...with standby_access
  2. On the read-only database: load tran[saction]...
  3. On the read-only database: online database for standby_access
Warning!   If a transaction log contains open transactions, and you dump it without using with standby_access, SAP ASE does not allow you to load the log, bring the database online, and then load a subsequent transaction dump. If you are going to load a series of transaction dumps, you can bring the database online only after loading a dump originally made with standby_access, or after loading the entire series.

The online database command also includes a with standby_access option. Use for standby_access to bring a database online after loading it with a dump that was made using the with standby_access option.

Warning!   If you try to use online database for standby_access with a transaction log that was not dumped using the with standby_access option, the command fails.

See the Reference Manual: Commands.

Parent topic: Backing Up and Restoring User Databases