Post by when we issue dump database and dump transaction what will happen to the
1. processes which are having open transactions
2. processes which have comitted/rollback in middle of the dump statement
3. truncate table command
unable to understand stand_by option completely.
regards
ram
Processes that are actively processing generally can continue doing so while
the dump is occurring. Near the end of the dump, they may be blocked or
suspended for a short time.
The dumps (both kinds) include the transaction log, processes that have open
transactions (one that is being rolled back is still open) will have
incomplete transactions
in syslogs. When the dumps are loaded and an online command is run, any
incomplete
transactions will be rolled back. (One that was being rolled back will be
completely
rolled back, but some of the work of modifying data pages will already have
been done,
making rocovery faster).
The "standby" option to dump tran dumps only the transaction log records from
the
beginning to the log to the last point where there were no open transactions
(there might
not be such a moment), so that when it is loaded and onlined, there is no
rollback work to
do.
-bret