The scripts below save you from having to type the same old commands in again and again to manage flashbacks. You can call this script via a CGI script from a browser, but beware that the actual flashback operation can be quite lengthy (depends on how much in the flashback logs) so your browser session may time out and you won't know if there were any problems, so I recommended doing the actual back commands from a terminal session.

The doflashback.sh script is designed for a clustered database. 

	usage: doflashback.sh [-s SID] list|set|<back|backtime>|drop <markername>
	-s SID   - allows you to set the ORACLE SID
	The full set of options are:
	set      - set a restore point and flashback marker
	back     - flashback to a marker, using srvctl
	backimm  - flashback to a marker, using DB Immediate shutdown
	backtime - flashback to a point in time, format DD/MM/YY HH24:MI
	drop     - drop a restore point (and marker)
	list     - list the flashback markers available
	listtime - list the oldest time we can flashback to

The doconservice.sh script allow restart of connector services. 

	usage: doconservice.sh [-s SID] list|[status|start|stop <or|mis>]
	-s SID   - allows you to set the ORACLE SID
	The full set of options are:
	list     - list the con services on the machine
	status   - status of the specified service
	start    - start the specified service
	stop     - stop the specified service

You will need to modify both of these scripts for your purposes as there are specific assumptions on naming standards related to the clusters that may differ in your environment.
view doflashback.sh or download doflashback.sh
view doconservice.sh or download doconservice.sh


For more on Oracle Flashback (and RMAN) look here

Home