Interesting situation this morning.
I was performing a database upgrade from 11.2 to 12.2 when my VPN crashed.
I realized that I forgot to start the upgrade process using linux screen terminal which means that my upgrade process was lost.
Well, Oracle 12.2 has the ability to resume a failed upgrade process from the failed step automatically !
From the Oracle Docs:
Oracle Database 12c release 2 (12.2) includes a new Resume option for Parallel Upgrade Utility. This option is available for both CDBs and Non-CDBs. You are not required to identify failed or incomplete phases when you rerun or restart the upgrade. When you use the Parallel Upgrade Utility using the resume option (
-R), the utility automatically detects phases from the previous upgrade that are not completed successfully. The Parallel Upgrade Utility then reruns or restarts just these phases that did not complete successfully, so that the upgrade is completed. Bypassing steps that already completed successfully reduces the amount of time it takes to rerun the upgrade.
So I just ran $ORACLE_HOME/bin/dbupgrade -n 4 -R -l $ORACLE_HOME/diagnostics and the upgrade process was restarted.
Cool new feature, right ?
More info about it here.