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
On the new run file system:
adop phase=cleanup cleanup_mode=full
$sqlplus apps/<apps password> @$AD_TOP/sql/ADZDRUNCLEANUNUSE.sql
Note:
The script ADZDRUNCLEANUNUSE.sql forces the database to run edition cleanup immediately, an operation that is normally performed in the background because of the performance overhead. After the run of this script is complete, there should only be one edition in the database.
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
$sqlplus apps/<apps password> @$AD_TOP/sql/ADZDRUNCLEANUNUSE.sql
Comments
Post a Comment