Posts

Showing posts from May, 2021

Error: Edit session is enabled in domain.Please activate all of your changes before proceed clone

cd /apps/applmgr/fs2/FMW_Home/user_projects/domains/EBS_domain $ mv edit.lock edit.lockOLD $ cd $ADMIN_SCRIPT_HOME $ ./adadminsrvctl.sh stop and strt the services Re-try the preclone

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

How to create DB restore point in 19C Database

What is Restore point? Flashback database can reverse the changes and can take entire database back in pervious stage.  Restore points work as bookmark in this. Before doing any major changes to database, a restore point can be created to allow for a 'restore point' to undo the changes.    Types of restore points Normal Restore point Guaranteed restore point Normal Restore point: The normal restore point is associated with a specific time / SCN as a kind of bookmark. The name of restore point with respect to SCN gets recorded in control file. The control file can maintain a record of thousands of restore points without impacting database performance. Guaranteed restore point: The guaranteed restore point associated with SCN enforces the requirement that you can perform flashback Database operation to return your database to its state at that SCN. A guarantee restore point must be manually deleted. ​ SQL Commands Example: My PDB Name is india SQ