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: 561

Filed under:

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

Related posts about oracle11g

???? Oracle11g ????????? No.2 - v$database.CURRENT_SCN

as seen on Oracle Blogs - Search for 'Oracle Blogs'
«????Oracle 11g ???????»???????????,?11.2.0.3.0?????: select current_scn from v$database union all select current_scn from v$database; ??????????SCN,??????11.2.0.1.0???????????SCN?????? ??,????11.2.0.1.0????,11.2.0.3.0????X$KCCDI(V$DATABASE?????,??CURRENT_SCN??)??,?????????SCN? … >>> More
Cognos 8.3 and Oracle11g

as seen on Server Fault - Search for 'Server Fault'
When i place ojdbc5.jar in the c8\webapps\p2pd\WEB-INF\lib directory... i receive the error below. And yes the content store is on an oracle 11g RAC database. I am running Oracle11g Client. Cognos version is 8.3 SP4. [Content Manager database connection] 1. [ ERROR ] The database connection failed… >>> More
Cognos 8.3 and Oracle11g

as seen on Server Fault - Search for 'Server Fault'
When i place ojdbc5.jar in the c8\webapps\p2pd\WEB-INF\lib directory... i receive the error below. And yes the content store is on an oracle 11g RAC database. I am running Oracle11g Client. Cognos version is 8.3 SP4. [Content Manager database connection] 1. [ ERROR ] The database connection failed… >>> More
how to display databases in oracle11g using sqlplus

as seen on Stack Overflow - Search for 'Stack Overflow'
in mysql its show databases; but how to show the available databases in oracle. can someone help >>> More
INS-40719 error when Install Oracle RAC?

as seen on Server Fault - Search for 'Server Fault'
I'm tying to (learn how to) install Oracle RAC 11g on CentOS 6 all went OK so far but I get INS-40719 Error message regarding SCAN Name I do not have DNS server and I'm not going to try to use it on this setup I add this line to /etc/hosts 192.168.244.100 rac-cluster then used "rac-cluster" as… >>> More

Related posts about database-restore

Database operations through SQL: Database Restore ...

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
If using sql to perform a database restoring , care the sql-codes very well. Any trivial mistake may prevent a successful execution. Cases are listed here based on simple experiments. with operation: MOVE 'logical_file_name_in_backup' TO 'operating_system_file_name' If logical file name… >>> More
SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot

as seen on SQL Authority - Search for 'SQL Authority'
Snapshot database is one of the most interesting concepts that I have used at some places recently. Here is a quick definition of the subject from Book On Line: A Database Snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source database and… >>> More
Undo Database Restore in SQL Server 2008

as seen on Server Fault - Search for 'Server Fault'
I accidentally restored a SQL Server 2008 database with a wrong backup. Is there any way to undo this and restore to previous version? -Vivek >>> More
Restore SQL Server 2008 db without affecting users

as seen on Server Fault - Search for 'Server Fault'
When I restore a db in Sql Server 2008 R2 from data on another server, it makes a mess of the users. I have a Windows User and MsSql Login named Web_SqlA on both machines. Before the Restore, Web_SqlA is properly mapped to the right Windows user in the database. After the Restore, Web_SqlA is still… >>> More
Undo Database Restore in SQL Server 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
I accidentally restored a SQL Server 2008 database with a wrong backup. Is there any way to undo this and restore to previous version? >>> More