How to drop Old Database edition in R12.2

 Dropping old database editions:

As online patching cycles are completed, the system will build up several old database editions. When the number of old database editions reach about 25, you should consider running a special maintenance operation to drop old database editions.

Use below script to find DB edition details

Cd $AD_TOP/sql/ADZDSHOWED.sql

Output:

SQL> @ADZDSHOWED.sql

=========================================================================

= Editions

=========================================================================

Edition Name Type Status Current?

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

V_20210318_1313 ACTIVE

V_20210323_0209 ACTIVE

V_20210421_0706 ACTIVE

V_20210428_1036 ACTIVE

V_20210505_0620 OLD ACTIVE

V_20210507_2006 RUN ACTIVE CURRENT

Disconnected from Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production

Actualize_All and Full Cleanup will clear the old database

Example

adop phase=prepare

adop phase=actualize_all

adop phase=finalize

adop phase=cutover

adop phase=cleanup cleanup_mode=full

Note:

This maintenance operation will take much longer than a typical online patching cycle and should only be performed when there is no immediate need to start a new online patching cycle.

We can execute Actualize_All and Full Cleanup combined with part of patching

Example:

adop phase=prepare

adop phase=apply patches=123456,765101,11121314

adop phase=actualize_all

adop phase=finalize

adop phase=cutover

adop phase=cleanup cleanup_mode=full

adop exiting with status = 0 (Success)

Comments

Popular posts from this blog

How to troubleshoot long running concurrent request in R12.2

How to run Gather Schema Statistics in R12.2

How to compile forms in R12.2