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