Hi ASM Experts,
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
}
As I understand it, there are no more "datafiles", per say. So, we'd need to use the equivalent ASM commands to do this clean up step? Please suggest what we could use inplace of the above syntax.
Here are some additional details:
We have two OS users: oracle & grid
It is a CDB database with a single PDB (not sure if this matters and/or is relevant for this)
We do have a RAC configuration for our Production & UAT instances (not sure if this matters and/or is relevant for this)
Please let me know any additional details I can provide to clarify the ask ...
Thanks in advance for any input!
Charles