Re: VLDB Refresh

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 24 Feb 2020 22:20:13 +0000
Message-ID: <LNXP265MB1562289A2C34771DD6C0C75BA5EC0_at_LNXP265MB1562.GBRP265.PROD.OUTLOOK.COM>

A fairly standard strategy when the bulk of the database is in time-based partitions - which seems possible in your case - is to have time-related tablespaces and make "older" tablespaces read-only as soon as the data they contain stops changing. Then you can use transportable tablespaces to get the old tablespaces to the test system as a one-off exercise and only use a backup/recover type of strategy for the most recent data.

Regards
Jonathan Lewis

---

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Sanjay Mishra <dmarc-noreply_at_freelists.org> Sent: 24 February 2020 22:14
To: Oracle-L Freelists
Subject: VLDB Refresh

Do we have any better way to refresh Test with Production when the database is very big like close to 100Tb? The requirement is not the timing which anyway using Tape backup will take day or more based on Tape library But looking for the following points

1. Only One Application Schema in the database using Bigfile Tablespace
2. Contains multiple Table with LOBs Partitioned
3. All Big tables are monthly Partitioned with 2 years of Data in all

So now looking to refresh Test with only last 3-6 months of data using a monthly partition. It cannot use Datapump not only due to several Terabytes but also cannot put any load on the critical Production environment. Does Oracle provide such features using any backup technologies including Oracle ZDLRA or any new features that can help to not only refresh the Test environment but also take lesser storage?

TIA
Sanjay

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 24 2020 - 23:20:13 CET