rman_full.sh
#!/bin/bash #source /home/oracle/.bash_profile . /u01/PROD/19.0.0/EBSCDB_erpprddb1.env export LOGNAME=`date +%m%d` echo '-------------------------------------------------------------------'>/u01/backup/backlogs/$LOGNAME.log echo '###################################################################'>>/u01/backup/backlogs/$LOGNAME.log echo '-------------------------------------------------------------------'>>/u01/backup/backlogs/$LOGNAME.log echo '-------------------------------------------------------------------'>>/u01/backup/backlogs/$LOGNAME.log echo '------------Start FULL Database Backup at:'`date +%Y-%m-%d:%H:%M:%S`>>/u01/backup/backlogs/$LOGNAME.log echo '-------------------------------------------------------------------'>>/u01/backup/backlogs/$LOGNAME.log rman target / nocatalog log /u01/backup/backlogs/$LOGNAME.log append<<EOF run{ allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; backup as compressed backupset incremental level 0 database format '/u01/backup/oraback/full_%d_%T_%s_%p'; SQL 'alter system archive log current'; SQL 'alter system archive log current'; backup as compressed backupset archivelog all delete input format '/u01/backup/oraback/arch_%d_%T_%s_%p'; backup current controlfile format '/u01/backup/oraback/ctl_%d_%T_%s_%p'; backup spfile format '/u01/backup/oraback/spfile_%d_%T_%s_%p'; release channel c1; release channel c2; release channel c3; } EOF echo '-------------------------------------------------------------------'>>/u01/backup/backlogs/$LOGNAME.log echo '--------------End Full Database Backup at:'`date +%Y-%m-%d:%H:%M:%S`>>/u01/backup/backlogs/$LOGNAME.log echo '-------------------------------------------------------------------'>>/u01/backup/backlogs/$LOGNAME.log rman target / nocatalog log /u01/backup/backlogs/$LOGNAME.log append<<EOF allocate channel for maintenance type disk; crosscheck backup; crosscheck archivelog all; delete noprompt obsolete; delete noprompt expired backup; delete noprompt expired archivelog all; EOF echo '-------------------------------------------------------------------'>>/u01/backup/backlogs/$LOGNAME.log echo '###################################################################'>>/u01/backup/backlogs/$LOGNAME.log echo '-------------------------------------------------------------------'>>/u01/backup/backlogs/$LOGNAME.log exit
rman_lv1.sh
#!/bin/bash #source /home/oracle/.bash_profile . /u01/PROD/19.0.0/EBSCDB_erpprddb1.env export LOGNAME=`date +%m%d` echo '-------------------------------------------------------------------'>/u01/backup/backlogs/$LOGNAME.log echo '###################################################################'>>/u01/backup/backlogs/$LOGNAME.log echo '-------------------------------------------------------------------'>>/u01/backup/backlogs/$LOGNAME.log echo '-------------------------------------------------------------------'>>/u01/backup/backlogs/$LOGNAME.log echo '------------Start FULL Database Backup at:'`date +%Y-%m-%d:%H:%M:%S`>>/u01/backup/backlogs/$LOGNAME.log echo '-------------------------------------------------------------------'>>/u01/backup/backlogs/$LOGNAME.log rman target / nocatalog log /u01/backup/backlogs/$LOGNAME.log append<<EOF run{ allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; backup as compressed backupset incremental level 1 database format '/u01/backup/oraback/lv1_%d_%T_%s_%p'; SQL 'alter system archive log current'; SQL 'alter system archive log current'; backup as compressed backupset archivelog all delete input format '/u01/backup/oraback/arch_%d_%T_%s_%p'; backup current controlfile format '/u01/backup/oraback/ctl_%d_%T_%s_%p'; backup spfile format '/u01/backup/oraback/spfile_%d_%T_%s_%p'; release channel c1; release channel c2; release channel c3; } EOF echo '-------------------------------------------------------------------'>>/u01/backup/backlogs/$LOGNAME.log echo '--------------End Full Database Backup at:'`date +%Y-%m-%d:%H:%M:%S`>>/u01/backup/backlogs/$LOGNAME.log echo '-------------------------------------------------------------------'>>/u01/backup/backlogs/$LOGNAME.log rman target / nocatalog log /u01/backup/backlogs/$LOGNAME.log append<<EOF allocate channel for maintenance type disk; crosscheck backup; crosscheck archivelog all; delete noprompt obsolete; delete noprompt expired backup; delete noprompt expired archivelog all; EOF echo '-------------------------------------------------------------------'>>/u01/backup/backlogs/$LOGNAME.log echo '###################################################################'>>/u01/backup/backlogs/$LOGNAME.log echo '-------------------------------------------------------------------'>>/u01/backup/backlogs/$LOGNAME.log exit