Installgen
Features and Benefits
Installgen
Demo Available for download...
Bookmark This Page
#! /usr/local/bin/perl
# script: prod3_export_full_db_1.pl (renamed from 35_win_prod3_export_full_db_1.pl)
# Features: This perl script performs a full database export to the c:\backup location.
# Note: This script only needs scheduled if the same task has not
# been scheduled via an OEM job.
#
# Output File: c:\backup\prod3_export_full_db_1.log
#
# Script Sequence#: 35
# Used By: run automatically via AT scheduler
# Usage:
# ******** Full Oracle Database Export nightly at 11:50PM ********
# AT 23:50 /every:M,T,W,Th,F,S,Su c:\server_scripts\prod3_export_full_db_1.pl
# Copyright 2002 by .com Solutions Inc.
#
# ---------------------- Revision History ---------------
# Date By Changes
# 12-22-2001 dsimpson Initial Release
# 12-27-2001 dsimpson Added ORACLE_SID environment variable
# 01-01-2002 dsimpson Added NLS_LANG environment variable
# to avoid EXP-0009 errors during export.
#
# This output file was created by Installgen version 1.38 on Thu Nov 14 17:16:25 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
use strict;
# insure that environment variables are used by this perl script
$ENV{'ORACLE_SID'} = "PROD3";
$ENV{'NLS_LANG'} = "AMERICAN_AMERICA.AL32UTF8";
my @proglist='';
# log into the database and perform a full database export to the c:\backup directory
@proglist = ("c:\\v901\\bin\\exp.exe USERID='admin/adminpwd' FILE=c:\\backup\\prod3_full_daily.dmp COMPRESS=Y DIRECT=Y ROWS=Y CONSISTENT=Y FULL=Y LOG=c:\\backup\\prod3_export_full_db_1.log");
system (@proglist);
