Twitter @gcolbran
Bikers Against E-Tolls SA
Monthly Archives: June 2008
RMAN: List backups completed since a defined time period
If you are tasked with restoring a database, you will need to know when the last backup was complete. Here’s how.
Posted in Recovery Manager
Comments Off
Check for a replicated transaction.
In a replicated environment, you will sometimes want to know if a transaction is from the local or a remote database. Here’s a procedure which will return the information, allowing you to use or discard the transaction based on the … Continue reading
Find all datafiles minimum size possible.
Posted in Configuration., Oracle
Comments Off
Execute OS commands in oracle 9i and below.
There are a number of ways to execute os commands, in 10g we use a script and dbms_scheduler to perform this. In 9i and below, we have to go through the java route to get there.
Posted in Oracle
Comments Off
Rebuild indexes to another tablespace.
I needed to rebuild the indexes from a tablespace to another, to allow me to clear the tablespace out and drop it. Here’s a script which performs this.
Posted in Oracle, Tuning in General
Comments Off
Using OPatch
OPatch is the tool of choice when patching the database, it’s the simplest way to get the job done. Here’s an overview of the OPatch utility and its usage.
Posted in Oracle
Comments Off
