cx_OracleDBATools 2.0

[Anthony Tuininga]

What is it?

cx_OracleDBATools is a set of Python scripts that handle Oracle DBA
tasks in a cross platform manner. These scripts are intended to work the
same way on all platforms and hide the complexities involved in managing
Oracle databases, especially on Windows. Binaries are provided for those
who do not have a Python installation.

Where do I get it?

http://starship.python.net/crew/atuining
http://www.computronix.com/utilities.shtml
utronix.com
(it may be a few days before the second site is updated)

What's new?

1) Added tool ExortControlFile to create a file containing the
statements necessary for recreating a control file. This file is
similar to the one created by the statement "alter database backup
controlfile to trace" but it allows you to specify the file name and
it also modifies the statements output such that recreating the
controlfile is possible without any changes.
2) Added tool CloneDB to clone a database. This tool copies all of the
files associated with the database and then creates a new control
file and starts the cloned database.
3) Added tool BackupDB to perform a cold backup on a database.
4) Added tool RestoreDB to restore a database from a backup performed
by the tool BackupDB. This tool can also be used to restore a
database with a different SID and different paths so that a backup
file can be restored on a different machine so long as the platform
and Oracle version remain constant.
5) Added tool RemoveDB to remove a database completely from the
machine.
6) Added option --all to StartDB and StopDB to start or stop all
databases on the machine.
7) Added option --all-auto to StartDB to start all databases marked as
automatic start (similar to the Oracle script dbstart on Unix).
8) Added ability to StartDB and StopDB to start or stop multiple
databases at once.
9) Added option --shutdown-mode to StopDB to allow for issuing a
shutdown abort, for example.
10) Added option --config-file-name on all tools to allow overriding the
configuration file name and also give an indication of where the
default configuration file is located.

--
Anthony Tuininga
ant...@computronix.com

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada T5N 4A3
Phone: (780) 454-3700
Fax: (780) 454-3838
http://www.computronix.com