Re: Database Upgrade

 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_at_gmail.com> 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_at_rheodata.com  

From: "oracle-l-bounce_at_freelists.org" <oracle-l-bounce_at_freelists.org> on behalf of Sanjay Mishra <dmarc-noreply_at_freelists.org> Reply-To: "smishra_97_at_yahoo.com" <smishra_97_at_yahoo.com> Date: Monday, November 16, 2020 at 6:04 PM To: Oracle-L Freelists <oracle-l_at_freelists.org> 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    

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