Backups 19c Database
Hi Experts,
We have upgraded our database to 19c.
Source - 12c noncdb
target -19c CDB with single PDB
In 12c,our backup script looks like
[oraprod@erpproddb2 ~]$ cat /home/oraprod/rman/scripts/rman_incr_backup_DB.sh
#!/usr/bin/ksh
#set -x
######## Variables #######
##########################
RUNTIME=`date '+%H%M%S_%d%m%Y'`
RUNDATE=`date '+%d%m%Y'`
###### Input Values #######
###########################
ORACLE_HOME=/u02/PRODDB/12.1.0
ORACLE_SID=PRODDB2
ORACLE_DB=PRODDB
LOGDIR=/home/oraprod/rman/logs
BACKUP_BASE=/u03/PRODRMAN
PATH=$ORACLE_HOME/bin:$PATH:/usr/local/bin
NLS_DATE_FORMAT='DD-MM-YY HH24:MI:SS'
export ORACLE_HOME PATH NLS_DATE_FORMAT NODE_NAME BACKUP_BASE ORACLE_SID
# Specific settings #
#########################################
export LOGFILE=${LOGDIR}/DB_${ORACLE_SID}_${RUNTIME}.log
export BACKUPDIR=${BACKUP_BASE}/${ORACLE_SID}/rman
# Cleaning old files which are older than 90 days#
#############################
find ${LOGDIR}/*_${ORACLE_SID}_*.log -ctime +90 -exec rm -f {} \; > /dev/null 2>&1
find ${BACKUPDIR}/ctrlfile_${ORACLE_SID}_* -ctime +90 -exec rm -f {} \; > /dev/null 2>&1
sql "alter system archive log current";
BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL=1 spfile format '${BACKUPDIR}/spfile_%d_%s_%T.bak' DATABASE INCLUDE CURRENT CONTROLFILE PLUS ARCHIVELOG delete input;
After upgrade:
=============
In 19c,Input values are changed as below
ORACLE_HOME=/u02/PRODDB/19chome
ORACLE_SID=prodcdb2
ORACLE_DB=PRODDB-------=================>This is PDB(Is this right?
PDB is PRODDB
CBD is PRODCDB--->prodcdb1 and prodcdb2 are instances
What is the value that we 0