Pular para o conteúdo

› Fóruns › Banco de dados Oracle › RMAN-06556: datafile 1 must be restored [RESOLVIDO] › RMAN-06556: datafile 1 must be restored [RESOLVIDO]

31 de agosto de 2011 às 11:27 pm #100622
mpvargas
Participante

    RESULTADO DO RECOVER

    RMAN> RECOVER DATABASE;

    Starting recover at 31-AUG-11
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=156 devtype=DISK

    starting media recovery

    archive log thread 1 sequence 11139 is already on disk as file /logs/flash_recovery_area/ASOEC10/archivelog/2011_08_14/o1_mf_1_11139_74h2bc01_.arc
    archive log thread 1 sequence 11140 is already on disk as file /logs/flash_recovery_area/ASOEC10/archivelog/2011_08_14/o1_mf_1_11140_74jpmksh_.arc
    archive log thread 1 sequence 11141 is already on disk as file /logs/flash_recovery_area/ASOEC10/archivelog/2011_08_14/o1_mf_1_11141_74jpnvfv_.arc
    archive log thread 1 sequence 11142 is already on disk as file /logs/flash_recovery_area/ASOEC10/archivelog/2011_08_14/o1_mf_1_11142_74k24r41_.arc
    archive log thread 1 sequence 11143 is already on disk as file /logs/flash_recovery_area/ASOEC10/archivelog/2011_08_14/o1_mf_1_11143_74k2vj2j_.arc
    archive log filename=/logs/flash_recovery_area/ASOEC10/archivelog/2011_08_14/o1_mf_1_11139_74h2bc01_.arc thread=1 sequence=11139
    archive log filename=/logs/flash_recovery_area/ASOEC10/archivelog/2011_08_14/o1_mf_1_11140_74jpmksh_.arc thread=1 sequence=11140
    archive log filename=/logs/flash_recovery_area/ASOEC10/archivelog/2011_08_14/o1_mf_1_11141_74jpnvfv_.arc thread=1 sequence=11141
    archive log filename=/logs/flash_recovery_area/ASOEC10/archivelog/2011_08_14/o1_mf_1_11142_74k24r41_.arc thread=1 sequence=11142
    archive log filename=/logs/flash_recovery_area/ASOEC10/archivelog/2011_08_14/o1_mf_1_11143_74k2vj2j_.arc thread=1 sequence=11143
    unable to find archive log
    archive log thread=1 sequence=11144
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of recover command at 08/31/2011 15:54:06
    RMAN-06054: media recovery requesting unknown log: thread 1 seq 11144 lowscn 2491112741

    Gostaria de restaurar até um ponto anterior mas está dando erro.