Menu de navegação

[mpvargasParticipante]

Caros Amigos,
restaurei um backup antigo e estou com o seguinte problema:

RMAN> RECOVER DATABASE UNTIL SEQUENCE 11140;

Starting recover at 31-AUG-11
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/31/2011 16:19:52
RMAN-06556: datafile 1 must be restored from backup older than scn 2490944809

[mpvargasParticipante]

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.

[mpvargasParticipante]

O Recover finalizou, mas após o “alter database open resetlogs” estou recebendo a mensagem abaixo

Finished recover at 31-AUG-11

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 08/31/2011 19:30:28
ORA-01153: an incompatible media recovery is active

[Autor]

Posts