backup a 3TB datawarehouse : LUSENET : DBAzine : One Thread


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 (, July 20, 2004

Moderation questions? read the FAQ