This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,575 Users
  • 2,269,776 Discussions
  • 7,916,824 Comments

Discussions

Lift the restriction that RMAN duplicate must include tablespace with materialized views

User51642 Yong Huang
User51642 Yong Huang Houston, TXMember Posts: 183 Bronze Badge
edited May 10, 2018 11:27AM in Database Ideas - Ideas

According to

DUPLICATE SKIP TABLESPACE failes RMAN-05586 RMAN-05587 RMAN-05588 RMAN-05589 (Doc ID 1287276.1)

You MUST NOT exclude
- SYS-owned objects
- or tablespaces with rollback segments,
- nor tablespaces containing "MATERIALIZED VIEWS"!

or documentation (up to 18c) about RMAN "duplicate" command "skip tablespace" clause

https://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#r17c1-t79

https://docs.oracle.com/en/database/oracle/oracle-database/18/rcmrf/DUPLICATE.html#d43611e2528

You must not exclude SYS-owned objects or tablespaces with rollback segments, nor tablespaces containing materialized views

Lifting this restriction will significantly shorten the time in duplicating a database when you're only interested in a small set of data completely unrelated to the others that may include materialized views.

The reason for this restriction is not clear. For those interested, there's some speculation at

https://jonathanlewis.wordpress.com/2014/03/10/duplicate-database/

See the paragraph beginning with "One oddity about the whole MV thing".

Franck NAbbrevUser51642 Yong Huang
3 votes

Active · Last Updated