Re: Advise with Oracle data warehouse

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Sat, 26 Apr 2003 06:47:34 +0200
Message-ID: <fm3kav0u5ru0v4scpepvpdpduhs7uth4o5@4ax.com>

On Fri, 25 Apr 2003 23:11:47 GMT, "Oradba Linux" <oradba_linux_at_attbi.com> wrote:

>Noarchivelog mode
>
>"Jason Rowski" <jasonrowski_at_yahoo.com> wrote in message
>news:dcb589c5.0304251432.3945eb8d_at_posting.google.com...
>> Hi,
>>
>> Should we enable archiving on big data warehouses ? What is the
>> recommended configuration of redo logs ( how many ? size ? ) for big
>> data warehouse ?
>>
>> Any help will be appreciated.
>>
>> Thanks
>> Jason
>

I don't think any database running in noarchivelog mode can be considered as a production database.
As the transaction volume on a datawarehouse is low, running in archivelog shouldn't be an issue, and it is quite simple to set tablespaces and partitions to read-only. How are you going to recover your noarchivelog datawarehouse? Export/import? You are making jokes, aren't you?

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Apr 25 2003 - 23:47:34 CDT