Re: How to extract redo logfiles from a rman backup set

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Sun, 12 Nov 2006 14:40:55 -0400
Message-ID: <cd4305c10611121040q7a42f538oed491587a47a79c0@mail.gmail.com>

Thank Jared and Steve, I checked it, but I couldn't get it work, but I found the solution

This is the whole history

The backupset are recent (less than one month), they are on the control files views.
any way I did an I CROSSCHECK ARCHIVELOG ALL; list copy of database archivelog all;

------Trying to get by logseq I can't

RMAN> run {

2> ALLOCATE CHANNEL d1 DEVICE TYPE disk;
3> RESTORE ARCHIVELOG LOGSEQ 984;
4> }

canal asignado: d1
canal d1: sid=84 devtype=DISK

Iniciando restore en 12NOV2006
canal liberado: d1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: fallo del comando restore en 11/12/2006 13:18:45 RMAN-20242: la especificaci¾n no coincide con ning·n archive log del catßlogo de
recuperaci¾n

I found a metalink note ubject: RMAN-20242 While Trying To Restore Archive Logs
Doc ID: Note:222483.1

But trying this example this didn't work I suppose is a restriction on Oracle standar edition

RMAN> run {

2> allocate channel df1 type disk;
3> restore (archivelog from scn 423759 until scn 424709
4> like 'D:\ORACLE\ORADATA\ARCH\V901_COPY\ARCH_V901%');
5> release channel df1;
6> Subject: RMAN-20242 While Trying To Restore Archive Logs

Doc ID: Note:222483.1 }

canal asignado: df1
canal df1: sid=84 devtype=DISK

Iniciando restore en 12NOV2006
canal liberado: df1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: fallo del comando restore en 11/12/2006 14:03:35 RMAN-06141: no se puede especificar la opci¾n ARCHIVELOG LIKE con RESTORE

i tried specifying the name based on v$archived_log view

RMAN> run {

2> ALLOCATE CHANNEL d1 DEVICE TYPE disk;
3> restore archivelog like 'D:\SERPARCHLOG\ARC00970_0562943803.001';
4> }

canal asignado: d1
canal d1: sid=84 devtype=DISK

Iniciando restore en 12NOV2006
canal liberado: d1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: fallo del comando restore en 11/12/2006 13:39:46 RMAN-06141: no se puede especificar la opci¾n ARCHIVELOG LIKE con RESTORE

I Even tried a full RMAN> run { 2> ALLOCATE CHANNEL d1 DEVICE TYPE disk; 3> restore archivelog all; 4> }

canal asignado: d1
canal d1: sid=84 devtype=DISK

Iniciando restore en 12NOV2006

thread de archive log 1, secuencia 1 ya estß en disco como archivo D:\SERPFLASHB
ACK\SERP\ARCHIVELOG\2006_11_11\O1_MF_1_1_2ODH7PXS_.ARC thread de archive log 1, secuencia 2 ya estß en disco como archivo D:\SERPFLASHB
ACK\SERP\ARCHIVELOG\2006_11_11\O1_MF_1_2_2ODHL3NM_.ARC canal liberado: d1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: fallo del comando restore en 11/12/2006 14:00:17 RMAN-06026: no se han encontrado algunos destinos - abortando la restauraci¾n
RMAN-06025: no se ha encontrado ninguna copia de seguridad del thread de log 1 s
ecuencia 1044 scn inferior 120002326 para restaurar RMAN-06025: no se ha encontrado ninguna copia de seguridad del thread de log 1 s

Then finally based on note: RMAN-06026 RMAN-06025 Restore Archivelogs Seperately
Doc ID: Note:110160.1

I tried
run {
allocate channel c1 type disk;
restore archivelog from scn 118445473 until scn 118445473; release channel c1 ;
}

and IT WORKS!! :)

--

http://www.freelists.org/webpage/oracle-l Received on Sun Nov 12 2006 - 12:40:55 CST