SHELL SCRIPT

RMAN backup using shell script

REQUIREMENT: Configure shell script to take rman Full backup . SCRIPT: ( rman_full_bkp.sh) # $Header: rman_full_bkp.sh # *====================================================================================+ # | Author – DBACLASS ADMIN TEAM # | | # +====================================================================================+ # | # | DESCRIPTION # | Take rman full backup(incremental level 0 ) # | PLATFORM # | Linux/Solaris/HP-UX # +===========================================================================+ #!/bin/bash RMANBACKUP_MOUNTPOINT1=/u01/oracle/rman_bkp PARALLELISM=4 MAXPIECESIZE=3g […]

Kill snipped sessions in oracle db

REQUIREMENT: Configure a shell script, to kill the snipped sessions in the database regularly.   SHELL SCRIPT: # $Header: kill_snipped.sh # *====================================================================================+ # | Author – DBACLASS ADMIN TEAM # | | # +====================================================================================+ # | # | DESCRIPTION # | Kill the snipped session in database # | PLATFORM # | Linux/Solaris/HP-UX # +===========================================================================+ […]

expdp backup using shell script

Requirement: Configure a shell script, to take export backup of table daily at 3 PM  and send the log to stake holders. Script: ( EXP_TAB_cmprss.sh) # $Header: EXP_TAB_cmprss.sh # *====================================================================================+ # | Author – DBACLASS ADMIN TEAM # | | # +====================================================================================+ # | # | FILENAME # | EXP_table_bkp_cmprss_dbaclass.sh # | # | DESCRIPTION […]