Restoring the backed up archived logs only.
| Article:TECH176245 | | | Created: 2011-12-06 | | | Updated: 2013-02-21 | | | Article URL http://www.symantec.com/docs/TECH176245 |
Problem
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
Thank you.