Monday, September 12, 2016

RMAN Hot backp script


rman target / log /backup/prod/hot_bkp_12sep16/db/hot_bkp_12Sep2016.log
run{
ALLOCATE CHANNEL ch00 TYPE DISK;
ALLOCATE CHANNEL ch01 TYPE DISK;
ALLOCATE CHANNEL ch02 TYPE DISK;
ALLOCATE CHANNEL ch03 TYPE DISK;
ALLOCATE CHANNEL ch04 TYPE DISK;
ALLOCATE CHANNEL ch05 TYPE DISK;
ALLOCATE CHANNEL ch06 TYPE DISK;
ALLOCATE CHANNEL ch07 TYPE DISK;
ALLOCATE CHANNEL ch08 TYPE DISK;
ALLOCATE CHANNEL ch09 TYPE DISK;
BACKUP AS COMPRESSED BACKUPSET
   FORMAT '/backup/prod/hot_bkp_12sep16/db/%d_db_u%u_s%s_p%p_t%t_db'    
  FILESPERSET 10
   TAG 'prod_HOT'
   DATABASE;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;
RELEASE CHANNEL ch04;
RELEASE CHANNEL ch05;
RELEASE CHANNEL ch06;
RELEASE CHANNEL ch07;
RELEASE CHANNEL ch08;
RELEASE CHANNEL ch09;
}
run{
ALLOCATE CHANNEL ch00 TYPE DISK;
BACKUP FORMAT '/backup/prod/hot_bkp_12sep16/db/%d_db_u%u_s%s_p%p_t%t_db_ctrlfile' TAG 'prod_ctrl' CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}
exit;

1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete