Database DataWarehousing (MOSC)

MOSC Banner

Compression Schema level when archive is enabled

edited Apr 8, 2014 12:00PM in Database DataWarehousing (MOSC) 3 commentsAnswered

Hi,

Can anyone help me on the below scenario:

I have one database where I should archive the 15-20 tables every 15 days once.

Database size is around 250 GB

On Archival process:

I am inserting the records from primary tables to archival tables.

Deleting the records @Primary tables once insert completed.

As we are taking the backup of this database through RMAN, daily incremental and weekly LEVEL-0, I can't keep the database in no archive log mode and do the archival.

Since the archive log mode is enabled, it is taking more time than expected.

I am looking for both time savings and mostly disk cost savings on this.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center