Oracle y yo

RMAN> catalog backuppiece '/respaldo/oracle/backupset_32181818_1.bkp';

cataloged backuppiece
backup piece handle=/respaldo/oracle/backupset_32181818_1.bkp recid=12469 stamp=707174130

RMAN>

Y procedemos a restaurar

RMAN> restore archivelog logseq=39753;

Starting restore at 01-JAN-10
using channel ORA_DISK_1
using channel ORA_SBT_TAPE_1

channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=39753
channel ORA_DISK_1: reading from backup piece /respaldo/oracle/backupset_32181818_1.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/respaldo/oracle/backupset_32181818_1.bkp tag=TAG20091210T025643
channel ORA_DISK_1: restore complete, elapsed time: 00:02:35
Finished restore at 01-JAN-10

RMAN>

Pero figura como channel ORA_DISK_1: starting archive log restore to default destination

¿Qué significa eso? , pues sencillamente que restaura a una posición por defecto que para nuestro caso es la FRA que se encuentra en ASM

¿Cómo averiguamos donde quedo?, pues ejecutando la misma restauración

RMAN> restore archivelog logseq=39753;

Starting restore at 01-JAN-10
using channel ORA_DISK_1
using channel ORA_SBT_TAPE_1

archive log thread 1 sequence 39753 is already on disk as file +DATA/instance1/archivelog/2010_01_01/thread_1_seq_39753.687.707174297
restore not done; all files readonly, offline, or already restored
Finished restore at 01-JAN-10

Ahora nos vemos enfrentados al hecho de sacar el archivelog desde la FRA, eso se hace mediante los siguientes comandos

RMAN> copy archivelog '+DATA/instance1/archivelog/2010_01_01/thread_1_seq_39753.687.707174297' to '/respaldo/oracle/logminer/archive_39753.arc';

Starting backup at 01-JAN-10
released channel: ORA_SBT_TAPE_1
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive copy
input archive log thread=1 sequence=39753 recid=157342 stamp=707174445
output filename=/respaldo/oracle/logminer/archive_39753.arc recid=157343 stamp=707176036
channel ORA_DISK_1: archivelog copy complete, elapsed time: 00:00:09
Finished backup at 01-JAN-10

RMAN>

Después de eso, simplemente borramos el archivelog que dejamos en la FRA

RMAN> delete archivelog '+DATA/instance1/archivelog/2010_01_01/thread_1_seq_39753.687.707174297';

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=521 instance=instance1 devtype=DISK

List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
157342 1 39753 A 09-DEC-09 +DATA/instance1/archivelog/2010_01_01/thread_1_seq_39753.687.707174297

Do you really want to delete the above objects (enter YES or NO)? YES
deleted archive log
archive log filename=+DATA/instance1/archivelog/2010_01_01/thread_1_seq_39753.687.707174297 recid=157342 stamp=707174445
Deleted 1 objects

RMAN>

Después de eso, podemos aplicar logminer sobre los archivelogs que se encuentran en sistema operativo

Como resumen , lo más interesante es el uso del comando COPY en RMAN, con lo cual podemos sacar los archivelogs desde la FRA en ASM hacía disco.