Multitenant : Hot Clone a Pluggable Database (PDB) in Oracle Database 12.2 Onward

Поделиться
HTML-код
  • Опубликовано: 23 янв 2025

Комментарии • 12

  • @gonzalofernandez4524
    @gonzalofernandez4524 5 лет назад +1

    Awesome feature. Thanks a lot Tim for always sharing your knowledge without reservations

  • @salvatoresalgari9751
    @salvatoresalgari9751 2 года назад

    hi its possible to monitoring the status of the cloning process, or after the copy is completed che for the recovery of the archive? or can only just wait for the end of all process?

    • @oracle-base
      @oracle-base  2 года назад

      Not really. There is some indication of the process in the alert log, but not a progress indicator in a view, or anything like that.

  • @FrabettiRenan
    @FrabettiRenan Год назад

    Hello, thanks for the videos!
    Could you please answer me a question?
    If I have 2 servers differents (A and B) , and I would like to transfer a PDB1 (Server A) to server B.
    What kind of migration is better performance?
    1- Using RMAN (duplicate)
    2- CREATE PLUGGABLE DATABASE PDB1_copy FROM PDB1@clone_link;

    • @oracle-base
      @oracle-base  Год назад +1

      They will be similar. Effectively a hot clone takes a backup and transports it. I typically do this using a PDB clone, as it is logically simipler.

  • @sribalaje
    @sribalaje 4 года назад

    Hello Your videos are greatttt... I have a query .. Is this Hot clone same as we do DUPLICATE DATABASE TO FROM ACTIVE DATABASE ON 11G?

    • @oracle-base
      @oracle-base  4 года назад

      Hi. It's a different mechanism, so it's not quite the same, but in terms of the outcome it feels similar. Both allow you to clone a running system. The RMAN mechanism does the whole instance. This method just does a pluggable database.

    • @sribalaje
      @sribalaje 4 года назад

      Thanks.. Using DUPLICATE DATABASE command, can we duplicate only Pluggable database not the CDB??

    • @oracle-base
      @oracle-base  4 года назад +1

      You have to do the CDB, but you can limit the PDBs.
      oracle-base.com/articles/12c/recovery-manager-rman-database-duplication-enhancements-12cr1#multitenant-considerations
      PDB clones are done using SQL or DBCA.

    • @sribalaje
      @sribalaje 4 года назад

      Yes I saw your article..Suppose I have Prod in CDB1 & Uat,dev, test pdb in CDB2... In this case, if i need to clone prod data to uat, then i have to use Hot clone only right?? Duplicate database will create an entire CDB which I already have(CDB2 For non prod)

    • @oracle-base
      @oracle-base  4 года назад +1

      Yes. Hot clones are how you deal with those.