online backups

From: Brian Weedman <wbrian_at_my-deja.com>
Date: Tue, 02 Nov 1999 14:40:56 GMT
Message-ID: <7vmt5p$vij$1@nnrp1.deja.com>

I have a question about doing online backups.

We currently have archive logging enabled. Our Unix system admins are backuping the oracle database by doing a alter tablespace begin backup and
then issuing a unix cp command to copy the datafile(s) for that tablespace. Then they issue the alter tablespace end backup.

The question is this. while they are backuping up (takes about 31/2 hours to complete) we are performing table loads. These loads are truncating tables and then programs are inserting into them.

Will this cause the backup files to be possibly corrupt?

Will the truncate cause problems since this is a non-logged action?

Can you safely do a backup while mass updates/inserts and truncates are being performed?

--
Brian Weedman
brianw_at_my-deja.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 02 1999 - 08:40:56 CST