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
Post a Comment