Undo tablespace recovery in case of no backups.

This method to recover Undo tablespace is not a substitute for recovery procedures
through backups as mentioned in the official Oracle documentation.

But if you get stuck in a situation where you don’t have any backups and need to
recover your Undo tablespace , then use this method as a last resort.

Read more >>

Drop a Target Database Using RMAN in Oracle 10g.

Beginning with Oracle 10g Release 1 onwards, A database can be dropped
by executing few simple statements.

With this method all datafiles, controlfiles, Redo log files, Spfile, Archived
Redo log files, backups will be dropped along with the target database.

Read more >>

Oracle 10g Clone database using Rman.

Clone Database on the same machine (locally). 

1) First make sure your database is in archivelog mode.
2) Make a fresh backup of your database using Rman.
3) The SID of the database which I have is “orcl”.
   The cloned database name will be “dup”.
4) Add the following lines to listener.ora file.

Read more >>

How to set AUTOTRACE in Oracle 10g.

[root@localhost ~]# su - oracle
[oracle@localhost ~]$ export ORACLE_SID=orcl
[oracle@localhost ~]$ sqlplus

username:system
password:password

Read more >>

Using logminer to undo incorrectly committed changes in Oracle 10g.

In order to work with logminer, the Oracle database should be in archive log mode.
Skip the steps mentioned below if your database is already in archive log mode.

SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Read more >>

How to write protect your USB flash drive.

Here is a really cool trick to write protect your usb flash drive.

For this trick to work you must know exactly how much space is available in your usb flash drive in bytes.

Read more >>

Hiren's BootCD 11.1

Hiren's BootCD is a completely free bootable cd containing lots of tools which are capable of data recovery, partitioning, system analysis, benchmarking etc.
You can use these tools even if your primary OS has got corrupted, because all the tools boot directly from the cd.

Read more >>