Database Backup and Recovery (MOSC)

MOSC Banner

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

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