Restoring the backed up archived logs only.
|Article:TECH176245|||||Created: 2011-12-05|||||Updated: 2014-09-16|||||Article URL http://www.symantec.com/docs/TECH176245|
How to restore the backed up Oracle archive logs only.
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.
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.
ALLOCATE CHANNEL ch0 TYPE 'SBT_TAPE';
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