Re: Online tablespace hot backup

when you bring a tablespace in backup mode you can do all dml and all select,... the main thing thats changed is that the whole block affekted by a transaction is written to the redo log.

SC wrote:
>
> I am confused with a basic concept of Online Tablespace Backup.
> Once the command "alter tablespace <tbs_name> begin backup;"
> is issued, what happens to the status of that tbs?
>
> If any DML is issued for the data stored in this tablespace,
> what happens? Does the user gets the error or user doesn't
> even realise that the tbs is currently backed up?
>
> During hot backup, is the tablespace still available
> for query or updates? or Is the tablespace header frozen
> and updates are recorded in redo logs?
> If this is the case, then when (and how) are those changes
> applied to this tbs?
>
> Any comments would be appreciated.
> Thanks.
>
> -------
> SC
> S_C_99_at_hotmail.com
Received on Wed Apr 26 2000 - 00:00:00 CDT