Re: Database Upgrade

 Bobby
Yes Application is very critical and goal is to avoid not only less downtime but to make sure that fallback to old setup should not take long time for any issue. TxSanjay

    On Monday, November 16, 2020, 06:09:10 PM EST, Bobby Curtis <curtisbl_at_gmail.com> wrote:  

 #yiv6214280243 #yiv6214280243 -- _filtered {} _filtered {}#yiv6214280243 #yiv6214280243 p.yiv6214280243MsoNormal, #yiv6214280243 li.yiv6214280243MsoNormal, #yiv6214280243 div.yiv6214280243MsoNormal {margin:0in;font-size:11.0pt;font-family:sans-serif;}#yiv6214280243 a:link, #yiv6214280243 span.yiv6214280243MsoHyperlink {color:#0563C1;text-decoration:underline;}#yiv6214280243 span.yiv6214280243EmailStyle18 {font-family:sans-serif;color:windowtext;}#yiv6214280243 .yiv6214280243MsoChpDefault {font-size:10.0pt;} _filtered {}#yiv6214280243 div.yiv6214280243WordSection1 {}#yiv6214280243 _filtered {}#yiv6214280243 ol {margin-bottom:0in;}#yiv6214280243 ul {margin-bottom:0in;}#yiv6214280243 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