9.7.5.1 Drop the Snapshot Databases

Delete the Exadata snapshot databases that are children of the test master database you want to refresh.

You can delete the snapshot databases using RMAN.

1. Connect to the Exadata snapshot database using RMAN with the Exadata snapshot as the target.

   Connect as a user that has the necessary privileges to start and drop a database, such as SYSBACKUP or SYSDBA.

   RMAN> CONNECT TARGET "user@snapdb_name AS SYSDBA"

2. Start the snapshot database in restricted mode.

   RMAN> STARTUP FORCE MOUNT DBA

3. Delete the snapshot database.

   RMAN> DROP DATABASE;

   Note:

   • Failure to drop an Exadata snapshot database has no impact on the state of a test master database. However, an Exadata snapshot can behave unpredictably if its test master database is dropped or refreshed.
   • If you have a snapshot hierarchy, you must delete all of the snapshots at all levels of the snapshot hierarchy that are children of the test master database you want to refresh.