Oracle NT Backup - The .BAT script will perform an NT Backup of an Oracle Database Instance. Contributed by Rauf Sarwar

Auto Analyze - This .BAT script will execute the AUTOANALYZE SQL Script. This script performs a re-analyze of any tables with aged statistics or any tables for which no statistics have been generated.

Check Tablespace - This script will check for tablespaces which are used beyond given percent limit.

Cold Backup - This script performs cold backup of the database on Windows NT.

Copy Archive Logs - This script will copy archived redo logs to a secondary standby destination for an NT database.

Create Snapshot - Create snapshot of existing database with only 5 required parameters. Contributed by Rauf Sarwar.

Extent Threshold - This script will check for segments which are a designated number of extents from the maximum number of extents allocated.

Flush Shared Pool - This script will pin all objects executed more than 1000 time or utilizing more than 15k of sharable memory for an NT implementation.

Full Export - This script will perform a full export of an NT database.

Hot Backup - This script performs hot backup of the database on Windows NT.

Next Extent Check - This script is to check space availability for next extent allocations.

Rename Listener Log - This script will facilitate periodic rename of the Listener Log for an NT implementation.

Standby Log Application - This script will apply archive logs to an NT Standby database.

This script will take HotBackup for any DB, just specify SID as first parameter, 2nd parameter backup directory and 3rd Logfile

Script to check the sync between the primary and the standby databases using the log sequence numbers and if there is a difference of log sequence then the script will send a email and page to the on call dba

This script will backup all archive logs

This script will perform datafile recovery

RMAN: Full online backup

This script can be saved and used as a command file to perform Cold backup using rman

This script will perform Tablespace recovery

NEXT

BACK TO SCRIPTS INDEX