Re: The old raw devices chestnut.

From: Tanel Põder <change_to_my_first_name_at_integrid.info>
Date: Thu, 15 Apr 2004 12:54:26 +0300
Message-ID: <407e5bd3$1_1@news.estpak.ee>

> From what I remember of Oracle's "basic" backup tool (and I haven't
> had much to do with it since 8.1.6) you have to put tablespaces
> (equivalent to our dbspaces) into "backup mode" before you can back
> them up which means they can't be written to. It's also typical to do

This is a myth.

Backup mode doesn't stall any writes to the tablespaces - you can perfectly do all of the read/write operations on a tablespace in backup mode just as on a tablesace not in backup mode. Oracle just may do some additional redo logging if necessary to guarantee the consistency of the database.

This has worked such way since version 7, maybe even before...

Tanel. Received on Thu Apr 15 2004 - 04:54:26 CDT