Bobby
Sorry for to add more details
It is Hybrid OLTP/Warehouse environment and heavily monthly partitioned.
Application is PEGASoftware
TxSanjay
On Monday, November 16, 2020, 06:10:01 PM EST, Bobby Curtis
<curtisbl@xxxxxxxxx> wrote:
#yiv1218017988 #yiv1218017988 -- _filtered {} _filtered {}#yiv1218017988
#yiv1218017988 p.yiv1218017988MsoNormal, #yiv1218017988
li.yiv1218017988MsoNormal, #yiv1218017988 div.yiv1218017988MsoNormal
{margin:0in;font-size:11.0pt;font-family:sans-serif;}#yiv1218017988 a:link,
#yiv1218017988 span.yiv1218017988MsoHyperlink
{color:#0563C1;text-decoration:underline;}#yiv1218017988
span.yiv1218017988EmailStyle18
{font-family:sans-serif;color:windowtext;}#yiv1218017988
.yiv1218017988MsoChpDefault {font-size:10.0pt;} _filtered {}#yiv1218017988
div.yiv1218017988WordSection1 {}#yiv1218017988 _filtered {}#yiv1218017988 ol
{margin-bottom:0in;}#yiv1218017988 ul {margin-bottom:0in;}#yiv1218017988
Just a few questions, is the application critical? From your email, I’m
assuming it is.
What is the database for?
What application or service?
Oracle GoldenGate would be the easiest way to ensure that you don’t take a
outage/downtime.
Let me know how I can help you move forward.
Thanks
Bobby Curtis
Bobby.curtis@xxxxxxxxxxxx
From: "oracle-l-bounce@xxxxxxxxxxxxx" <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx>
Reply-To: "smishra_97@xxxxxxxxx" <smishra_97@xxxxxxxxx>
Date: Monday, November 16, 2020 at 6:04 PM
To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
Subject: Database Upgrade
Hi Everyone
I had 160 Tb Database in 12.2 and had to upgrade to 19c. Can you please suggest
the best option that can help to update with small downtime and also option to
rollback for any failure without going for big Restore that can take day for
the restore. Some details for the database and option that can be used are
- 12.2 is CDB with one PDB that has to be upgraded
- ASM storage has additional 200 Tb available to be used for this upgrade
purpose ,if required for any option
- It is Exadata with two node
- Environment also has Dataguard on another Data Center with same hardware
like primary
- Golden Gate license is available for any option that can save downtime
Thanks for your time and suggestion
Sanjay