Hi,

I would need to implement a backup/recovery policy for a datawarehouse quite large. The db is not in archivelog mode and we would like to consume the least space and time possible. Currently there is a logical backup exporting the tables that have been modified looking at dba_tab_modifications. The alternative I'm thinking of is to implement a physical cold backup whith SQL Backtrack. Full during the week-end and incremental some week days. If we need to recover just a table, we could duplicate a database with just the tablespace needed and export the table. What do you think of this option? Any other recommendation? Thanks and best regards.

Manuel

-- manuel (manuel_moreno@bmc.com), July 20, 2004