Cleanup Phase - R12.2 Online Patching Cycle

Cleanup Phase

Drops now-redundant columns and other objects which are not required after the cutover phase.
It is important that we do not omit the cleanup phase.
This step can be done after instance is released to Customer
The following actions are performed during cleanup:

• Drop covered objects
• Drop indexes
• Drop forward cross-edition triggers
• Clean up seed data

Option cleanup_mode=full to be used when previously abort was used.

Scenario

You have been asked to perform the cutover phase and later you are performing the cleanup work.

When we can do it?

After releasing the instance to customer.

$ adop phase=cleanup

Enter the APPS password:

Enter the SYSTEM password:

Enter the WLSADMIN password:

 Please wait. Validating credentials...

RUN file system context file: /inst122i/applmgr/fs1/inst/apps/INST122I_testserver01/appl/admin/INST122I_testserver01.xml

PATCH file system context file: /inst122i/applmgr/fs2/inst/apps/INST122I_testserver01/appl/admin/INST122I_testserver01.xml

************* Start of  session *************

 version: 12.2.0

 started at: Sun Nov 17 2013 03:38:58

APPL_TOP is set to /inst122i/applmgr/fs1/EBSapps/appl

  Cleanup is not done in earlier session

  [START 2013/11/17 03:39:45] adzdoptl.pl run

    ADOP Session ID: 9

    Phase: cleanup

    Log file: /inst122i/applmgr/fs_ne/EBSapps/log/adop/9/adop_20131117_033835.log

    [START 2013/11/17 03:40:11] cleanup phase

      [EVENT]     [START 2013/11/17 03:40:15] Performing Cleanup steps

        [EVENT]     [START 2013/11/17 03:40:26] Running CLEANUP ddls in ddl handler table

          Calling: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=4 restart=no abandon=yes defaultsfile=/inst122i/applmgr/fs1/EBSapps/appl/admin/INST122I/adalldefaults.txt patchtop=/inst122i/applmgr/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cleanup.log driver=ucleanup.drv

          ADPATCH Log directory: /inst122i/applmgr/fs_ne/EBSapps/log/adop/9/cleanup_20131117_033835/INST122I_testserver01/log

        [EVENT]     [END   2013/11/17 03:41:08] Running CLEANUP ddls in ddl handler table

        [EVENT]     Cleaning up ABORT DDL from DDL Handler Table

        [START 2013/11/17 03:41:17] Generating All DDL Report

            [EVENT]     Report: /inst122i/applmgr/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDALLDDLS.sql

            [EVENT]     Output: /inst122i/applmgr/fs_ne/EBSapps/log/adop/9/cleanup_20131117_033835/INST122I_testserver01/adzdallddls_20131117_040807.out

        [END   2013/11/17 03:41:27] Generating All DDL Report

        [EVENT]     Calling cleanup in QUICK mode

        [WARNING]   Cleanup may take a while. Please wait.

      [EVENT]     [END   2013/11/17 04:05:47] Performing Cleanup steps

    [END   2013/11/17 04:05:54] cleanup phase

    [START 2013/11/17 04:05:59] Generating AD_ZD_LOGS Report

        [EVENT]     Report: /inst122i/applmgr/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql

        [EVENT]     Output: /inst122i/applmgr/fs_ne/EBSapps/log/adop/9/cleanup_20131117_033835/INST122I_testserver01/adzdshowlog.out

    [END   2013/11/17 04:06:04] Generating AD_ZD_LOGS Report

  [END   2013/11/17 04:06:05] adzdoptl.pl run

  adop phase=cleanup - Completed Successfully

  Log file: /inst122i/applmgr/fs_ne/EBSapps/log/adop/9/adop_20131117_033835.log

adop exiting with status = 0 (Success)

$

$ adop -status

Enter the APPS username: apps

Enter the APPS password:

Current Patching Session ID: 9

Node Name     Node Type     Phase      Status        Started                   Finished                  Elapsed

--------------- --------------- ----------- --------------- ------------------------------ ------------------------------ ------------

testserver01  master        APPLY      COMPLETED     17-NOV-13 02:49:24 -06:00        17-NOV-13 02:52:46 -06:00    0:03:22

                           CUTOVER     COMPLETED          17-NOV-13 03:13:34 -06:00        17-NOV-13 03:32:40 -06:00        0:19:06

                           CLEANUP     COMPLETED          17-NOV-13 03:40:13 -06:00        17-NOV-13 04:05:48 -06:00        0:25:35

                           PREPARE     COMPLETED          17-NOV-13 12:46:19 -06:00        17-NOV-13 01:00:28 -06:00        0:14:09

File System Synchronization Used in this Patching Cycle: None

For more information, run ADOP Status Report by using -detail option

Generating ADOP Status Report at location: /inst122i/applmgr/fs_ne/EBSapps/log/status_20131117_052313/adzdshowstatus.out

Please wait...

Done...!

adop exiting with status = 0 (Success)

$