some useful backup scripts

Execute below  statement & re-triggered  stats for fixed objects .

$ sqlplus / as sysdba

 EXEC dbms_stats.init_package();

Backup  status

col STATUS format a9
col hrs format 999.99
select
SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,
to_char(END_TIME,'mm/dd/yy hh24:mi')   end_time,
elapsed_seconds/3600                   hrs
from V$RMAN_BACKUP_JOB_DETAILS
order by session_key;

--This script will report all on full and incremental backups, not archivelog backups –

col STATUS format a9
col hrs format 999.99
select
SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,
to_char(END_TIME,'mm/dd/yy hh24:mi')   end_time,
elapsed_seconds/3600                   hrs
from V$RMAN_BACKUP_JOB_DETAILS
where input_type='DB INCR'
order by session_key;

=============================================

#!/bin/ksh

ORACLE_SID=ZAGIPROD

ORACLE_HOME=/opt/oracle/product/11.2.0

PATH=$ORACLE_HOME/bin:$PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib

LOG_DEST=/home/oracle

export ORACLE_SID ORACLE_HOME PATH LOG_DEST LD_LIBRARY_PATH

$ORACLE_HOME/bin/rman target sys/oracle123@ZAGI AUXILIARY / log=/var/opt/oracle/archv01/ZAGIPROD_ZAGIPROD.log << EOF

run

{

allocate auxiliary channel t1 type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=eprdbs1-b)';

allocate auxiliary channel t2 type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=eprdbs1-b)';

allocate auxiliary channel t3 type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=eprdbs1-b)';

allocate auxiliary channel t4 type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=eprdbs1-b)';

allocate auxiliary channel t5 type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=eprdbs1-b)';

set until time "to_date('2015/10/28-05:18:50','YYYY/MM/DD-HH24:MI:SS')";

}

EXIT;

EOF

==============================================================

#!/bin/ksh

ORACLE_SID=ZAGIPROD

ORACLE_HOME=/opt/oracle/product/11.2.0

PATH=$ORACLE_HOME/bin:$PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib

LOG_DEST=/home/oracle

export ORACLE_SID ORACLE_HOME PATH LOG_DEST LD_LIBRARY_PATH

$ORACLE_HOME/bin/rman target / log=/var/opt/oracle/archv01/ZAGIPROD_ZAGIPROD.log << EOF

RUN

{ 

  ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/var/opt/oracle/archv01/ZAGIPROD/%U';

  ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '/var/opt/oracle/ZAGI/disk2/%U';

  ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT '/var/opt/oracle/ZAGI/disk3/%U';

  ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT '/var/opt/oracle/ZAGI/disk4/%U';

  ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT '/var/opt/oracle/archv1/%U';

  ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT '/var/opt/oracle/bkup1/%U';

  BACKUP database plus archivelog; 

} 

EXIT;

EOF

ORACLE_SID=DWEBPRE3

ORACLE_HOME=/opt/oracle/product/11.2.0  

PATH=$ORACLE_HOME/bin:$PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib

LOG_DEST=/home/oracle

export ORACLE_SID ORACLE_HOME PATH LOG_DEST LD_LIBRARY_PATH

$ORACLE_HOME/bin/rman target sys/oracle123************  AUXILIARY / log=/home/oracle/RMAN_clone_DWEBPRE1_to_DWEBPRE3as.log << EOF

run

{

allocate auxiliary channel t1 type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=kcomd16-b)';

allocate auxiliary channel t2 type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=kcomd16-b)';

allocate auxiliary channel t3 type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=kcomd16-b)';

allocate auxiliary channel t4 type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=kcomd16-b)';

allocate auxiliary channel t5 type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=kcomd16-b)';

set until time "to_date('2014/10/09-08:22:21','YYYY/MM/DD-HH24:MI:SS')"; 

duplicate target database to DWEBPREasda nofilenamecheck;

}

EXIT;

EOF

$

RUN

{ 

  ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/var/opt/oracle/archv01/ZAGIPROD/%U';

  ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '/var/opt/oracle/ZAGI/disk2/%U';

  ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT '/var/opt/oracle/ZAGI/disk3/%U';

  ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT '/var/opt/oracle/ZAGI/disk4/%U';

  ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT '/var/opt/oracle/archv1/%U';

  ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT '/var/opt/oracle/bkup1/%U';

  BACKUP AS COPY DATABASE; 

}