Pular para o conteúdo

› Fóruns › Banco de dados Oracle › RMAN – Não restaura o backup › RMAN – Não restaura o backup

21 de janeiro de 2011 às 6:22 pm #97901
mpvargas
Participante

    Eu fiz isso sim Vieri, conforme as dicas…

    Restaurei control file
    RMAN> startup nomount
    RMAN> restore controlfile from ‘/logs/bkprman/ASOEC10_740374552_3534_%r.bkp’;

    RMAN> alter database mount;

    Cataloguei os backups
    CATALOG backuppiece ‘/logs/bkprman/ASOEC10_740889066_3596_%r.bkp’;
    CATALOG backuppiece ‘/logs/bkprman/ASOEC10_740889066_3597_%r.bkp’;
    CATALOG backuppiece ‘/logs/bkprman/ASOEC10_740889066_3598_%r.bkp’;
    CATALOG backuppiece ‘/logs/bkprman/ASOEC10_740889066_3599_%r.bkp’;
    CATALOG backuppiece ‘/logs/bkprman/ASOEC10_740889153_3600_%r.bkp’;
    CATALOG backuppiece ‘/logs/bkprman/ASOEC10_740889153_3601_%r.bkp’;
    CATALOG backuppiece ‘/logs/bkprman/ASOEC10_740889154_3602_%r.bkp’;
    CATALOG backuppiece ‘/logs/bkprman/ASOEC10_740889154_3603_%r.bkp’;
    CATALOG backuppiece ‘/logs/bkprman/ASOEC10_740890020_3604_%r.bkp’;
    CATALOG backuppiece ‘/logs/bkprman/ASOEC10_740892995_3605_%r.bkp’;
    CATALOG backuppiece ‘/logs/bkprman/ASOEC10_740892998_3606_%r.bkp’;

    Executei o RESTORE DATABASE
    RUN {
    ALLOCATE CHANNEL C1 DEVICE TYPE DISK;
    …
    set newname for datafile 27 to ‘/backup/tbsasoec10/dados15/dados15.dbf’;
    RESTORE DATABASE;
    switch datafile all;

    E ao executar o RECOVER apresentou o erro.