About Ram - Ramakrishna Nemani works at Coca-Cola Enterprises Inc., as a Senior database administrator.

An Introduction to Teradata components - This explains Teradata RDBMS components

Export to UNIX pipe and Compress - This script exports to a UNIX pipe which is then fed to gzip to create a compressed export dump file.

Import through UNIX pipe - This script imports through an UNIX pipe.

Normalization process explained - This article explains the process of normalization using an example.

Output log of restore_controlfile_from_tape.ksh - Output log of restore_controlfile_from_tape.ksh

Output log of restore_datafile.ksh - This is the output log of restore_datafile.ksh.

Output log of restore_datafile_new.ksh - Output log of restore_datafile_new.ksh. read this along with restore_datafile_new.ksh script

Output log of restore_spfile.ksh - Output log of restore_spfile.ksh, see restore_spfile.ksh to make sense of this log

Output log of restore_spfile_from_tape.ksh - Output log of restore_spfile_from_tape.ksh, See restore_spfile_from_tape.ksh

Output log of rman_arch_bkup.ksh - This shows the output log of rman_arch_bkup.ksh

Output log of rman_bkup.ksh - This shows the output log of rman_bkup.ksh

Output log of rman_config.ksh - This shows the output log of rman_config.ksh

Output log of rman_dr.ksh - This is the output log of rman_dr.ksh

Output log of rman_tape_bkup.ksh - This shows the output log of rman_tape_bkup.ksh

Outputlog of restore_controlfile.ksh - This shows the screen output that gets produced when restore_controlfile.ksh is run

RMAN Disaster Recovery script (rman_dr.ksh) - This script is intended to provide a mechanism for disaster recovery.

RMAN archive logs backup script - This script does archive logs backup using rman.

RMAN complete database backup script - This script does a full database backup including the archive logs.

RMAN configuration script - This script configures persistent rman settings.

RMAN tape backup script - This script does a backup of backupset to tape.

Restore datafile from disk (restore_datafile.ksh) - This script restores datafile from disk to the original location.

SQL Tutorial for the beginners - This tutorial is aimed at giving the beginners a brief introduction to the Structured Query Language or SQL

Sample .profile file - A sample .profile file

Sample Listener.ora - This is a sample listener.ora file

Sample sqlnet.ora file - This is a sample sqlnet.ora file

Sample tnsnames.ora - This is a sample tnsnames.ora file

Teradata Dignostics commands - These commands help DBAs in troubleshooting query performance issues

Writing Efficient SQL Code for Oracle - Part 1 - This article aims to provide you with information and tips that will help you write efficient SQL code for Oracle databases.Part 1 of this article deals with writing Efficient SQL Code for the Batch environment.

Writing Efficient SQL Code for Oracle - Part 2 - Part 2 of this article deals with writing Efficient SQL Code for the OLTP environment.

restore_controlfile.ksh - If you have lost all copies of the controlfile then use this script to restore the controlfile from rman disk backup

restore_controlfile_from_tape.ksh - If you have lost all copies of your controlfile then use this script to restore controlfile from your rman tape backup

restore_datafile_new.ksh - This script is for restoring datafile to a new location/name and recovering it.

restore_spfile.ksh - This script is for restoring the spfile from disk to default location

restore_spfile_from_tape.ksh - This script is for restoring the spfile from tape to default location.