Re: Recovery

From: Sambavan <sambavan_at_mail.utexas.edu>
Date: Tue, 03 Oct 2000 19:44:09 GMT
Message-ID: <8rdcu7$ajp$1@nnrp1.deja.com>

Instead of taking the tablespace off-line and disrupting the read-write process on the tablespace, the database places the tablespace in the read-only mode as a result the users would be able to do any kind of query on the tables that were on the tablespace but no, other ddls and dmls are permitted on it. When you take the tablespace to the backup mode, a check point will be performed on that tablespace. This also prevents the sequence number in the datafile header from changing, so that in case of recovery, logs are applied from backup start-time. So overall, it permits the database to be in normal transactional mode.

I hope this would explain things to an extent. Sam

In article <8rd2ip$gg2$1_at_bob.news.rcn.net>, "Roman Gelfand" <rgelfand_at_masmid.com> wrote:
> Can someone give me a general idea as to what is taking place where
alter
> tablespace start backup command is issued?
>
> Thanks,
>
> Roman
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 03 2000 - 14:44:09 CDT