RMAN DUPLICATE SKIP READ ONLY DOES NOT SKIP READ ONLY TABLESPACES (Doc ID 1582612.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

 Rman 'duplicate skip read only' does not skip read only tablespace and overwrites the datafile from the target Database when target and Auxiliary instance are running on the same host.

Duplicating the Database using for example:
   run {
    set until scn 32771956;
    allocate auxiliary channel c1 device type sbt;
    duplicate target database to aux skip readonly;
    release channel c1;
   }
The duplicate will succeed but when stopping/starting the Target database, it will fail with for example:
  Database mounted.
  ORA-01113: file 6 needs media recovery
  ORA-01110: data file 6: '+DATA/s112/datafile/emsdat_arc.549.801050289'

Changes

Rman restores the datafile of the read only tablespace into the original location while ignoring the skip read only option.


This happens when the read only tablespace has been put 'read write' and back to 'read only' between the time of the backup and the duplicate.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms