1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Recover Archive from Oracle Database backup

Discussion in 'Server Administration and Options' started by Bhavesh Maisuriya, Apr 19, 2013.

  1. Introduction

    How to restore archive from Oracle Rman Backups

    [applmgrr@apps10 bin]$ ./rman target /

    Recovery Manager: Release - Production on Sun Jan 6 14:40:36 2013

    Copyright (c) 1982, 2007, Oracle. All rights reserved.

    connected to target database: ATULORC (DBID=3510764300)

    RMAN> run {
    2> allocate channel t1 device type disk;
    3> restore archivelog logseq 60943;
    4> release channel t1;
    5> }

    using target database control file instead of recovery catalog
    allocated channel: t1
    channel t1: SID=3087 device type=DISK

    Starting restore at 06-JAN-13

    channel t1: starting archived log restore to default destination
    channel t1: restoring archived log
    archived log thread=1 sequence=60943
    channel t1: reading from backup piece /mnt47/dbbkp/bk_33922_1_803971121
    channel t1: piece handle=/mnt47/dbbkp/bk_33922_1_803971121 tag=TAG20130106T041930
    channel t1: restored backup piece 1
    channel t1: restore complete, elapsed time: 00:18:25
    Finished restore at 06-JAN-13

    released channel: t1

    RMAN> exit