VLDB Refresh

From: Sanjay Mishra <"Sanjay>
Date: Mon, 24 Feb 2020 22:14:27 +0000 (UTC)
Message-ID: <323307348.1080688.1582582467797_at_mail.yahoo.com>



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 points1. Only One Application Schema in the database using Bigfile Tablespace2. Contains multiple Table with LOBs Partitioned3. 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? TIASanjay

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 24 2020 - 23:14:27 CET

Original text of this message