lunes, 13 de mayo de 2019

BACKUP ARCHIVELOG

rman> backup archivelog all;
rman> backup archivelog delete input;
rman> backup archivelog all not backed up 1 times;
rman> delete archivelog all completed before 'sysdate - 2';
rman> delete noprompt archivelog all completed before 'sysdate - 2';

RMAN> run {
       allocate channel t1 type disk;
       backup
          format '/recover/oracle/%d/arc_%d_%t_%s'
          archivelog until time 'sysdate-10' delete input;
       }
RMAN> list archivelog all;
RMAN> list backup of archivelog all;


RMAN> crosscheck archivelog all;
RMAN> delete noprompt expired archivelog all;
RMAN> delete noprompt archivelog until time 'sysdate -7';
RMAN> backup as copy archivelog all to destination '/path/to/backup/';

RMAN> BACKUP ARCHIVELOG
  FROM SEQUENCE 288 UNTIL SEQUENCE 388
  THREAD 1
  DELETE INPUT;


RMAN> BACKUP DEVICE TYPE sbt
  ARCHIVELOG ALL FROM TIME 'SYSDATE-10'
  DELETE ALL INPUT;

No hay comentarios: