› Fóruns › Banco de dados Oracle › RMAN – Não restaura o backup › RMAN – Não restaura o backup
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