How to Delete the Temporal Database
- Find the boot file for the PC farm that will have its temporal database deleted
grep OO_FD_BOOT /nfs/oprserv0x/u1/PCx/prod/OprProcessingSys/OprConfPCx.xml
- Set the bootfile accordingly
setenv OO_FD_BOOT < output of last command >
- srtpath to a current release
- Run the script from the release:
OprTemDestroy
- It will take a while to finish and the output should look something like:
*** THIS SCRIPT WILL DESTROY THE CONTENT OF THE TEMPORAL DATABASE ***
Do you want to proceed ? (yes/no) yes
Deleting database opr_clustHintConfig... OK
Reclaiming dbid 9220...
Deleting database opr_opr_opr002405...
Reclaiming dbid 9221...
Deleting database opr_opr_Index... OK
Reclaiming dbid 9222...
Last modified: Wed Mar 16 13:51:43 PST 2005