backup without archivelog mode

HiYa

if I have a database that is more like a datawarehouse in that it gets load files loaded into it nightly, but no other transactions take place
that involve the update or insert of data during working hours, can I back this up with simply copying the datafiles, control files ...?

I thought that there is no point in making archive redo logs as really all that will happen between sqlloads is some complex selects using packaged procedures, nothing that is transation oriented.

If I copy the database files is there any meaning in issuing an alter tablespace boing_said_zebedee begin backup; command? will this be needed to gurantee consistency (in case a load is timed at the same point
as the backup)? Is there any point in archiving redologs in this situation.

Also I was thinking of a weekend down and full cold backup. As there will be no data loaded in this period, and no users on it either.

thanks for your time Received on Sat Mar 23 2002 - 01:06:29 CST