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…
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
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…