[TD - ORACLE] oracle backup script using RMAN

This is  oracle full backup script using RMAN

 

1. The following parts need to be modified in the script

         

 

1. Backup location

          ## backup location = /backup <= backup path

         

2. oracle profile

                Change the following variables ( ORACLE_BASE, ORACLE_HOME….)        

       #########  oracle profile ########################################

         export ORACLE_BASE=/oracle                                 

         export ORACLE_HOME=$ORACLE_BASE/app/oracle/product/11.2    

        export ORACLE_SID=ppro                                     

        export PATH=$PATH:/usr/bin:/usr/sbin:$ORACLE_HOME/bin      

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

 

        3)  crontab  ( backup time)  Register crontab for automatic execution

          ## 30 3 * * 1-6 /PATH /full_backup.sh ##  backup time  in crontab

 

2. How to execute  ( #sh full_backup.sh as oracle account)

 

3. You can check  backup file  in /backup partition

 

4. Display  full_backup.sh

 

 

Script

[oracle@ogg2 backup]$ cat full_backup.sh

 

#!/bin/sh

#tart the rman commands

export ORACLE_BASE=/oracle

export ORACLE_HOME=$ORACLE_BASE/app/oracle/product/11.2

export ORACLE_SID=east

export PATH=$PATH:/usr/bin:/usr/sbin:$ORACLE_HOME/bin

 

rman target=/ << EOF

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;

RUN

{

  ALLOCATE CHANNEL ch1 TYPE DISK MAXPIECESIZE 10G;

  sql 'alter system archive log current';

  BACKUP   AS compressed backupset

  FORMAT '/backup/%d_full_db_%T_%s'

  DATABASE ;

 

  BACKUP SPFILE

  FORMAT '/backup/%d_spfile_%T_%s' ;

 

  BACKUP AS compressed backupset

  FORMAT '/backup/%d_arc_%T_%s' archivelog all DELETE INPUT ;

 

  BACKUP AS compressed backupset

  FORMAT '/backup/%d_control_%T_%s'

  CURRENT CONTROLFILE;

 

  crosscheck backup;

  crosscheck archivelog all;

  delete noprompt obsolete;

  delete noprompt expired backup;

  delete noprompt archivelog until time 'SYSDATE - 3';

}

EXIT;

EOF

#