SHELL SCRIPT FOR ORACLE DBA

Crontab scheduling in Unix environment


* * * * * *  /opt/oracle/backup.sh
| | | | | |
| | | | | +-- Year              (range: 1900-3000)
| | | | +---- Day of the Week   (range: 1-7, 1 standing for Monday)
| | | +------ Month of the Year (range: 1-12)
| | +-------- Day of the Month  (range: 1-31)
| +---------- Hour              (range: 0-23)
+------------ Minute            (range: 0-59)

SCRIPT FOR RMAN BACKUP

Must be set control file autobackup on

//full incremental level 0  backup

DELETE OBSOLETE;
DELETE EXPIRED ARCHIVELOG ALL;
crosscheck archivelog all;
run
{
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
allocate channel c1 type disk
maxpiecesize=500m;
backup incremental level 0 database tag='weekly_level0';
backup archivelog from time 'sysdate-1' until time 'sysdate';
release channel c1;
}

backup current controlfile;
backup spfile;


//////////////full backup specified directory


run {
     allocate channel ch1 type Disk maxpiecesize = 1900M;
     backup full database noexclude
     include current controlfile
     format '/opt/oracle/backup/datafile_%s_%p.bak'
     tag 'datafile_daily';
   }

run {
     allocate channel ch1 type Disk maxpiecesize = 1900M;
     backup archivelog all
     format '/opt/oracle/backup/archivelog_%s_%p.bak'
     tag 'archivelog_daily';
   }

run {
   allocate channel ch1 type Disk maxpiecesize = 1900M;
   backup format '/opt/oracle/backup/controlfile_%s.bak'
   current controlfile;
   }

ORACLE EXAM DUMP PAPER FOR CERTIFICATION

Check following link to access the oracle exam dump SQL,OCA,OCP on Oracle 10g

Copy and paste on browser


https://drive.google.com/folderview?id=0ByQqSfeaD8_tN3dPSno0SlVoN3M&usp=drive_web

HAPPY HOLI 2014 TO ALL

Happy Holi