Re: online-backups

Laurie D. Miller wrote:
<snip>
> Yes, hot backups can be executed while the instance is up. In fact,
> that is why they are called hot backups. Generally, you take
> a tablespace offline, backup it up, and put back online. Also,
<snip>

Laurie,
Hot backups don't take the tablespaces offline. It just stamps the header
of the datafile with the redolog sequence number so it knows where to start recovery if that backup copy is used for a restoral. Oracle continues to write to the datafile during the backup procedure. When you are finished, it updates the header once again (see 'alter tablespace
begin|end backup' from sqldba). This is no additional overhead required internally by Oracle during a hot backup.

-- 
---
Allen Kirby			AT&T ITS Production Services
akirby_at_att.com			Alpharetta, GA.