from http://torasql.com/about
"TOra is an open-source multi-platform database management GUI that supports accessing most of the common database platforms in use, including Oracle, MySQL, and Postgres, as well as limited support for any target that can be accessed through Qt's ODBC support. TOra has been built for various Linux distributions, Mac OS X, MS Windows, and UNIX platforms.
In addition to regular query and data browsing functionality, it includes several additional tools useful for database administrators and developers – which aims to help the DBA or developer of database application. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a comprehensive set of DBA tools."
| $ export ORACLE_SID=PrimeDG
$ rman target / RMAN> sql 'alter tablespace CT_COMMON_DATA offline'; RMAN> run { set until time "to_date('FEB 28 2008 13:59:00','Mon DD YYYY HH24:MI:SS')"; recover tablespace CT_COMMON_DATA; } RMAN> sql 'alter tablespace CT_COMMON_DATA online';RMAN> exit; |