9.7.5 Refreshing the (Read-only) Test Master Database
To refresh a read-only test master database, it must be converted temporarily to a read-write test master.
To refresh the (read-only) test master database, the main steps are:
- Drop the Snapshot Databases
Delete the Exadata snapshot databases that are children of the test master database you want to refresh. - Change the Permissions on the Test Master to Read-Write
To modify the data files from read-only to read-write you can use SQL to generate a script of SQL commands. - Convert the Test Master Database Back to a Data Guard Replica
Now that the data files for the test master are writable, convert the read-only test master database into an Oracle Data Guard replica. - Update the Test Master Database
- Close the Test Master and Make All Test Master Data Files Read-Only
After the Test Master has been updated, you can revert it to a read-only test master. - Re-create All Snapshots
After the Test Master has been updated and made read-only again, re-create all the snapshot databases to get the latest updates.
Parent topic: Managing Exadata Snapshots