Oracle : Shell script for RMAN backup of Standby Database

Share via:

Post Views: 0

Oracle : Shell script for RMAN backup of Standby Database

In this article, we wrote an automation job for Shell script for RMAN backup of Standby Database

The below script will be initiating the RMAN backup on the standby database:

RMAN Script :

[oracle@tewnposqa1 scripts]$ cat nposqa1_rman_backup.sh

#!/bin/bash
#
# rman_backup.sh
# ==============
#
# Usage: rman_backup.sh -i instance -c command_file [-l log_directory] [-n notify_list]
# instance is the ORACLE_SID of the database to back up.
# command_file is the name of the RMAN command file; assumption is that the file is in the
# same directory as this script file
# log_directory is where the log file should be written. (If not
# provided then the log file will be written to /tmp.)
# notify_list is a list of comma-separated email addresses where email
# should be sent if the backup fails for any reason.
#
# Configuration settings.
#
export MAIL_PROGRAM="mailx"
TEMPDIR="/tmp"
SCRIPTDIR=`dirname "$0"`
export back_type="None"
# backup type information
if [ "$4" = "nposqa1_rman_backup.rcv" ]
then
export back_type="RMAN Hot Backup(Full - Level 0)"
elif [ "$4" = "nposqa1_rman_backup_incr1.rcv" ]
then
export back_type="RMAN Hot Backup(Incremental - Level 1)"
elif [ "$4" = "nposqa1_rman_backup_arch.rcv" ]
then
export back_type="RMAN Archivelog Backup"
elif [ "$4" = "nposqa1_rman_backupset_tape.rcv" ]
then
export back_type="RMAN Full Tape Backup"
else
export back_type="No Backup"
fi
# Parse and validate the command line arguments.
#
SID=""
CMD_FILE=""
LOG_DIR="/cloud/rman/logs"
NOTIFY="admin@ktexperts.com"
USAGE="Usage: `basename $0` -i instance -c command_file [-l log_directory] [-n notify_list]"

while getopts :i:c:C:l:n: opt
do
case "$opt" in
"i") SID="$OPTARG" ;;
"c") CMD_FILE="$OPTARG"
if [ ! -r "${SCRIPTDIR}/${CMD_FILE}" ]
then
echo "RMAN command file does not exist or is not readable by you" 1>&2
exit
fi ;;
"n") NOTIFY="$OPTARG" ;;
"l") LOG_DIR="$OPTARG"
if [ ! -d "$LOG_DIR" -o ! -w "$LOG_DIR" ]
then
echo "Log directory must be a directory writable by you" 1>&2
exit 1
fi ;;
":"|"?") echo "$USAGE" 1>&2 ; exit 1 ;;
esac
done

let i=$#+1
if [ "$i" != "$OPTIND" ]
then
echo "$USAGE" 1>&2
exit 1
fi

if [ -z "${SID}" -o -z "${SCRIPTDIR}/${CMD_FILE}" ]
then
echo "$USAGE" 1>&2
exit 1
fi

#
# Set local variables based on command line arguments
#
OUTFILE="${LOG_DIR}/${SID}_${CMD_FILE}_`date +%Y%m%d_%H%M%S`.log"

#
# Set up the environment.
#
export ORACLE_SID="$SID"
export ORAENV_ASK="NO"
export PATH="$PATH:/usr/local/bin:/usr/sbin"
. /usr/local/bin/oraenv
export NLS_DATE_FORMAT="dd-mon-yy hh24:mi:ss"

#
# Check to make sure that there is no another backup employing this same command file
# that is already running.
#
export SCRIPTLOCKFILE=${SCRIPTDIR}/${SID}_${CMD_FILE}.scriptlock
if [ -f $SCRIPTLOCKFILE ]
then
OLDCOPY=`ls -l $SCRIPTLOCKFILE`
echo "Found lockfile: $OLDCOPY" > $OUTFILE
OLDPS=`ps -ef|egrep $0|egrep -v $$|egrep -v egrep`
echo "Searching ps for $0 (ignoring $$ because that is me) " >> $OUTFILE
echo "Found: $OLDPS" >> $OUTFILE
echo "If you see a ps, it is still running. If not the job got jammed, remove the lockfile." >> $OUTFILE
${MAIL_PROGRAM} -s "Issues with $ORACLE_SID backup, Please check" "${NOTIFY}" < "${OUTFILE}"
exit
else
touch $SCRIPTLOCKFILE
fi

# Invoke RMAN with connection strings hard-coded in the command file.
#
$ORACLE_HOME/bin/rman log ${OUTFILE} cmdfile ${SCRIPTDIR}/${CMD_FILE}

#
# If there is an error returned from the rman executable, send an email to those recipients
# designated on the command line. Note that no email is sent upon successful completion.
# Therefore some means of monitoring backups such as Database Rx should be employed so that
# someone gets notified if this script is not being executed at all.
#
RETCODE="$?"
if [ "$RETCODE" != "0" ]
then
${MAIL_PROGRAM} -s "${back_type} of $ORACLE_SID database - failed" "${NOTIFY}" < "${OUTFILE}"
fi

rm $SCRIPTLOCKFILE
exit 0

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

#!/bin/bash

# rman_backup.sh

# ==============

# Usage: rman_backup.sh -i instance -c command_file [-l log_directory] [-n notify_list]

# instance is the ORACLE_SID of the database to back up.

# command_file is the name of the RMAN command file; assumption is that the file is in the

# same directory as this script file

# log_directory is where the log file should be written. (If not

# provided then the log file will be written to /tmp.)

# notify_list is a list of comma-separated email addresses where email

# should be sent if the backup fails for any reason.

# Configuration settings.

export MAIL_PROGRAM="mailx"

TEMPDIR="/tmp"

SCRIPTDIR=`dirname "$0"`

export back_type="None"

# backup type information

if [ "$4" = "nposqa1_rman_backup.rcv" ]

then

export back_type="RMAN Hot Backup(Full - Level 0)"

elif [ "$4" = "nposqa1_rman_backup_incr1.rcv" ]

then

export back_type="RMAN Hot Backup(Incremental - Level 1)"

elif [ "$4" = "nposqa1_rman_backup_arch.rcv" ]

then

export back_type="RMAN Archivelog Backup"

elif [ "$4" = "nposqa1_rman_backupset_tape.rcv" ]

then

export back_type="RMAN Full Tape Backup"

else

export back_type="No Backup"

# Parse and validate the command line arguments.

SID=""

CMD_FILE=""

LOG_DIR="/cloud/rman/logs"

NOTIFY="admin@ktexperts.com"

USAGE="Usage: `basename $0` -i instance -c command_file [-l log_directory] [-n notify_list]"

while getopts :i:c:C:l:n: opt

case "$opt" in

"i") SID="$OPTARG" ;;

"c") CMD_FILE="$OPTARG"

if [ ! -r "${SCRIPTDIR}/${CMD_FILE}" ]

then

echo "RMAN command file does not exist or is not readable by you" 1>&2

exit

fi ;;

"n") NOTIFY="$OPTARG" ;;

"l") LOG_DIR="$OPTARG"

if [ ! -d "$LOG_DIR" -o ! -w "$LOG_DIR" ]

then

echo "Log directory must be a directory writable by you" 1>&2

exit 1

fi ;;

":"|"?") echo "$USAGE" 1>&2 ; exit 1 ;;

esac

done

let i=$#+1

if [ "$i" != "$OPTIND" ]

then

echo "$USAGE" 1>&2

exit 1

if [ -z "${SID}" -o -z "${SCRIPTDIR}/${CMD_FILE}" ]

then

echo "$USAGE" 1>&2

exit 1

# Set local variables based on command line arguments

OUTFILE="${LOG_DIR}/${SID}_${CMD_FILE}_`date +%Y%m%d_%H%M%S`.log"

# Set up the environment.

export ORACLE_SID="$SID"

export ORAENV_ASK="NO"

export PATH="$PATH:/usr/local/bin:/usr/sbin"

. /usr/local/bin/oraenv

export NLS_DATE_FORMAT="dd-mon-yy hh24:mi:ss"

# Check to make sure that there is no another backup employing this same command file

# that is already running.

export SCRIPTLOCKFILE=${SCRIPTDIR}/${SID}_${CMD_FILE}.scriptlock

if [ -f $SCRIPTLOCKFILE ]

then

OLDCOPY=`ls -l $SCRIPTLOCKFILE`

echo "Found lockfile: $OLDCOPY" > $OUTFILE

OLDPS=`ps -ef|egrep $0|egrep -v $$|egrep -v egrep`

echo "Searching ps for $0 (ignoring $$ because that is me) " >> $OUTFILE

echo "Found: $OLDPS" >> $OUTFILE

echo "If you see a ps, it is still running. If not the job got jammed, remove the lockfile." >> $OUTFILE

${MAIL_PROGRAM} -s "Issues with $ORACLE_SID backup, Please check" "${NOTIFY}" < "${OUTFILE}"

exit

else

touch $SCRIPTLOCKFILE

# Invoke RMAN with connection strings hard-coded in the command file.

$ORACLE_HOME/bin/rman log ${OUTFILE} cmdfile ${SCRIPTDIR}/${CMD_FILE}

# If there is an error returned from the rman executable, send an email to those recipients

# designated on the command line. Note that no email is sent upon successful completion.

# Therefore some means of monitoring backups such as Database Rx should be employed so that

# someone gets notified if this script is not being executed at all.

RETCODE="$?"

if [ "$RETCODE" != "0" ]

then

${MAIL_PROGRAM} -s "${back_type} of $ORACLE_SID database - failed" "${NOTIFY}" < "${OUTFILE}"

rm $SCRIPTLOCKFILE

exit 0

RMAN Configuration script :

[oracle@tewnposqa1 scripts]$ cat nposqa1_rman_backup_1.rcv

# Connect to the database that will be backed up
connect target /
show all;
run {
allocate channel d1 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;
allocate channel d2 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;
allocate channel d3 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;
allocate channel d4 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;
allocate channel d5 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;
allocate channel d6 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;
allocate channel d7 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;
allocate channel d8 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;
allocate channel d9 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;
allocate channel d10 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;
# Remove any archived logs from the repository that have been deleted outside of RMAN.
crosscheck archivelog all;
delete expired archivelog all;
#
# Verify that the backups RMAN thinks are available actually are
crosscheck backup;
delete expired backup;
backup as compressed backupset tag incr0_backup_dbfiles incremental level 0 database;
#
backup as backupset tag incr0_backup_archlogs archivelog all not backed up;
# Generate a textual version of the control file in the trace directory
sql 'alter database backup controlfile to trace';
#
# If you are NOT using an FRA then you will probably want to uncomment the following line
# in order to delete backups and archived logs that are no longer needed to satisfy the
# configured retention policy. If an FRA is in use then obsolete backups are eligible
# for automatic deletion when space is needed. Also take heed of Note #4 above.
crosscheck backup;
delete force noprompt obsolete device type disk;
delete noprompt force archivelog all backed up 1 times to device type disk completed before 'SYSDATE-1';
# Copy the backups to tape
#
release channel d1;
release channel d2;
release channel d3;
release channel d4;
release channel d5;
release channel d6;
release channel d7;
release channel d8;
release channel d9;
release channel d10;
}

# Connect to the database that will be backed up

connect target /

show all;

run {

allocate channel d1 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;

allocate channel d2 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;

allocate channel d3 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;

allocate channel d4 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;

allocate channel d5 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;

allocate channel d6 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;

allocate channel d7 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;

allocate channel d8 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;

allocate channel d9 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;

allocate channel d10 type disk format '/cloud/rman/nposqa1/Rman_LVL-0_Bkup_nposqa1_%U.bkp' maxpiecesize 8G;

# Remove any archived logs from the repository that have been deleted outside of RMAN.

crosscheck archivelog all;

delete expired archivelog all;

# Verify that the backups RMAN thinks are available actually are

crosscheck backup;

delete expired backup;

backup as compressed backupset tag incr0_backup_dbfiles incremental level 0 database;

backup as backupset tag incr0_backup_archlogs archivelog all not backed up;

# Generate a textual version of the control file in the trace directory

sql 'alter database backup controlfile to trace';

# If you are NOT using an FRA then you will probably want to uncomment the following line

# in order to delete backups and archived logs that are no longer needed to satisfy the

# configured retention policy. If an FRA is in use then obsolete backups are eligible

# for automatic deletion when space is needed. Also take heed of Note #4 above.

crosscheck backup;

delete force noprompt obsolete device type disk;

delete noprompt force archivelog all backed up 1 times to device type disk completed before 'SYSDATE-1';

# Copy the backups to tape

release channel d1;

release channel d2;

release channel d3;

release channel d4;

release channel d5;

release channel d6;

release channel d7;

release channel d8;

release channel d9;

release channel d10;

}

Run the RMAN backup on Standby with nohup command.

nohup /cloud/rman/scripts/nposqa1_rman_backup.sh -i nposqa1 -c nposqa1_rman_backup_1.rcv > /tmp/nposqa1_rman_backup.log &

1	nohup /cloud/rman/scripts/nposqa1_rman_backup.sh -i nposqa1 -c nposqa1_rman_backup_1.rcv > /tmp/nposqa1_rman_backup.log &

Open the log file and check for any errors:

[oracle@tewnposqa1 logs]$ more nposqa1_nposqa1_rman_backup_1.rcv_20210916_065409.log

Recovery Manager: Release 12.1.0.2.0 - Production on Thu Sep 16 06:54:09 2021

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

RMAN>
RMAN> # Connect to the database that will be backed up
2> connect target *
connected to target database: nposqa1 (DBID=153864100, not open)

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name nposqa1 are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/cloud/rman/nposqa1/nposqa1_ctrl_spfile_autobkp_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/cloud/rman/nposqa1/nposqa1_rman_db_%U.bak' MAXPIECESIZE 2000 M;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/snapcf_nposqa1.f'; # default

allocated channel: d1
channel d1: SID=1062 device type=DISK
allocated channel: d2
channel d2: SID=1014 device type=DISK
allocated channel: d3
channel d3: SID=1110 device type=DISK
allocated channel: d4
channel d4: SID=1158 device type=DISK
allocated channel: d5
channel d5: SID=1206 device type=DISK
allocated channel: d6
channel d6: SID=1254 device type=DISK
allocated channel: d7
channel d7: SID=1302 device type=DISK
allocated channel: d8
channel d8: SID=1350 device type=DISK
allocated channel: d9
channel d9: SID=1398 device type=DISK
allocated channel: d10
channel d10: SID=1446 device type=DISK

validation succeeded for archived log
archived log file name=+RECO/nposqa1/ARCHIVELOG/2021_09_10/thread_1_seq_45134.666.1082887223 RECID=47090 STAMP=1082887225
validation succeeded for archived log
archived log file name=+RECO/NPOSQA1/ARCHIVELOG/2021_09_10/thread_1_seq_45135.448.1082887225 RECID=47091 STAMP=1082887225
validation succeeded for archived log
archived log file name=+RECO/NPOSQA1/ARCHIVELOG/2021_09_16/thread_1_seq_45256.1078.1083391321 RECID=47243 STAMP=1083391322
.........
.........
Crosschecked 123 objects
specification does not match any archived log in the repository
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/cloud/rman/NPOSQA1/Rman_Archivelog_Bkup_NPOSQA1_630878qu_1_1.bkp RECID=106395 STAMP=1082368863
backup piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_bk08phek_2_1.bkp RECID=106645 STAMP=1082968425
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/cloud/rman/NPOSQA1/NPOSQA1_ctrl_spfile_autobkp_c-153864100-20210911-05 RECID=106661 STAMP=1082971379
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/cloud/rman/NPOSQA1/NPOSQA1_ctrl_spfile_autobkp_c-153864100-20210911-06 RECID=106662 STAMP=1082972952
......
......
Crosschecked 268 objects
specification does not match any backup in the repository
Starting backup at 16-sep-21 06:54:21
channel d1: starting compressed incremental level 0 datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00059 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.340.999774069
input datafile file number=00003 name=+DATA/NPOSQA1/DATAFILE/undotbs1.280.922456313
input datafile file number=00015 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.296.927357807
input datafile file number=00029 name=+DATA/NPOSQA1/DATAFILE/users.310.962180715
input datafile file number=00058 name=+DATA/NPOSQA1/DATAFILE/sysaux.339.999449289
input datafile file number=00075 name=+DATA/NPOSQA1/DATAFILE/ktexperts_arc_index01.356.1036608513
input datafile file number=00085 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.366.1057046791
input datafile file number=00041 name=+DATA/NPOSQA1/DATAFILE/users.322.962234927
input datafile file number=00067 name=+DATA/NPOSQA1/DATAFILE/undotbs1.348.1005501599
channel d1: starting piece 1 at 16-sep-21 06:54:23
channel d2: starting compressed incremental level 0 datafile backup set
channel d2: specifying datafile(s) in backup set
input datafile file number=00021 name=+DATA/NPOSQA1/DATAFILE/users.302.960138247
input datafile file number=00009 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.290.927070099
input datafile file number=00024 name=+DATA/NPOSQA1/DATAFILE/users.305.962103209
input datafile file number=00049 name=+DATA/NPOSQA1/DATAFILE/users.330.962449203
input datafile file number=00065 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data02.346.1003691271
input datafile file number=00080 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.361.1037337523
input datafile file number=00090 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.371.1072565731
input datafile file number=00039 name=+DATA/NPOSQA1/DATAFILE/users.320.962231403
input datafile file number=00033 name=+DATA/NPOSQA1/DATAFILE/users.314.962230497
input datafile file number=00037 name=+DATA/NPOSQA1/DATAFILE/users.318.962230873
channel d2: starting piece 1 at 16-sep-21 06:54:24
channel d3: starting compressed incremental level 0 datafile backup set
channel d3: specifying datafile(s) in backup set
input datafile file number=00050 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.331.967712457
input datafile file number=00002 name=+DATA/NPOSQA1/DATAFILE/sysaux.279.922456307
input datafile file number=00014 name=+DATA/NPOSQA1/DATAFILE/sysaux.295.927357681
input datafile file number=00028 name=+DATA/NPOSQA1/DATAFILE/users.309.962180705
input datafile file number=00055 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.336.972202833
input datafile file number=00074 name=+DATA/NPOSQA1/DATAFILE/ktexperts_arc_index01.355.1036608313
input datafile file number=00084 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.365.1053991909
input datafile file number=00040 name=+DATA/NPOSQA1/DATAFILE/users.321.962234531
input datafile file number=00038 name=+DATA/NPOSQA1/DATAFILE/users.319.962230953
channel d3: starting piece 1 at 16-sep-21 06:54:24
channel d4: starting compressed incremental level 0 datafile backup set
channel d4: specifying datafile(s) in backup set
input datafile file number=00022 name=+DATA/NPOSQA1/DATAFILE/users.303.960138281
input datafile file number=00010 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.291.927070107
input datafile file number=00025 name=+DATA/NPOSQA1/DATAFILE/users.306.962122563
input datafile file number=00052 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.333.967725505
input datafile file number=00068 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.349.1016149989
input datafile file number=00081 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.362.1044162985
input datafile file number=00091 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.377.1080759277
input datafile file number=00012 name=+DATA/NPOSQA1/DATAFILE/ktexperts_index.293.927070269
input datafile file number=00030 name=+DATA/NPOSQA1/DATAFILE/users.311.962230377
input datafile file number=00034 name=+DATA/NPOSQA1/DATAFILE/users.315.962230505
channel d4: starting piece 1 at 16-sep-21 06:54:24
channel d5: starting compressed incremental level 0 datafile backup set
channel d5: specifying datafile(s) in backup set
input datafile file number=00072 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.353.1033999789
input datafile file number=00008 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.289.927069309
input datafile file number=00023 name=+DATA/NPOSQA1/DATAFILE/users.304.962102963
input datafile file number=00048 name=+DATA/NPOSQA1/DATAFILE/users.329.962448941
input datafile file number=00064 name=+DATA/NPOSQA1/DATAFILE/undotbs1.345.1003691087
input datafile file number=00079 name=+DATA/NPOSQA1/DATAFILE/ktexperts_arc_index01.360.1036619715
input datafile file number=00089 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.370.1072564661
input datafile file number=00020 name=+DATA/NPOSQA1/DATAFILE/pos_data.301.958476693
input datafile file number=00031 name=+DATA/NPOSQA1/DATAFILE/users.312.962230389
input datafile file number=00035 name=+DATA/NPOSQA1/DATAFILE/users.316.962230577
channel d5: starting piece 1 at 16-sep-21 06:54:24
channel d6: starting compressed incremental level 0 datafile backup set
channel d6: specifying datafile(s) in backup set
input datafile file number=00063 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.344.1003660687
input datafile file number=00005 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.284.922536517
input datafile file number=00016 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.297.927908277
input datafile file number=00045 name=+DATA/NPOSQA1/DATAFILE/users.326.962368879
input datafile file number=00060 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.341.1003462655
input datafile file number=00076 name=+DATA/NPOSQA1/DATAFILE/ktexperts_arc_index01.357.1036617947
input datafile file number=00086 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.367.1057046901
input datafile file number=00042 name=+DATA/NPOSQA1/DATAFILE/users.323.962259777
channel d6: starting piece 1 at 16-sep-21 06:54:25
channel d7: starting compressed incremental level 0 datafile backup set
channel d7: specifying datafile(s) in backup set
input datafile file number=00070 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.351.1032386525
input datafile file number=00006 name=+DATA/NPOSQA1/DATAFILE/ktexperts_index.285.922536587
input datafile file number=00017 name=+DATA/NPOSQA1/DATAFILE/undotbs1.298.928670497
input datafile file number=00046 name=+DATA/NPOSQA1/DATAFILE/users.327.962369757
input datafile file number=00061 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data02.342.1003627193
input datafile file number=00077 name=+DATA/NPOSQA1/DATAFILE/ktexperts_arc_index01.358.1036618195
input datafile file number=00087 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data02.368.1057080049
input datafile file number=00043 name=+DATA/NPOSQA1/DATAFILE/users.324.962347951
channel d7: starting piece 1 at 16-sep-21 06:54:26
channel d8: starting compressed incremental level 0 datafile backup set
channel d8: specifying datafile(s) in backup set
input datafile file number=00071 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.352.1033576113
input datafile file number=00007 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.288.927068757
input datafile file number=00018 name=+DATA/NPOSQA1/DATAFILE/sysaux.299.951004329
input datafile file number=00047 name=+DATA/NPOSQA1/DATAFILE/users.328.962447655
input datafile file number=00062 name=+DATA/NPOSQA1/DATAFILE/ktexperts_index02.343.1003627249
input datafile file number=00078 name=+DATA/NPOSQA1/DATAFILE/ktexperts_arc_index01.359.1036618425
input datafile file number=00088 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.369.1068880895
input datafile file number=00044 name=+DATA/NPOSQA1/DATAFILE/users.325.962348193
channel d8: starting piece 1 at 16-sep-21 06:54:26
channel d9: starting compressed incremental level 0 datafile backup set
channel d9: specifying datafile(s) in backup set
input datafile file number=00051 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.332.967712637
input datafile file number=00004 name=+DATA/NPOSQA1/DATAFILE/users.282.922456325
input datafile file number=00027 name=+DATA/NPOSQA1/DATAFILE/users.308.962180577
input datafile file number=00054 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.335.972201421
input datafile file number=00073 name=+DATA/NPOSQA1/DATAFILE/ktexperts_arc_index01.354.1036607931
input datafile file number=00083 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.364.1053991767
input datafile file number=00056 name=+DATA/NPOSQA1/DATAFILE/sysaux.337.974347095
input datafile file number=00066 name=+DATA/NPOSQA1/DATAFILE/undotbs1.347.1004522521
input datafile file number=00036 name=+DATA/NPOSQA1/DATAFILE/users.317.962230593
channel d9: starting piece 1 at 16-sep-21 06:54:27
channel d10: starting compressed incremental level 0 datafile backup set
channel d10: specifying datafile(s) in backup set
input datafile file number=00019 name=+DATA/NPOSQA1/DATAFILE/users.300.958062843
input datafile file number=00011 name=+DATA/NPOSQA1/DATAFILE/sysaux.292.927070223
input datafile file number=00026 name=+DATA/NPOSQA1/DATAFILE/sysaux.307.962123343
input datafile file number=00053 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.334.972201019
input datafile file number=00069 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.350.1016150189
input datafile file number=00082 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.363.1046652093
input datafile file number=00001 name=+DATA/NPOSQA1/DATAFILE/system.278.922456299
input datafile file number=00057 name=+DATA/NPOSQA1/DATAFILE/sysaux.338.986488875
input datafile file number=00013 name=+DATA/NPOSQA1/DATAFILE/ktexperts_index.294.927070277
input datafile file number=00032 name=+DATA/NPOSQA1/DATAFILE/users.313.962230489
channel d10: starting piece 1 at 16-sep-21 06:54:27

piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_ca096id1_4_1.bkp tag=INCR0_BACKUP_DBFILES comment=NONE
channel d6: starting piece 5 at 16-sep-21 07:49:36
channel d3: finished piece 4 at 16-sep-21 07:52:41
piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_c7096id0_4_1.bkp tag=INCR0_BACKUP_DBFILES comment=NONE
channel d3: starting piece 5 at 16-sep-21 07:52:41
channel d3: finished piece 5 at 16-sep-21 07:54:36
piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_c7096id0_5_1.bkp tag=INCR0_BACKUP_DBFILES comment=NONE
channel d3: backup set complete, elapsed time: 01:00:12
channel d6: finished piece 5 at 16-sep-21 07:58:36
piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_ca096id1_5_1.bkp tag=INCR0_BACKUP_DBFILES comment=NONE
channel d6: backup set complete, elapsed time: 01:04:11
Finished backup at 16-sep-21 07:58:36

Starting backup at 16-sep-21 07:58:38
RMAN-06820: WARNING: failed to archive current log at primary database
ORACLE error from target database:
ORA-17629: Cannot connect to the remote database server
ORA-17630: Mismatch in the remote file protocol version client 2 server 3

skipping archived logs of thread 1 from sequence 45134 to 45163; already backed up
channel d1: starting archived log backup set
channel d1: specifying archived log(s) in backup set
input archived log thread=1 sequence=45174 RECID=47161 STAMP=1083026193
input archived log thread=1 sequence=45175 RECID=47162 STAMP=1083040841
input archived log thread=1 sequence=45176 RECID=47163 STAMP=1083045969
input archived log thread=1 sequence=45177 RECID=47164 STAMP=1083046069
input archived log thread=1 sequence=45178 RECID=47165 STAMP=1083052676
input archived log thread=1 sequence=45179 RECID=47166 STAMP=1083060346
input archived log thread=1 sequence=45180 RECID=47167 STAMP=1083068352
input archived log thread=1 sequence=45181 RECID=47168 STAMP=1083079257
input archived log thread=1 sequence=45182 RECID=47169 STAMP=1083084492
channel d1: starting piece 1 at 16-sep-21 07:58:42
channel d2: starting archived log backup set
channel d2: specifying archived log(s) in backup set
input archived log thread=1 sequence=45238 RECID=47225 STAMP=1083318141
input archived log thread=1 sequence=45239 RECID=47226 STAMP=1083320835
input archived log thread=1 sequence=45240 RECID=47227 STAMP=1083323469
input archived log thread=1 sequence=45241 RECID=47228 STAMP=1083326901
input archived log thread=1 sequence=45242 RECID=47229 STAMP=1083331053
input archived log thread=1 sequence=45243 RECID=47230 STAMP=1083335004
input archived log thread=1 sequence=45244 RECID=47231 STAMP=1083337992
input archived log thread=1 sequence=45245 RECID=47232 STAMP=1083339763
input archived log thread=1 sequence=45246 RECID=47233 STAMP=1083344413
channel d2: starting piece 1 at 16-sep-21 07:58:42
channel d3: starting archived log backup set
channel d3: specifying archived log(s) in backup set
input archived log thread=1 sequence=45211 RECID=47198 STAMP=1083199359
input archived log thread=1 sequence=45212 RECID=47199 STAMP=1083204543
input archived log thread=1 sequence=45213 RECID=47200 STAMP=1083212799
input archived log thread=1 sequence=45214 RECID=47201 STAMP=1083216967
input archived log thread=1 sequence=45215 RECID=47202 STAMP=1083222448
input archived log thread=1 sequence=45216 RECID=47203 STAMP=1083225778
input archived log thread=1 sequence=45217 RECID=47204 STAMP=1083229147
input archived log thread=1 sequence=45218 RECID=47205 STAMP=1083232966
input archived log thread=1 sequence=45219 RECID=47206 STAMP=1083236137
channel d3: starting piece 1 at 16-sep-21 07:58:42
channel d4: starting archived log backup set
channel d4: specifying archived log(s) in backup set
input archived log thread=1 sequence=45229 RECID=47216 STAMP=1083274955
input archived log thread=1 sequence=45230 RECID=47217 STAMP=1083276851
input archived log thread=1 sequence=45231 RECID=47218 STAMP=1083279344
input archived log thread=1 sequence=45232 RECID=47219 STAMP=1083285779
input archived log thread=1 sequence=45233 RECID=47220 STAMP=1083298193
input archived log thread=1 sequence=45234 RECID=47221 STAMP=1083302478
input archived log thread=1 sequence=45235 RECID=47222 STAMP=1083307869
input archived log thread=1 sequence=45236 RECID=47223 STAMP=1083311823
input archived log thread=1 sequence=45237 RECID=47224 STAMP=1083315534
channel d4: starting piece 1 at 16-sep-21 07:58:42
channel d5: starting archived log backup set
channel d5: specifying archived log(s) in backup set
input archived log thread=1 sequence=45247 RECID=47234 STAMP=1083347263
input archived log thread=1 sequence=45248 RECID=47235 STAMP=1083352570
input archived log thread=1 sequence=45249 RECID=47236 STAMP=1083355786
input archived log thread=1 sequence=45250 RECID=47237 STAMP=1083359959
input archived log thread=1 sequence=45251 RECID=47238 STAMP=1083363163
input archived log thread=1 sequence=45252 RECID=47239 STAMP=1083365146
input archived log thread=1 sequence=45253 RECID=47240 STAMP=1083370395
input archived log thread=1 sequence=45254 RECID=47241 STAMP=1083371647
input archived log thread=1 sequence=45255 RECID=47242 STAMP=1083386792
channel d5: starting piece 1 at 16-sep-21 07:58:42
channel d6: starting archived log backup set
channel d6: specifying archived log(s) in backup set
input archived log thread=1 sequence=45183 RECID=47170 STAMP=1083087771
input archived log thread=1 sequence=45184 RECID=47171 STAMP=1083089226
input archived log thread=1 sequence=45185 RECID=47172 STAMP=1083095052
input archived log thread=1 sequence=45186 RECID=47173 STAMP=1083098955
input archived log thread=1 sequence=45187 RECID=47174 STAMP=1083106069
input archived log thread=1 sequence=45188 RECID=47175 STAMP=1083112940
input archived log thread=1 sequence=45189 RECID=47176 STAMP=1083124819
input archived log thread=1 sequence=45190 RECID=47177 STAMP=1083129622
input archived log thread=1 sequence=45191 RECID=47178 STAMP=1083132583
channel d6: starting piece 1 at 16-sep-21 07:58:42
channel d7: starting archived log backup set
channel d7: specifying archived log(s) in backup set
input archived log thread=1 sequence=45192 RECID=47179 STAMP=1083136222
input archived log thread=1 sequence=45193 RECID=47180 STAMP=1083139745
input archived log thread=1 sequence=45194 RECID=47181 STAMP=1083143159
input archived log thread=1 sequence=45195 RECID=47182 STAMP=1083146738
input archived log thread=1 sequence=45196 RECID=47183 STAMP=1083149942
input archived log thread=1 sequence=45197 RECID=47184 STAMP=1083153014
input archived log thread=1 sequence=45198 RECID=47185 STAMP=1083157220
input archived log thread=1 sequence=45199 RECID=47186 STAMP=1083161513
input archived log thread=1 sequence=45200 RECID=47187 STAMP=1083165938
channel d7: starting piece 1 at 16-sep-21 07:58:42
channel d8: starting archived log backup set
channel d8: specifying archived log(s) in backup set
input archived log thread=1 sequence=45220 RECID=47207 STAMP=1083239824
input archived log thread=1 sequence=45221 RECID=47208 STAMP=1083244627
input archived log thread=1 sequence=45222 RECID=47209 STAMP=1083249424
input archived log thread=1 sequence=45223 RECID=47210 STAMP=1083253099
input archived log thread=1 sequence=45224 RECID=47211 STAMP=1083253408
input archived log thread=1 sequence=45225 RECID=47212 STAMP=1083258413
input archived log thread=1 sequence=45226 RECID=47213 STAMP=1083262099
input archived log thread=1 sequence=45227 RECID=47214 STAMP=1083267581
input archived log thread=1 sequence=45228 RECID=47215 STAMP=1083271856
channel d8: starting piece 1 at 16-sep-21 07:58:42
channel d9: starting archived log backup set
channel d9: specifying archived log(s) in backup set
input archived log thread=1 sequence=45201 RECID=47188 STAMP=1083171218
input archived log thread=1 sequence=45202 RECID=47189 STAMP=1083174584
input archived log thread=1 sequence=45203 RECID=47190 STAMP=1083180285
input archived log thread=1 sequence=45204 RECID=47191 STAMP=1083183783
input archived log thread=1 sequence=45205 RECID=47192 STAMP=1083188106
input archived log thread=1 sequence=45206 RECID=47193 STAMP=1083190082
input archived log thread=1 sequence=45207 RECID=47194 STAMP=1083190084
input archived log thread=1 sequence=45208 RECID=47195 STAMP=1083190084
input archived log thread=1 sequence=45209 RECID=47196 STAMP=1083190117
input archived log thread=1 sequence=45210 RECID=47197 STAMP=1083194649
channel d9: starting piece 1 at 16-sep-21 07:58:42
channel d10: starting archived log backup set
channel d10: specifying archived log(s) in backup set
input archived log thread=1 sequence=45256 RECID=47243 STAMP=1083391322
input archived log thread=1 sequence=45257 RECID=47244 STAMP=1083395952
channel d10: starting piece 1 at 16-sep-21 07:58:42
channel d10: finished piece 1 at 16-sep-21 07:59:27
piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_co096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE
channel d10: backup set complete, elapsed time: 00:00:45
channel d10: starting archived log backup set
channel d10: specifying archived log(s) in backup set
input archived log thread=1 sequence=45164 RECID=47148 STAMP=1082971728
input archived log thread=1 sequence=45165 RECID=47151 STAMP=1082972067
input archived log thread=1 sequence=45166 RECID=47153 STAMP=1082972357
input archived log thread=1 sequence=45167 RECID=47154 STAMP=1082972556
input archived log thread=1 sequence=45168 RECID=47155 STAMP=1082972681
input archived log thread=1 sequence=45169 RECID=47156 STAMP=1082972682
input archived log thread=1 sequence=45170 RECID=47157 STAMP=1082972801
input archived log thread=1 sequence=45171 RECID=47158 STAMP=1082972807
input archived log thread=1 sequence=45172 RECID=47159 STAMP=1082998542
input archived log thread=1 sequence=45173 RECID=47160 STAMP=1082998552
channel d10: starting piece 1 at 16-sep-21 07:59:30
channel d3: finished piece 1 at 16-sep-21 07:59:45
piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_ch096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE
channel d3: backup set complete, elapsed time: 00:01:03
channel d5: finished piece 1 at 16-sep-21 07:59:55
piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_cj096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE
channel d5: backup set complete, elapsed time: 00:01:13
channel d2: finished piece 1 at 16-sep-21 08:00:05
piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_cg096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE
channel d2: backup set complete, elapsed time: 00:01:23
channel d10: finished piece 1 at 16-sep-21 08:00:05
piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_cp096m6v_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE
channel d10: backup set complete, elapsed time: 00:00:35
channel d1: finished piece 1 at 16-sep-21 08:00:15
piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_cf096m5h_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE
channel d1: backup set complete, elapsed time: 00:01:33
channel d4: finished piece 1 at 16-sep-21 08:00:15
piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_ci096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE
channel d4: backup set complete, elapsed time: 00:01:33
channel d6: finished piece 1 at 16-sep-21 08:00:15
piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_ck096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE
channel d6: backup set complete, elapsed time: 00:01:33
channel d7: finished piece 1 at 16-sep-21 08:00:15
piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_cl096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE
channel d7: backup set complete, elapsed time: 00:01:33
channel d8: finished piece 1 at 16-sep-21 08:00:15
piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_cm096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE
channel d8: backup set complete, elapsed time: 00:01:33
channel d9: finished piece 1 at 16-sep-21 08:00:15
piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_cn096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE
channel d9: backup set complete, elapsed time: 00:01:33
Finished backup at 16-sep-21 08:00:15

Starting Control File and SPFILE Autobackup at 16-sep-21 08:00:15
piece handle=/cloud/rman/NPOSQA1/NPOSQA1_ctrl_spfile_autobkp_c-153864100-20210916-00 comment=NONE
Finished Control File and SPFILE Autobackup at 16-sep-21 08:00:18

sql statement: alter database backup controlfile to trace

crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_b408okaf_1_1.bkp RECID=106568 STAMP=1082937680
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_cn096m5i_1_1.bkp RECID=106711 STAMP=1083398322
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/cloud/rman/NPOSQA1/NPOSQA1_ctrl_spfile_autobkp_c-153864100-20210916-00 RECID=106712 STAMP=1083398416
.....
.....
Crosschecked 145 objects

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 8 days
no obsolete backups found

deleted archived log
archived log file name=+RECO/NPOSQA1/ARCHIVELOG/2021_09_10/thread_1_seq_45149.851.1082934337 RECID=47119 STAMP=1082934338
deleted archived log
archived log file name=+RECO/NPOSQA1/ARCHIVELOG/2021_09_15/thread_1_seq_45236.1107.1083311821 RECID=47223 STAMP=1083311823
......
Deleted 88 objects

released channel: d1
released channel: d2
released channel: d3
released channel: d4
released channel: d5
released channel: d6
released channel: d7
released channel: d8
released channel: d9
released channel: d10
Recovery Manager complete.

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

372

373

374

375

376

377

378

379

380

381

382

383

384

385

386

387

388

389

390

391

392

393

394

395

396

397

398

399

400

401

402

403

404

405

406

407

408

409

410

411

412

413

Recovery Manager: Release 12.1.0.2.0 - Production on Thu Sep 16 06:54:09 2021

RMAN>

RMAN> # Connect to the database that will be backed up

2> connect target *

connected to target database: nposqa1 (DBID=153864100, not open)

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name nposqa1 are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS;

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/cloud/rman/nposqa1/nposqa1_ctrl_spfile_autobkp_%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/cloud/rman/nposqa1/nposqa1_rman_db_%U.bak' MAXPIECESIZE 2000 M;

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/snapcf_nposqa1.f'; # default

allocated channel: d1

channel d1: SID=1062 device type=DISK

allocated channel: d2

channel d2: SID=1014 device type=DISK

allocated channel: d3

channel d3: SID=1110 device type=DISK

allocated channel: d4

channel d4: SID=1158 device type=DISK

allocated channel: d5

channel d5: SID=1206 device type=DISK

allocated channel: d6

channel d6: SID=1254 device type=DISK

allocated channel: d7

channel d7: SID=1302 device type=DISK

allocated channel: d8

channel d8: SID=1350 device type=DISK

allocated channel: d9

channel d9: SID=1398 device type=DISK

allocated channel: d10

channel d10: SID=1446 device type=DISK

validation succeeded for archived log

archived log file name=+RECO/nposqa1/ARCHIVELOG/2021_09_10/thread_1_seq_45134.666.1082887223 RECID=47090 STAMP=1082887225

validation succeeded for archived log

archived log file name=+RECO/NPOSQA1/ARCHIVELOG/2021_09_10/thread_1_seq_45135.448.1082887225 RECID=47091 STAMP=1082887225

validation succeeded for archived log

archived log file name=+RECO/NPOSQA1/ARCHIVELOG/2021_09_16/thread_1_seq_45256.1078.1083391321 RECID=47243 STAMP=1083391322

.........

Crosschecked 123 objects

specification does not match any archived log in the repository

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/cloud/rman/NPOSQA1/Rman_Archivelog_Bkup_NPOSQA1_630878qu_1_1.bkp RECID=106395 STAMP=1082368863

backup piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_bk08phek_2_1.bkp RECID=106645 STAMP=1082968425

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/cloud/rman/NPOSQA1/NPOSQA1_ctrl_spfile_autobkp_c-153864100-20210911-05 RECID=106661 STAMP=1082971379

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/cloud/rman/NPOSQA1/NPOSQA1_ctrl_spfile_autobkp_c-153864100-20210911-06 RECID=106662 STAMP=1082972952

......

Crosschecked 268 objects

specification does not match any backup in the repository

Starting backup at 16-sep-21 06:54:21

channel d1: starting compressed incremental level 0 datafile backup set

channel d1: specifying datafile(s) in backup set

input datafile file number=00059 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.340.999774069

input datafile file number=00003 name=+DATA/NPOSQA1/DATAFILE/undotbs1.280.922456313

input datafile file number=00015 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.296.927357807

input datafile file number=00029 name=+DATA/NPOSQA1/DATAFILE/users.310.962180715

input datafile file number=00058 name=+DATA/NPOSQA1/DATAFILE/sysaux.339.999449289

input datafile file number=00075 name=+DATA/NPOSQA1/DATAFILE/ktexperts_arc_index01.356.1036608513

input datafile file number=00085 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.366.1057046791

input datafile file number=00041 name=+DATA/NPOSQA1/DATAFILE/users.322.962234927

input datafile file number=00067 name=+DATA/NPOSQA1/DATAFILE/undotbs1.348.1005501599

channel d1: starting piece 1 at 16-sep-21 06:54:23

channel d2: starting compressed incremental level 0 datafile backup set

channel d2: specifying datafile(s) in backup set

input datafile file number=00021 name=+DATA/NPOSQA1/DATAFILE/users.302.960138247

input datafile file number=00009 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.290.927070099

input datafile file number=00024 name=+DATA/NPOSQA1/DATAFILE/users.305.962103209

input datafile file number=00049 name=+DATA/NPOSQA1/DATAFILE/users.330.962449203

input datafile file number=00065 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data02.346.1003691271

input datafile file number=00080 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.361.1037337523

input datafile file number=00090 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.371.1072565731

input datafile file number=00039 name=+DATA/NPOSQA1/DATAFILE/users.320.962231403

input datafile file number=00033 name=+DATA/NPOSQA1/DATAFILE/users.314.962230497

input datafile file number=00037 name=+DATA/NPOSQA1/DATAFILE/users.318.962230873

channel d2: starting piece 1 at 16-sep-21 06:54:24

channel d3: starting compressed incremental level 0 datafile backup set

channel d3: specifying datafile(s) in backup set

input datafile file number=00050 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.331.967712457

input datafile file number=00002 name=+DATA/NPOSQA1/DATAFILE/sysaux.279.922456307

input datafile file number=00014 name=+DATA/NPOSQA1/DATAFILE/sysaux.295.927357681

input datafile file number=00028 name=+DATA/NPOSQA1/DATAFILE/users.309.962180705

input datafile file number=00055 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.336.972202833

input datafile file number=00074 name=+DATA/NPOSQA1/DATAFILE/ktexperts_arc_index01.355.1036608313

input datafile file number=00084 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.365.1053991909

input datafile file number=00040 name=+DATA/NPOSQA1/DATAFILE/users.321.962234531

input datafile file number=00038 name=+DATA/NPOSQA1/DATAFILE/users.319.962230953

channel d3: starting piece 1 at 16-sep-21 06:54:24

channel d4: starting compressed incremental level 0 datafile backup set

channel d4: specifying datafile(s) in backup set

input datafile file number=00022 name=+DATA/NPOSQA1/DATAFILE/users.303.960138281

input datafile file number=00010 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.291.927070107

input datafile file number=00025 name=+DATA/NPOSQA1/DATAFILE/users.306.962122563

input datafile file number=00052 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.333.967725505

input datafile file number=00068 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.349.1016149989

input datafile file number=00081 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.362.1044162985

input datafile file number=00091 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.377.1080759277

input datafile file number=00012 name=+DATA/NPOSQA1/DATAFILE/ktexperts_index.293.927070269

input datafile file number=00030 name=+DATA/NPOSQA1/DATAFILE/users.311.962230377

input datafile file number=00034 name=+DATA/NPOSQA1/DATAFILE/users.315.962230505

channel d4: starting piece 1 at 16-sep-21 06:54:24

channel d5: starting compressed incremental level 0 datafile backup set

channel d5: specifying datafile(s) in backup set

input datafile file number=00072 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.353.1033999789

input datafile file number=00008 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.289.927069309

input datafile file number=00023 name=+DATA/NPOSQA1/DATAFILE/users.304.962102963

input datafile file number=00048 name=+DATA/NPOSQA1/DATAFILE/users.329.962448941

input datafile file number=00064 name=+DATA/NPOSQA1/DATAFILE/undotbs1.345.1003691087

input datafile file number=00079 name=+DATA/NPOSQA1/DATAFILE/ktexperts_arc_index01.360.1036619715

input datafile file number=00089 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.370.1072564661

input datafile file number=00020 name=+DATA/NPOSQA1/DATAFILE/pos_data.301.958476693

input datafile file number=00031 name=+DATA/NPOSQA1/DATAFILE/users.312.962230389

input datafile file number=00035 name=+DATA/NPOSQA1/DATAFILE/users.316.962230577

channel d5: starting piece 1 at 16-sep-21 06:54:24

channel d6: starting compressed incremental level 0 datafile backup set

channel d6: specifying datafile(s) in backup set

input datafile file number=00063 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.344.1003660687

input datafile file number=00005 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.284.922536517

input datafile file number=00016 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.297.927908277

input datafile file number=00045 name=+DATA/NPOSQA1/DATAFILE/users.326.962368879

input datafile file number=00060 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.341.1003462655

input datafile file number=00076 name=+DATA/NPOSQA1/DATAFILE/ktexperts_arc_index01.357.1036617947

input datafile file number=00086 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.367.1057046901

input datafile file number=00042 name=+DATA/NPOSQA1/DATAFILE/users.323.962259777

channel d6: starting piece 1 at 16-sep-21 06:54:25

channel d7: starting compressed incremental level 0 datafile backup set

channel d7: specifying datafile(s) in backup set

input datafile file number=00070 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.351.1032386525

input datafile file number=00006 name=+DATA/NPOSQA1/DATAFILE/ktexperts_index.285.922536587

input datafile file number=00017 name=+DATA/NPOSQA1/DATAFILE/undotbs1.298.928670497

input datafile file number=00046 name=+DATA/NPOSQA1/DATAFILE/users.327.962369757

input datafile file number=00061 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data02.342.1003627193

input datafile file number=00077 name=+DATA/NPOSQA1/DATAFILE/ktexperts_arc_index01.358.1036618195

input datafile file number=00087 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data02.368.1057080049

input datafile file number=00043 name=+DATA/NPOSQA1/DATAFILE/users.324.962347951

channel d7: starting piece 1 at 16-sep-21 06:54:26

channel d8: starting compressed incremental level 0 datafile backup set

channel d8: specifying datafile(s) in backup set

input datafile file number=00071 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.352.1033576113

input datafile file number=00007 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.288.927068757

input datafile file number=00018 name=+DATA/NPOSQA1/DATAFILE/sysaux.299.951004329

input datafile file number=00047 name=+DATA/NPOSQA1/DATAFILE/users.328.962447655

input datafile file number=00062 name=+DATA/NPOSQA1/DATAFILE/ktexperts_index02.343.1003627249

input datafile file number=00078 name=+DATA/NPOSQA1/DATAFILE/ktexperts_arc_index01.359.1036618425

input datafile file number=00088 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.369.1068880895

input datafile file number=00044 name=+DATA/NPOSQA1/DATAFILE/users.325.962348193

channel d8: starting piece 1 at 16-sep-21 06:54:26

channel d9: starting compressed incremental level 0 datafile backup set

channel d9: specifying datafile(s) in backup set

input datafile file number=00051 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.332.967712637

input datafile file number=00004 name=+DATA/NPOSQA1/DATAFILE/users.282.922456325

input datafile file number=00027 name=+DATA/NPOSQA1/DATAFILE/users.308.962180577

input datafile file number=00054 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.335.972201421

input datafile file number=00073 name=+DATA/NPOSQA1/DATAFILE/ktexperts_arc_index01.354.1036607931

input datafile file number=00083 name=+DATA/NPOSQA1/DATAFILE/ktexperts_data.364.1053991767

input datafile file number=00056 name=+DATA/NPOSQA1/DATAFILE/sysaux.337.974347095

input datafile file number=00066 name=+DATA/NPOSQA1/DATAFILE/undotbs1.347.1004522521

input datafile file number=00036 name=+DATA/NPOSQA1/DATAFILE/users.317.962230593

channel d9: starting piece 1 at 16-sep-21 06:54:27

channel d10: starting compressed incremental level 0 datafile backup set

channel d10: specifying datafile(s) in backup set

input datafile file number=00019 name=+DATA/NPOSQA1/DATAFILE/users.300.958062843

input datafile file number=00011 name=+DATA/NPOSQA1/DATAFILE/sysaux.292.927070223

input datafile file number=00026 name=+DATA/NPOSQA1/DATAFILE/sysaux.307.962123343

input datafile file number=00053 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.334.972201019

input datafile file number=00069 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.350.1016150189

input datafile file number=00082 name=+DATA/NPOSQA1/DATAFILE/ktexperts_archive.363.1046652093

input datafile file number=00001 name=+DATA/NPOSQA1/DATAFILE/system.278.922456299

input datafile file number=00057 name=+DATA/NPOSQA1/DATAFILE/sysaux.338.986488875

input datafile file number=00013 name=+DATA/NPOSQA1/DATAFILE/ktexperts_index.294.927070277

input datafile file number=00032 name=+DATA/NPOSQA1/DATAFILE/users.313.962230489

channel d10: starting piece 1 at 16-sep-21 06:54:27

piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_ca096id1_4_1.bkp tag=INCR0_BACKUP_DBFILES comment=NONE

channel d6: starting piece 5 at 16-sep-21 07:49:36

channel d3: finished piece 4 at 16-sep-21 07:52:41

piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_c7096id0_4_1.bkp tag=INCR0_BACKUP_DBFILES comment=NONE

channel d3: starting piece 5 at 16-sep-21 07:52:41

channel d3: finished piece 5 at 16-sep-21 07:54:36

piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_c7096id0_5_1.bkp tag=INCR0_BACKUP_DBFILES comment=NONE

channel d3: backup set complete, elapsed time: 01:00:12

channel d6: finished piece 5 at 16-sep-21 07:58:36

piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_ca096id1_5_1.bkp tag=INCR0_BACKUP_DBFILES comment=NONE

channel d6: backup set complete, elapsed time: 01:04:11

Finished backup at 16-sep-21 07:58:36

Starting backup at 16-sep-21 07:58:38

RMAN-06820: WARNING: failed to archive current log at primary database

ORACLE error from target database:

ORA-17629: Cannot connect to the remote database server

ORA-17630: Mismatch in the remote file protocol version client 2 server 3

skipping archived logs of thread 1 from sequence 45134 to 45163; already backed up

channel d1: starting archived log backup set

channel d1: specifying archived log(s) in backup set

input archived log thread=1 sequence=45174 RECID=47161 STAMP=1083026193

input archived log thread=1 sequence=45175 RECID=47162 STAMP=1083040841

input archived log thread=1 sequence=45176 RECID=47163 STAMP=1083045969

input archived log thread=1 sequence=45177 RECID=47164 STAMP=1083046069

input archived log thread=1 sequence=45178 RECID=47165 STAMP=1083052676

input archived log thread=1 sequence=45179 RECID=47166 STAMP=1083060346

input archived log thread=1 sequence=45180 RECID=47167 STAMP=1083068352

input archived log thread=1 sequence=45181 RECID=47168 STAMP=1083079257

input archived log thread=1 sequence=45182 RECID=47169 STAMP=1083084492

channel d1: starting piece 1 at 16-sep-21 07:58:42

channel d2: starting archived log backup set

channel d2: specifying archived log(s) in backup set

input archived log thread=1 sequence=45238 RECID=47225 STAMP=1083318141

input archived log thread=1 sequence=45239 RECID=47226 STAMP=1083320835

input archived log thread=1 sequence=45240 RECID=47227 STAMP=1083323469

input archived log thread=1 sequence=45241 RECID=47228 STAMP=1083326901

input archived log thread=1 sequence=45242 RECID=47229 STAMP=1083331053

input archived log thread=1 sequence=45243 RECID=47230 STAMP=1083335004

input archived log thread=1 sequence=45244 RECID=47231 STAMP=1083337992

input archived log thread=1 sequence=45245 RECID=47232 STAMP=1083339763

input archived log thread=1 sequence=45246 RECID=47233 STAMP=1083344413

channel d2: starting piece 1 at 16-sep-21 07:58:42

channel d3: starting archived log backup set

channel d3: specifying archived log(s) in backup set

input archived log thread=1 sequence=45211 RECID=47198 STAMP=1083199359

input archived log thread=1 sequence=45212 RECID=47199 STAMP=1083204543

input archived log thread=1 sequence=45213 RECID=47200 STAMP=1083212799

input archived log thread=1 sequence=45214 RECID=47201 STAMP=1083216967

input archived log thread=1 sequence=45215 RECID=47202 STAMP=1083222448

input archived log thread=1 sequence=45216 RECID=47203 STAMP=1083225778

input archived log thread=1 sequence=45217 RECID=47204 STAMP=1083229147

input archived log thread=1 sequence=45218 RECID=47205 STAMP=1083232966

input archived log thread=1 sequence=45219 RECID=47206 STAMP=1083236137

channel d3: starting piece 1 at 16-sep-21 07:58:42

channel d4: starting archived log backup set

channel d4: specifying archived log(s) in backup set

input archived log thread=1 sequence=45229 RECID=47216 STAMP=1083274955

input archived log thread=1 sequence=45230 RECID=47217 STAMP=1083276851

input archived log thread=1 sequence=45231 RECID=47218 STAMP=1083279344

input archived log thread=1 sequence=45232 RECID=47219 STAMP=1083285779

input archived log thread=1 sequence=45233 RECID=47220 STAMP=1083298193

input archived log thread=1 sequence=45234 RECID=47221 STAMP=1083302478

input archived log thread=1 sequence=45235 RECID=47222 STAMP=1083307869

input archived log thread=1 sequence=45236 RECID=47223 STAMP=1083311823

input archived log thread=1 sequence=45237 RECID=47224 STAMP=1083315534

channel d4: starting piece 1 at 16-sep-21 07:58:42

channel d5: starting archived log backup set

channel d5: specifying archived log(s) in backup set

input archived log thread=1 sequence=45247 RECID=47234 STAMP=1083347263

input archived log thread=1 sequence=45248 RECID=47235 STAMP=1083352570

input archived log thread=1 sequence=45249 RECID=47236 STAMP=1083355786

input archived log thread=1 sequence=45250 RECID=47237 STAMP=1083359959

input archived log thread=1 sequence=45251 RECID=47238 STAMP=1083363163

input archived log thread=1 sequence=45252 RECID=47239 STAMP=1083365146

input archived log thread=1 sequence=45253 RECID=47240 STAMP=1083370395

input archived log thread=1 sequence=45254 RECID=47241 STAMP=1083371647

input archived log thread=1 sequence=45255 RECID=47242 STAMP=1083386792

channel d5: starting piece 1 at 16-sep-21 07:58:42

channel d6: starting archived log backup set

channel d6: specifying archived log(s) in backup set

input archived log thread=1 sequence=45183 RECID=47170 STAMP=1083087771

input archived log thread=1 sequence=45184 RECID=47171 STAMP=1083089226

input archived log thread=1 sequence=45185 RECID=47172 STAMP=1083095052

input archived log thread=1 sequence=45186 RECID=47173 STAMP=1083098955

input archived log thread=1 sequence=45187 RECID=47174 STAMP=1083106069

input archived log thread=1 sequence=45188 RECID=47175 STAMP=1083112940

input archived log thread=1 sequence=45189 RECID=47176 STAMP=1083124819

input archived log thread=1 sequence=45190 RECID=47177 STAMP=1083129622

input archived log thread=1 sequence=45191 RECID=47178 STAMP=1083132583

channel d6: starting piece 1 at 16-sep-21 07:58:42

channel d7: starting archived log backup set

channel d7: specifying archived log(s) in backup set

input archived log thread=1 sequence=45192 RECID=47179 STAMP=1083136222

input archived log thread=1 sequence=45193 RECID=47180 STAMP=1083139745

input archived log thread=1 sequence=45194 RECID=47181 STAMP=1083143159

input archived log thread=1 sequence=45195 RECID=47182 STAMP=1083146738

input archived log thread=1 sequence=45196 RECID=47183 STAMP=1083149942

input archived log thread=1 sequence=45197 RECID=47184 STAMP=1083153014

input archived log thread=1 sequence=45198 RECID=47185 STAMP=1083157220

input archived log thread=1 sequence=45199 RECID=47186 STAMP=1083161513

input archived log thread=1 sequence=45200 RECID=47187 STAMP=1083165938

channel d7: starting piece 1 at 16-sep-21 07:58:42

channel d8: starting archived log backup set

channel d8: specifying archived log(s) in backup set

input archived log thread=1 sequence=45220 RECID=47207 STAMP=1083239824

input archived log thread=1 sequence=45221 RECID=47208 STAMP=1083244627

input archived log thread=1 sequence=45222 RECID=47209 STAMP=1083249424

input archived log thread=1 sequence=45223 RECID=47210 STAMP=1083253099

input archived log thread=1 sequence=45224 RECID=47211 STAMP=1083253408

input archived log thread=1 sequence=45225 RECID=47212 STAMP=1083258413

input archived log thread=1 sequence=45226 RECID=47213 STAMP=1083262099

input archived log thread=1 sequence=45227 RECID=47214 STAMP=1083267581

input archived log thread=1 sequence=45228 RECID=47215 STAMP=1083271856

channel d8: starting piece 1 at 16-sep-21 07:58:42

channel d9: starting archived log backup set

channel d9: specifying archived log(s) in backup set

input archived log thread=1 sequence=45201 RECID=47188 STAMP=1083171218

input archived log thread=1 sequence=45202 RECID=47189 STAMP=1083174584

input archived log thread=1 sequence=45203 RECID=47190 STAMP=1083180285

input archived log thread=1 sequence=45204 RECID=47191 STAMP=1083183783

input archived log thread=1 sequence=45205 RECID=47192 STAMP=1083188106

input archived log thread=1 sequence=45206 RECID=47193 STAMP=1083190082

input archived log thread=1 sequence=45207 RECID=47194 STAMP=1083190084

input archived log thread=1 sequence=45208 RECID=47195 STAMP=1083190084

input archived log thread=1 sequence=45209 RECID=47196 STAMP=1083190117

input archived log thread=1 sequence=45210 RECID=47197 STAMP=1083194649

channel d9: starting piece 1 at 16-sep-21 07:58:42

channel d10: starting archived log backup set

channel d10: specifying archived log(s) in backup set

input archived log thread=1 sequence=45256 RECID=47243 STAMP=1083391322

input archived log thread=1 sequence=45257 RECID=47244 STAMP=1083395952

channel d10: starting piece 1 at 16-sep-21 07:58:42

channel d10: finished piece 1 at 16-sep-21 07:59:27

piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_co096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE

channel d10: backup set complete, elapsed time: 00:00:45

channel d10: starting archived log backup set

channel d10: specifying archived log(s) in backup set

input archived log thread=1 sequence=45164 RECID=47148 STAMP=1082971728

input archived log thread=1 sequence=45165 RECID=47151 STAMP=1082972067

input archived log thread=1 sequence=45166 RECID=47153 STAMP=1082972357

input archived log thread=1 sequence=45167 RECID=47154 STAMP=1082972556

input archived log thread=1 sequence=45168 RECID=47155 STAMP=1082972681

input archived log thread=1 sequence=45169 RECID=47156 STAMP=1082972682

input archived log thread=1 sequence=45170 RECID=47157 STAMP=1082972801

input archived log thread=1 sequence=45171 RECID=47158 STAMP=1082972807

input archived log thread=1 sequence=45172 RECID=47159 STAMP=1082998542

input archived log thread=1 sequence=45173 RECID=47160 STAMP=1082998552

channel d10: starting piece 1 at 16-sep-21 07:59:30

channel d3: finished piece 1 at 16-sep-21 07:59:45

piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_ch096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE

channel d3: backup set complete, elapsed time: 00:01:03

channel d5: finished piece 1 at 16-sep-21 07:59:55

piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_cj096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE

channel d5: backup set complete, elapsed time: 00:01:13

channel d2: finished piece 1 at 16-sep-21 08:00:05

piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_cg096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE

channel d2: backup set complete, elapsed time: 00:01:23

channel d10: finished piece 1 at 16-sep-21 08:00:05

piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_cp096m6v_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE

channel d10: backup set complete, elapsed time: 00:00:35

channel d1: finished piece 1 at 16-sep-21 08:00:15

piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_cf096m5h_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE

channel d1: backup set complete, elapsed time: 00:01:33

channel d4: finished piece 1 at 16-sep-21 08:00:15

piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_ci096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE

channel d4: backup set complete, elapsed time: 00:01:33

channel d6: finished piece 1 at 16-sep-21 08:00:15

piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_ck096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE

channel d6: backup set complete, elapsed time: 00:01:33

channel d7: finished piece 1 at 16-sep-21 08:00:15

piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_cl096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE

channel d7: backup set complete, elapsed time: 00:01:33

channel d8: finished piece 1 at 16-sep-21 08:00:15

piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_cm096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE

channel d8: backup set complete, elapsed time: 00:01:33

channel d9: finished piece 1 at 16-sep-21 08:00:15

piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_cn096m5i_1_1.bkp tag=INCR0_BACKUP_ARCHLOGS comment=NONE

channel d9: backup set complete, elapsed time: 00:01:33

Finished backup at 16-sep-21 08:00:15

Starting Control File and SPFILE Autobackup at 16-sep-21 08:00:15

piece handle=/cloud/rman/NPOSQA1/NPOSQA1_ctrl_spfile_autobkp_c-153864100-20210916-00 comment=NONE

Finished Control File and SPFILE Autobackup at 16-sep-21 08:00:18

sql statement: alter database backup controlfile to trace

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_b408okaf_1_1.bkp RECID=106568 STAMP=1082937680

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/cloud/rman/NPOSQA1/Rman_LVL-0_Bkup_NPOSQA1_cn096m5i_1_1.bkp RECID=106711 STAMP=1083398322

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/cloud/rman/NPOSQA1/NPOSQA1_ctrl_spfile_autobkp_c-153864100-20210916-00 RECID=106712 STAMP=1083398416

.....

Crosschecked 145 objects

RMAN retention policy will be applied to the command

RMAN retention policy is set to recovery window of 8 days

no obsolete backups found

deleted archived log

archived log file name=+RECO/NPOSQA1/ARCHIVELOG/2021_09_10/thread_1_seq_45149.851.1082934337 RECID=47119 STAMP=1082934338

deleted archived log

archived log file name=+RECO/NPOSQA1/ARCHIVELOG/2021_09_15/thread_1_seq_45236.1107.1083311821 RECID=47223 STAMP=1083311823

......

Deleted 88 objects

released channel: d1

released channel: d2

released channel: d3

released channel: d4

released channel: d5

released channel: d6

released channel: d7

released channel: d8

released channel: d9

released channel: d10

Recovery Manager complete.

Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTEXPERTS is always active on below social media platforms.

Facebook : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts

Share via:

Note: Please test scripts in Non Prod before trying in Production.

Binnary Ajay Kumar

Share this post

Oracle : Shell script for RMAN backup of Standby Database

Add Comment Cancel reply

Binnary Ajay Kumar

Share this post

You might also like...

Table/index movement using pl/sql procedure

Datapump export and import from Source PDB to Target PDB

Pluggable database save state

Add Comment Cancel reply