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
anthony@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