Compression Schema level when archive is enabled
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.