Wednesday, 14 June 2023

DBA SCRIPTS

https://dbaclass.com/monitor-your-db/

Below steps to restore the INST_TOP if it is deleted or corrupted without using adcfgclone.

Step 1:

If we have CONTEXT_FILE backup then we can easily restore

(follow step-2). If CONTEXT_FILE is not there

then need to follow below steps to restore CONTEXT_FILE.

perl /clone/bin/adclonectx.pl retrieve

Step 2:

Once we restored CONTEXT_FILE then run the auto-config using below script.

It will recreate INST_TOP without using adcfgcolne.

Run AutoConfig using:

"perl $AD_TOP/bin/adconfig.pl contextfile=<CONTEXT_FILE>" command

and it will create the $INST_TOP

ORACLE DBA