Video : Multitenant : PDB Snapshot Carousel in Oracle Database 18c Onward

In today’s video we take a look at the PDB Snapshot Carousel feature, introduced in Oracle 18c.

I also have a Multitenant YouTube playlist.

There’s a lot more information about this feature and other multitenant functionality in these articles.

The star of today’s video is Nassyam Basha. 🙂

Cheers

Tim…

Author: Tim...

DBA, Developer, Author, Trainer.

2 thoughts on “Video : Multitenant : PDB Snapshot Carousel in Oracle Database 18c Onward”

  1. SQL> show pdbs

    CON_ID CON_NAME OPEN MODE RESTRICTED
    ———- —————————— ———- ———-
    3 PDB1 READ WRITE NO

    SQL> ALTER PLUGGABLE DATABASE SNAPSHOT cdb1_pdb1_b4WLOAD;
    ALTER PLUGGABLE DATABASE SNAPSHOT cdb1_pdb1_b4WLOAD
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-65081: database or pluggable database is not open in read only mode

  2. Hi.

    My guess would be you are not in archivelog mode, so it can’t guarantee a consistent snapshot, so it’s asking you to be in read-only mode. Try again in archivelog mode.

    Cheers

    Tim…

Comments are closed.