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

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

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2019

**********************************************************************************


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]


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

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: