Somberi Techblog
 
Read this Disclaimer first
Techblog Home
All Entries
About Techblog
This weblog is licensed under
a Creative Commons License
Hosted by Somberi.com
Powered by Movable Type
Tech Blog

DBA

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.

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

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.