Database Administration (MOSC)

MOSC Banner

Updates for DB refresh script after going to 19c (with ASM)

Hi -

We have recently upgraded our EBS instance to DB version 19c (from 12.2). On the new version we also have an ASM configuration. I am still getting up to speed with the ASM concepts (as well as the 19c ones 😀).

One question I have is with a function within our DB refresh script. Here is how it looks in its original/12c state:

########################################
dbcleanup() {
echo "Type CONFIRM to Confirm deletion of files in these directories:"
ls -ld /oradata/gl/*/${DBTGTL}
read DELCONFIRM
if [ "${DELCONFIRM}" == "CONFIRM" ]
then
 rm -f /oradata/app/*/${DBTGTL}/*.dbf
 rm -f /oradata/app/*/${DBTGTL}/OATM/*.dbf
 rm -f /oradata/app/*/${DBTGTL}/archive/1_*.dbf
 rm -f /oradata/app/*/${DBTGTL}/*.rdo
 rm -f /oradata/app/*/${DBTGTL}/*.ctl
else
 echo "Not confirmed, not cleaning up..."
fi
}

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center