It depends on his conditions, which we don’t know. If 1 hour is brief, DBUA is
viable and requires minimal additional planning and rehearsal. GG and other
such cloning methods will require a certain amount of network redirection and
rehearsal, as well as additional storage. Basically you trade off downtime for
front end prep. Based on his questions, I wouldn’t exclude anything yet.
Sent from my iPad
On Nov 16, 2020, at 16:21, Bobby Curtis <curtisbl@xxxxxxxxx> wrote:
Andrew,
All valid points, but why even take an outage? Data copy (export/import) or
even RMAN clone can be done while operations are still occurring for the
business. Build the upgraded database in parallel with GG, then switch over
when ready. 10 min outage, if that.
Bobby
From: "oracle-l-bounce@xxxxxxxxxxxxx" <oracle-l-bounce@xxxxxxxxxxxxx> on
behalf of Andrew Kerber <andrew.kerber@xxxxxxxxx>
Reply-To: "andrew.kerber@xxxxxxxxx" <andrew.kerber@xxxxxxxxx>
Date: Monday, November 16, 2020 at 6:11 PM
To: "smishra_97@xxxxxxxxx" <smishra_97@xxxxxxxxx>
Cc: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
Subject: Re: Database Upgrade
Well, the upgrade time really isn’t dependent on the size of the database. I
do recall there can be issues upgrading the time zone via dbua, so you don’t
want to check that option. I expect you can do the upgrade with just an hour
or so of downtime. Make sure you go through the documentation on upgrading
the standby first. If zero downtime is required, that gets a lot harder
considering the amount of data that needs to be copied.
Sent from my iPad
On Nov 16, 2020, at 16:05, Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx> wrote:
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