Pular para o conteúdo

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

#97892
mpvargas
Participante

    Fala Cleiton,
    Eu uso o catálogo sim…
    Abaixo as queries solicitadas:

    SQL> select * from v$backup;
    1 NOT ACTIVE 0
    2 NOT ACTIVE 0
    3 NOT ACTIVE 0
    4 NOT ACTIVE 0
    5 NOT ACTIVE 0
    6 NOT ACTIVE 0
    7 NOT ACTIVE 0
    8 NOT ACTIVE 0
    9 NOT ACTIVE 0
    10 NOT ACTIVE 0
    11 NOT ACTIVE 0
    12 NOT ACTIVE 0
    13 NOT ACTIVE 0
    14 NOT ACTIVE 0
    15 NOT ACTIVE 0
    16 NOT ACTIVE 0
    17 NOT ACTIVE 0
    18 NOT ACTIVE 0
    19 NOT ACTIVE 0
    20 NOT ACTIVE 0
    21 NOT ACTIVE 0
    22 NOT ACTIVE 0
    23 NOT ACTIVE 0
    24 NOT ACTIVE 0
    25 NOT ACTIVE 0
    26 NOT ACTIVE 0
    27 NOT ACTIVE 0

    Banco restaurado
    SQL> SELECT * FROM v$recover_file;
    2 ONLINE ONLINE 2219970737 20-JAN-11
    5 ONLINE ONLINE 2219970736 20-JAN-11
    6 ONLINE ONLINE 2219970737 20-JAN-11
    7 ONLINE ONLINE 2219970736 20-JAN-11
    11 ONLINE ONLINE 2219970736 20-JAN-11
    12 ONLINE ONLINE 2219970736 20-JAN-11
    14 ONLINE ONLINE 2219970737 20-JAN-11
    15 ONLINE ONLINE 2219970737 20-JAN-11
    16 ONLINE ONLINE 2219970736 20-JAN-11
    17 ONLINE ONLINE 2219970737 20-JAN-11
    19 ONLINE ONLINE 2219970736 20-JAN-11
    20 ONLINE ONLINE 2219970736 20-JAN-11
    22 ONLINE ONLINE 2219970737 20-JAN-11
    23 ONLINE ONLINE 2219970737 20-JAN-11

    Erro no Recover
    RMAN-06025: no backup of log thread 1 seq 7510 lowscn 2196352371 found to restore

    No banco de produção:
    SQL> SELECT SEQUENCE#, RESETLOGS_CHANGE#, FIRST_CHANGE#, NEXT_CHANGE# FROM V$ARCHIVED_LOG WHERE SEQUENCE# = 7510;

    SEQUENCE# RESETLOGS_CHANGE# FIRST_CHANGE# NEXT_CHANGE#
    ———- ————————- —————— ——————
    7510 525876 2196352371 2196454248

    O NAME está em branco
    SQL> SELECT NAME, SEQUENCE# FROM V$ARCHIVED_LOG WHERE SEQUENCE# = 7510;

    NAME

    SEQUENCE#

      7510
    

    Isso quer dizer que o arquivo foi deletado?

    Só tem o name a partir do 7660
    /logs/flash_recovery_area/ASOEC10/archivelog/2011_01_18/o1_mf_1_7661_6mb9qswb_.arc

    referente a um arquivo do dia 18/01/2011