Pular para o conteúdo

Fóruns Banco de dados Oracle Restore com RMAN Restore com RMAN

#90094
jspaulonci
Participante

    piece handle=/u02/dbabkp/hml1/rman/backup/backup_db_DBHML1_S_14803_P_10_T_699133096 tag=TAG20091001T183208
    channel ORA_DISK_1: restore complete, elapsed time: 00:31:47
    Finished restore at 02-OCT-09

    Starting recover at 02-OCT-09
    using channel ORA_DISK_1
    using channel ORA_DISK_2

    starting media recovery

    channel ORA_DISK_1: starting archive log restore to default destination
    channel ORA_DISK_2: starting archive log restore to default destination
    channel ORA_DISK_1: restoring archive log
    archive log thread=1 sequence=10404
    channel ORA_DISK_1: reading from backup piece /u02/dbabkp/hml1/rman/backup/backup_db_DBHML1_S_14804_P_1_T_699136022
    channel ORA_DISK_2: restoring archive log
    archive log thread=2 sequence=10527
    channel ORA_DISK_2: reading from backup piece /u02/dbabkp/hml1/rman/backup/backup_db_DBHML1_S_14805_P_1_T_699136022
    channel ORA_DISK_1: restored backup piece 1
    piece handle=/u02/dbabkp/hml1/rman/backup/backup_db_DBHML1_S_14804_P_1_T_699136022 tag=TAG20091001T202702
    channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
    archive log filename=+FLASH/dbhml1/archivelog/2009_10_02/thread_1_seq_10404.293.699200073 thread=1 sequence=10404
    channel ORA_DISK_2: restored backup piece 1
    piece handle=/u02/dbabkp/hml1/rman/backup/backup_db_DBHML1_S_14805_P_1_T_699136022 tag=TAG20091001T202702
    channel ORA_DISK_2: restore complete, elapsed time: 00:00:03
    archive log filename=+FLASH/dbhml1/archivelog/2009_10_02/thread_2_seq_10527.290.699200073 thread=2 sequence=10527
    channel default: deleting archive log(s)
    archive log filename=+FLASH/dbhml1/archivelog/2009_10_02/thread_1_seq_10404.293.699200073 recid=20199 stamp=699200073
    unable to find archive log
    archive log thread=1 sequence=10405
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of recover command at 10/02/2009 14:14:36
    RMAN-06054: media recovery requesting unknown log: thread 1 seq 10405 lowscn 1143172540558

    ta aí Vieri….peguei o último backup full, fiz o restore until o SCN , e mesmo assim não vai ….sinceramente não sei o que fazer….