Restore Archivelog

Dúvidas, dicas e atualizações sobre o Treinamento Oracle Backup & Recovery.
Post Reply
abonacin

Restore Archivelog

Post by abonacin »

Ola, boa noite...

Estou fazendo algo errado?
Fiz o backup em um server e copiei para outro.

Restaurei o controlfile, montei o banco e nao consigo restaurar os archives.

______________________________________________________
[oracle@rescue ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Thu Dec 19 20:58:45 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: BACREC (DBID=2045346895, not open)

______________________________________________________
RMAN> crosscheck backup of archivelog all;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=771 device type=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/backup/bacrec/bkp_BACREC_185_1_5porsj69_1_1.bkp RECID=178 STAMP=834556496
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/backup/bacrec/bkp_BACREC_187_1_5rorsj6t_1_1.bkp RECID=179 STAMP=834556496
Crosschecked 2 objects

______________________________________________________
RMAN> list backup of archivelog all;


List of Backup Sets
===================


BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
174 49.05M DISK 00:00:00 19-DEC-13
BP Key: 178 Status: AVAILABLE Compressed: YES Tag: TAG20131219T045121
Piece Name: /u01/backup/bacrec/bkp_BACREC_185_1_5porsj69_1_1.bkp

List of Archived Logs in backup set 174
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 90 840976 14-DEC-13 863294 15-DEC-13
1 91 863294 15-DEC-13 884082 15-DEC-13
1 92 884082 15-DEC-13 915208 16-DEC-13
1 93 915208 16-DEC-13 916407 16-DEC-13
1 94 916407 16-DEC-13 916516 16-DEC-13
1 95 916516 16-DEC-13 943132 17-DEC-13
1 96 943132 17-DEC-13 986686 19-DEC-13
1 97 986686 19-DEC-13 987693 19-DEC-13
1 98 987693 19-DEC-13 987703 19-DEC-13

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
175 2.50K DISK 00:00:00 19-DEC-13
BP Key: 179 Status: AVAILABLE Compressed: YES Tag: TAG20131219T045141
Piece Name: /u01/backup/bacrec/bkp_BACREC_187_1_5rorsj6t_1_1.bkp

List of Archived Logs in backup set 175
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 99 987703 19-DEC-13 987727 19-DEC-13

______________________________________________________

RMAN> run{
2> set archivelog destination to '/u01/arch/bacrec/';
3> restore archivelog from sequence 90 until sequence 99;
4> }

executing command: SET ARCHIVELOG DESTINATION

Starting restore at 19-DEC-13
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/19/2013 21:03:03
RMAN-20242: specification does not match any archived log in the repository
______________________________________________________


Grato pela ajuda.

portilho
Site Admin
Posts: 497
Joined: Wed May 29, 2013 8:51 am

Re: Restore Archivelog

Post by portilho »

Meu palpite é quando este backup de CONTROLFILE foi criado, algum destes ARCHIVED REDO LOGs não existia ainda.
Então, o RMAN sabe que estes BACKUPs existem (você deve ter copiado para o mesmo local no outro servidor), mas não conhece estas SEQUENCEs.

O que a V$LOG mostra, no servidor destino?

Post Reply