All pastes #123360 Raw Edit

Miscellany

public text v1 · immutable
·published 2006-08-09 06:59 UTC
rendered paste body
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/mnt/master_backup/%F';
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

spool log to 'backup_db.log';

run
{
 
  allocate channel c1 type disk;

  backup full TAG='nightly_full_backup'
  filesperset 30
  database format '/mnt/master_backup/full_%p%d.%s'
  plus archivelog format '/mnt/master_backup/arc__%p%d.%s' delete input;

  release channel c1;

  delete obsolete;
}