Oracle – How to Reset Schema

oracle

I'm running systemtest that updates a oracle schema. I need to reset the whole scheme between runs.

Is there an easy way to do this in oracle 12. I have looked at flashback but it doesn't seem to be the right way to go.

Best Answer

perhaps you looked at flashback queries, what you need are restore points.

Create a guaranteed restore point before starting test
Perform test, measure, save results
startup mount the db, flashback database to restore point
drop and re-create guaranteed restore point.
lather. rinse. repeat

It really doesn't get easier than that. I do it multiple times a week and have essentially reduced it to a small script and keep doing this against my dev db.

Related Solutions

Oracle server connection reset by peer socket write error

The windows error 54 is associated with a port busy or problems with the network communication, try editing the listener.ora file and change the port, then restart the listener service (or if you're able to restart the machine, do so).

It looks like that, for some reason, the port 1521 hungs and there's no longer a TNS Listener service listening there.

P.D. if you didn't configured a TNS_ADMIN folder, the listener.ora file must be in the %ORACLE_HOME%\network\admin folder, where the %ORACLE_HOME% is where the product was installed

The Windows error reference is in: http://msdn.microsoft.com/en-us/library/windows/desktop/ms681382(v=vs.85).aspx

Trouble setting up Nagios to monitor Oracle services

You should be able to use the newer EZConnect format: host:port/service:connection_type saving you the hassle of adding a TNS entry.

The connection_type and port are both optional and will default to dedicated and 1521 respectively.

Changing the connect parameter of your monitoring command as follows should do the trick:

--connect "oracle-server:1551/OFFDB1"

Best Answer

Related Solutions

Oracle server connection reset by peer socket write error

Trouble setting up Nagios to monitor Oracle services

Related Question