How to Delete the Temporal Database

  1. 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
  2. Set the bootfile accordingly
    setenv OO_FD_BOOT < output of last command >
  3. srtpath to a current release
  4. Run the script from the release:
    OprTemDestroy
  5. 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