Hey everyone,
I'm new to Oracle Database (19c, 21c) and I'm wondering if there's a way to easily backup and restore data at a schema or PDB level, similar to how one would create a checkpoint or snapshot in a virtual machine environment.
For example, before running some experiments that will modify tables, stored procedures, and data within a specific schema, I'd like to create a restore point or backup. This way, I can easily revert everything back to its original state after my tests are done. In other databases, I've used point-in-time recovery or similar features, but I'm not sure what the equivalent is in Oracle DB.
Is there a best practice or built-in functionality in Oracle for handling this type of scenario?
Thanks in advance for any guidance!