AutoUpgrade Log File Structure

The AutoUpgrade utility produces a log file structure that includes job status and configuration files

AutoUpgrade Log File Base Path

The AutoUpgrade log file path is set using the global parameter autoupg_log_dir. By default, the global parameter has the following definition:

AutoUpgrade configuration and status file paths are relative to the directory path that you establish with global.autoupgr_log_dir.


The automatic configuration tools log directory (/cfgtoollogs/upgrade/auto) contains specific information about each job that the AutoUpgrade job manager processes. You can use information in these directories to determine problems when jobs start or stop.

The AutoUpgrade utility maintains an AutoUpgrade log file for all AutoUpgrade jobs:


The autoupgrade.log file contains two log files that provide further details about AutoUpgrade job starts and stops, which can assist you with debugging:

  • user_autoupgrade.log: Job information, which is formatted to enhance readability.

  • autoupgrade_err.log: A report of any unexpected exceptions that occur when the job runs.


The config_files directory contains AutoUpgrade internal runtime configurations and global temporary files.


The /status directory contains JSON job status files. It contains two directories:

  • status.json: This directory contains the final job status of all jobs completed in the JSON file format.

  • progress.json: This directory contains the progress of all jobs currently running in the JSON file format.

Each module in the directories contains a status file for the operation that it performed. The module takes the following format, where the prefix dbname is the database name, operation is the upgrade operation that was performed, and the suffix status is the completion status of that operation:


The success or the failure of that operation is indicated by the suffix, which is either .success, indicating the successful performance of that operation, or .failure, indicating the failure of that operation. For example, the following module name indicates a successful run of the prechecks operation on the database sales:


The operation module name can be one of the following:

  • preupgrade: The preupgrade stage, in which custom scripts can be run.

  • prechecks: The upgrade checks completed before starting the upgrade.

  • grp: Guaranteed restore point (using Oracle Flashback technology)

  • prefixups: The preupgrade fixups run before starting the upgrade

  • drain: The stage where existing jobs are completed or migrated before starting the upgrade.

  • dbupgrade: The stage in which the upgrade takes place.

  • postchecks: The stage in which postupgrade checks are run after the upgrade is completed.

  • postfixups: The stage in which postupgrade fixups are run.

  • postupgrade: The stage in which custom postupgrade scripts can be run.

Individual Job and Database Log File Directories

Each job started by the AutoUpgrade dispatcher is given a directory with that job identifier prefix. Inside that job directory, each database in the job is given a log directory in the path /database/logs/sid, where sid is the system identifier for the database. For example, where the job identified in the configuration file is sales1, and the database system identifier is sales, the log file for the database sales is in the following path:


The log directory contain all the relevant log files for all the tasks performed for that database. By default, a directory identified by SID is created under the /database/logs directory. Each database job can have a separate log directory, if you choose to set up your configuration file that way.

/#### ( Job Number)

Individual job runs are placed in subdirectories identified by the run number, in the format /####, where #### represents the run number. For example: 0004. Run number directories contain the following log files:

  • autoupgrade_err.log: Reports any unexpected exceptions that occur while the job runs.

  • autoupgrade.log: AutoUpgrade trace log file. Provides detailed logs of the job that identify any problems that occur during job runs.

  • user_autoupgrade.log: AutoUpgrade job status file, which is formatted to enhance readability.


The preupgrade directory (/preupgrade) contains the following files and log files:

  • preupgrade_source.log: Trace log file. This file provides detailed logs that can assist with identifying problems that occur during the preupgrade job stage.

  • SOURCE.html: Graphical user interface displaying a report on the database status.

  • SOURCE_preupgrade.log: Text user interface displaying a report on the database status.


The database upgrade directory (/dbupgrade) contains all log files associated with the database upgrade:

  • autoupgradeYYYYMMDDHHMNSCdbname.log: log files for the source database, identified by the date on which the upgrade was run, and by the database name, indicating parallelism. Format:

    • YYYY: Year

    • MM: Month

    • DD: Day

    • HH: Hour

    • MN: Minute

    • SC: Second

    • dbname: Database name, where dbname is the database name.

  • catupgradeYYYYMMDDHHMNSCdbnameN.log: log files for the source database, identified by the date on which the upgrade was run.


    • YYYY: Year

    • MM: Month

    • DD: Day

    • HH: Hour

    • MN: Minute

    • SC: Second

    • dbnameN: Database name, where dbname is the database name, and N indicates the parallelism: 0...3 for CDB ROOT, and Non-CDB databases, and 0...1 for PDBs.


Temporary AutoUpgrade files (/temp). This directory can contain files such as the PFILE used during an upgrade.