Restoring the backed up archived logs only.

book

Article ID: 100007515

calendar_today

Updated On:

Resolution

Connect to the RMAN on the oracle server using the following command

rman target sys/password@instance_name

Run the following RMAN sample script to restore the required archive logs:

RUN {
ALLOCATE CHANNEL ch0 TYPE 'SBT_TAPE';
SEND 'BSA_SERVICE_HOST=SRV1,NBBSA_DB_DEVICE_NAME=Oracle-Win::\\dbserver\ORCL';
restore archivelog scn between  12485276299 and 12486652454;
RELEASE CHANNEL ch0;
}

In this script SRV1 is the name of the media server, dbserver is the name of the Oracle server and ORCL is the name of the Oracle instance.This script is applicable to Oracle running on Windows server.  If Oracle is installed on Linux server, then Oracle-Win should be replaced with Oracle-Linux.  This script restores the archived logs between the SCN number 12485276299 and 12486652454.  The send parameters can be obtained from the RMAN script from the backup job log in Backup Exec.

 

Applies To

In some cases the Oracle DBA needs to restore only the archived logs backed up with Backup Exec.  Using the Backup Exec console, it is not possible to restore only the archive logs.  This task can be performed with RMAN on the oracle server.

Issue/Introduction

How to restore the backed up Oracle archive logs only.