Pular para o conteúdo

Fóruns Banco de dados Oracle Testes do RMAN Testes do RMAN

#84933
Rodrigo Almeida
Participante

    Marcelo,

    Pode adicionar os comandos abaixo para deixar mais completo.

    $ cat rman_bkp.cmd
    connect catalog rman/password@rman
    connect target /
    run {
    crosscheck archivelog all;
    delete noprompt obsolete;
    allocate channel ch1 type disk format ‘/home/oracle/bkprman/%d_%t_%s_%r.bkp’;
    allocate channel ch2 type disk format ‘/home/oracle/bkprman/%d_%t_%s_%r.bkp’;
    backup as compressed backupset database include current controlfile;
    backup spfile;
    [b]sql ‘alter system archive log current’;
    backup as compressed backupset archivelog all delete all input tag ‘archives’;[/b]
    release channel ch1;
    release channel ch2;
    }[/b]