Archive for 2015

Friday, December 25, 2015

Backup Full Database 12c Script

5:48 PM Posted by Vtgdb No Comments

Task 1: Preparing to Use the Oracle Suggested Backup Strategy

To use the Oracle suggested backup strategy, ensure that:

The database is ARCHIVELOG mode
The fast recovery area size is configured, or a default device for storing backups is configured.
You have added a database host user to the OSBACKUPUPDBA operating system group, for operating system authentication.

Task 2: Create the Backup full Script-UNIX and Linux

[oracle@SERVER_DATABASE rman]$ pwd

/u01/app/oracle/rman_backup

[oracle@SERVER_DATABASE rman]$ more backup_script_full.sh

#!/bin/bash

ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/db_1;export ORACLE_HOME

ORACLE_SID=orcl; export ORACLE_SID

PATH=$PATH:$ORACLE_HOME/bin; export PATH

chk_date=`date +%d`

chk_parity=`expr $chk_date % 2`

export bkdir=/backup11

BACKUP_DIR=$bkdir; export BACKUP_DIR

export DATA_DIR=$BACKUP_DIR/backup_full

export ARC_DIR=$BACKUP_DIR/backup_full

export BACKUP_DATA=$DATA_DIR/$ORACLE_SID"_data_f%t_s%s_s%p"

export BACKUP_ARC=$ARC_DIR/$ORACLE_SID"_arc_f%t_s%s_s%p"

export ORACLE_OWNER=oracle

export DATE=`date +%Y%m%d`

export IP=168_133

########### SCRIPT CHECK BACKUP FAILED############

backup_log_err='/u01/app/monitoring/log/backup_log.err';

backup_log_finish='/u01/app/monitoring/log/backup_log.finish';

/usr/bin/ls -lt /u01/app/rman_backup/log_full > $list_file;

i=1

while read line

let i=$i+1;

if [ $i -gt 2 ]

then

backup_log='/u01/app/rman_backup/log_full/'`echo $line | awk '{print $9}'`;

break;

done < "$list_file"

grep -i error $backup_log > $backup_log_err

grep "Recovery Manager complete" $backup_log > $backup_log_finish

if [ `cat $backup_log_err|wc -l` -gt 0 ]

then

echo 'Backup have error';

exit;

if [ !`cat $backup_log_finish|wc -l` -gt 0 ]

then

echo 'Backup have not finished yet';

exit;

#######################################

cd $BACKUP_DIR

rm -rf backup_full_*

mv backup_full backup_full_$DATE

mkdir -p $DATA_DIR

mkdir -p $ARC_DIR

$ORACLE_HOME/bin/rman target / log /u01/app/rman_backup/log_full/rman_backup_full_$IP"_"$DATE.log <<EOF

RUN {

CROSSCHECK BACKUP OF DATABASE;

CROSSCHECK ARCHIVELOG ALL;

BACKUP AS COMPRESSED BACKUPSET FORMAT '$BACKUP_ARC' ARCHIVELOG ALL DELETE INPUT;

BACKUP AS COMPRESSED BACKUPSET FORMAT '$BACKUP_DATA' DATABASE SKIP READONLY;

SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';

BACKUP AS COMPRESSED BACKUPSET FORMAT '$BACKUP_ARC' ARCHIVELOG ALL DELETE INPUT;

BACKUP CURRENT CONTROLFILE;

}

exit;

EOF

Task 3: Testing the Backup Script

[oracle@SERVER_DATABASE rman]$ chmod 775 backup_script_full.sh

[oracle@SERVER_DATABASE rman]$ nohup ./ backup_script_full.sh &

[oracle@SERVER_DATABASE rman]$ tailf nohup.log

RMAN-00557: could not open MSGLOG "/u01/app/rman_backup/log_full/rman_backup_full_165_145_20151225.log"

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Dec 25 17:05:50 2015

connected to target database:ORCL (DBID=1723703927)

RMAN> 2> 3> 4> 5> 6> 7> 8> 9>

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=4018 instance=ptud11 device type=DISK

specification does not match any backup in the repository

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=4018 instance=ptud11 device type=DISK