Forcing a Restore of Archived Logs on an Oracle ASM Database

By default, you cannot restore backed up archive logs that still reside on Oracle ASM to a different location (for example, your local disk). However, you can use the RMAN FORCE option to force the restore of the archive logs that are currently on the ASM database.

Before You Begin

1. If you run the RMAN script on a UNIX configuration, use PARMS in the allocate channel command when the SBT library has not been re-linked.

2. Use a unique backup piece format to avoid conflicting backup piece names.

Procedure

Create an RMAN script with commands similar to the following script:

 
run { 
    set archive log destination to '<restore_location_path'>; 
    restore archive log from logseq=xxxx until logseq=xxxy
    FORCE; 
} 
exit;

Example

The following is an example script.

run {
 set archive log destination to '/tmp/restore';
 restore archive log from logseq=1533 until logseq=1537 FORCE;
 }
 exit;