Identify your log file location, and review the CDB and PDB log files.

Identify your log file location, and review the Non-CDB log files.

To restart a multitenant upgrade from a failed phase, first identify which PDB created the error and then search its appropriate log file for the error.

1. Locate log files with errors.

   For example:

   Linux and Unix

   $ grep -i 'error at line' catupgrd*.log 
   

   Windows

   C:\> find /I "error at line" catupgrd*.log
   

   The grep or find command displays the filenames of log files in which an error is found.
2. Check each log file that has an error and identify where the first error occurred. Use the text editor of your choice to review each log file. Search for the first occurrence of the phrase error at line'. When you find the phrase, then search backwards from the error (reverse search) for PHASE_TIME___START.

   For example:

   PHASE_TIME___START 15 15-01-16 08:49:41
   

   The number after PHASE_TIME___START is the phase number where the error has occurred. In this example, the phase number is 15.

   Each log file can have an error in it. Repeat checking for the phrase PHASE_TIME___START, and identify the phase number with errors for each log file that contains an error, and identify the log file that contains the lowest phase number.

   The log file that contains the lowest phase number is restart phase number, which is the phase number from which you restart the upgrade.

   For example:

   catupgrd0.log error occurred in phase 15:
   
   PHASE_TIME___START 15 15-01-16 08:49:41
   
   catupgrd1.log error occurred in phase 19:
   
   PHASE_TIME___START 19 15-01-16 08:50:01
   

   In this example, the restart phase number is 15. Ensure that you identify the first error seen in all the log files, so that you can restart the upgrade from that phase.

3. Restart the upgrade from the failed phase by changing directory to the running the Parallel Upgrade Utility (catctl.pl, which you can run from the command line using dbupgrade on Linux and Unix, and dbupgrade.cmd on Windows). Use the -p flag to indicate that you want to restart the upgrade from a phase, and provide the restart phase number. In multitenant databases, also use the -c flag using the syntax -c 'PDBname', where PDBname is the name of the PDB where the failure occurred.

   For example:

   Non-CDB Oracle Database on a Linux or UNIX system:

   cd $ORACLE_HOME/bin
   dbupgrade -p 15

   PDB in a multitenant Oracle Database (CDB) on a Windows system:

   cd $ORACLE_HOME/bin
   dbupgrade -p 15 -c 'PDB1'

   In both examples, the upgrade is restarted from phase 15, identified with the -p flag. In the multitenant example, the PDB with the error is identified with the -c flag.
   In these examples, the upgrade starts from phase 15 and runs to the end of the upgrade.
4. (Optional) You can also run the phase that contained an error by specifying a stop phase, using the -P flag. Using a stop phase allows the upgrade to just rerun that phase in which the error occurred. You can determine quickly if the error is fixed by running it on the phase with the error, without running the entire upgrade.

   For example, using the Perl script Parallel Upgrade Utility command option:

   cd $ORACLE_HOME/rdbms/admin
   $ORACLE_HOME/perl/bin/perl catctl.pl -p 15 -P 15 -c 'PDB1' 

   After you confirm that the error is fixed in the phase with the error, you can then resume the upgrade after that phase.

   For example, if you have confirmed that the error in phase 15 of your multitenant database upgrade of PDB1 is fixed, then you can use the following command on Linux and Unix systems to continue the upgrade at phase 16:

   cd $ORACLE_HOME/bin dbupgrade -p 16 -c 'PDB1'