Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Tuesday, March 30, 2010

Restore Archivelog with Particular sequence

RMAN> run {
2> allocate channel dsk1 type disk;
3> restore archivelog logseq 11645;
4> release channel dsk1;
5> }

what if it is a RAC?
What if particular logseq and thread?

RMAN> run {
2> allocate channel ch01 type disk format '/ora_backup/u0006/FIPRD3/archivelog/';
3> restore archivelog logseq 24208 thread 3;
4> }

using target database control file instead of recovery catalog
allocated channel: ch01
channel ch01: sid=639 instance=FIPRD3 devtype=DISK

Starting restore at 19-APR-11

channel ch01: starting archive log restore to default destination
channel ch01: restoring archive log
archive log thread=3 sequence=24208
channel ch01: reading from backup piece /ora_backup/u0006/FIPRD3/archivelog/ARC_FIPRD3_20110417_115101_s298206_p1_6uma0fad
channel ch01: restored backup piece 1
piece handle=/ora_backup/u0006/FIPRD3/archivelog/ARC_FIPRD3_20110417_115101_s298206_p1_6uma0fad tag=TAG20110417T115252
channel ch01: restore complete, elapsed time: 00:00:05
Finished restore at 19-APR-11
released channel: ch01



restoring to a different archivelog destination than default and with particular thread log sequence:

RMAN> run{
2> set archivelog destination to '/ora_backup/u0001/cloning/';
3> restore archivelog sequence 6232 thread 3;
4> }

executing command: SET ARCHIVELOG DESTINATION
using target database control file instead of recovery catalog

Starting restore at 26-JUN-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2610 instance=ICMPRD3 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=948 instance=ICMPRD3 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=2365 instance=ICMPRD3 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=3315 instance=ICMPRD3 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=1188 instance=ICMPRD3 device type=DISK

channel ORA_DISK_1: starting archived log restore to user-specified destination
archived log destination=/ora_backup/u0001/cloning/
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=6232
channel ORA_DISK_1: reading from backup piece /ora_backup/u0004/ICMPRD3/archivelog/ARC_ICMPRD3_20110624_130406_s7190_p1_0mmfmh90
channel ORA_DISK_1: piece handle=/ora_backup/u0004/ICMPRD3/archivelog/ARC_ICMPRD3_20110624_130406_s7190_p1_0mmfmh90 tag=TAG20110624T130521
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 26-JUN-11

No comments: