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.