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.