Quickly revert an Oracle Database to a known state
Posted
by
Anthony
on Server Fault
See other posts from Server Fault
or by Anthony
Published on 2011-02-17T01:22:15Z
Indexed on
2011/02/17
7:27 UTC
Read the original article
Hit count: 563
oracle11g
|database-restore
I would like to use Selenium to test a web application but in order to do that successfully the tests must be run against a database at a known state.
The recording and running of the Selenium tests is not within the scope of this website so I'm only looking for recommendations on how best to revert the database after each test execution.
Some details:
- current database size is 30GB however only about 4GB needs to be reverted
- database is Oracle 11g Standard Edition running on Windows Server 2003
- the data in 6 different schemas needs to be reverted
Ideally the process should be scripted so that it can be re-executed frequently and automatically via a scheduled task.
© Server Fault or respective owner