Forum Stats

  • 3,824,946 Users
  • 2,260,442 Discussions
  • 7,896,356 Comments

Discussions

PITR PDB Duplicate to existing CDB

Julian Frey-Edorex
Julian Frey-Edorex Member Posts: 4 Blue Ribbon
edited May 13, 2020 4:30AM in Database Ideas - Ideas

Hi

Currently it is not possible to duplicate a PDB to a specific point in time. It is only possible to duplicate the whole CDB.

For many testing activities it would be great to duplicate a PDB to a specific point in time to an existing CDB.

My ideas:

- SQL: Extend the "create pluggable database <PDB NAME> from"  command with an until clause

- RMAN: Extend the "duplicate pluggable database"  to use the until clause

Regards

Julian

Julian Frey-EdorexramseyUser_DGG74Franck PachotThomas Teske-OracleDirk.NachbargaurddbaUser_9MQOPG DionUser_CJGDBSven W.Denis AxlersawDaniel Haller StrahmludodbaRichard SouleberxPeter Amstutzsdstuber
19 votes

Active · Last Updated

Comments

  • Franck Pachot
    Franck Pachot Member Posts: 912 Bronze Trophy

    Hi Julian, yes this will be needed if we want the same agility at PDB level as we have with duplicate database. Another alternative would be to be able to flashback a PDB after clone before opening it (by shipping the flashback logs in the same way redo log is shipped to refresh it).

    Julian Frey-EdorexThomas Teske-Oracle
  • Julian Frey-Edorex
    Julian Frey-Edorex Member Posts: 4 Blue Ribbon

    Hi Julian, yes this will be needed if we want the same agility at PDB level as we have with duplicate database. Another alternative would be to be able to flashback a PDB after clone before opening it (by shipping the flashback logs in the same way redo log is shipped to refresh it).

    Hi Franck

    Currently the only way for duplicating a PDB to an existing CDB to a specific timestamp is with a "staging" CDB which needs space and additional steps. In many cases the flashback logs can be sufficient you are right.

    Thomas Teske-Oracle