Restoring the backed up archived logs only.

Article:TECH176245  |  Created: 2011-12-05  |  Updated: 2014-01-05  |  Article URL http://www.symantec.com/docs/TECH176245
Article Type
Technical Solution

Product(s)

Issue



How to restore the backed up Oracle archive logs only.


Environment



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


Solution



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 in 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 for oracle running on windows server.If the 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.




Article URL http://www.symantec.com/docs/TECH176245


Terms of use for this information are found in Legal Notices