Seek UNIX script tutor and help Post: 302193172

Sponsored Content

Top Forums UNIX for Advanced & Expert Users Seek UNIX script tutor and help Post 302193172 by duke0001 on Thursday 8th of May 2008 06:03:51 PM

05-08-2008

Registered User

Seek UNIX script tutor and help

I am new to UNIX shell script programming. I have coded one korn shell script used on solaris 10 for Oracle database rman cold backup. The first part of script is working. But only following part is not working. Please help me to point out the problem and errors in my code. Thanks a lot.

# the first part has been omitted.

# Started to shutdown database and startup database mount for cold backup .

${ORACLE_HOME}/bin/sqlplus -s << EOF
conn / as sysdba
shutdown immediate;

${ORACLE_HOME}/bin/sqlplus -s << EOF
conn / as sysdba
startup mount;

# The above part works, then script stop here.

exit

rman NOCATALOG <<EOF
CONNECT TARGET SYS/$SYS_PASSWORD@$ORACLE_SID
if [ $? = 0 -o $? = 2 ]
then date +"%D %T: backup process started." >> pdedev$BACKUP_DAY.LOG
else date +"%D %T: Error start rman to do backup." >> pdedev$BACKUP_DAY.LOG
exit 1
fi
RUN
{
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK
FORMAT = '$BACKUP_FOLDER/%d_DB_%u_%s_%p' MAXPIECESIZE 5G;
BACKUP DATABASE PLUS ARCHIVELOG DELETE ALL INPUT;
RELEASE CHANNEL ch1;

SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
}
if [$? = 0]
then date +"%D %T: Rman backup successful." >> $BACKUP_DAY.LOG
echo "" >> $BACKUP_DAY.LOG
else date +"%D %T: Rman backup not successful." >> $BACKUP_DAY.LOG
date +"%D %T: Exiting script." >> $BACKUP_DAY.LOG
exit 1
fi

# Open database

${ORACLE_HOME}/bin/sqlplus -s << EOF
conn / as sysdba
alter database open;
echo " database $ORACLE_SID is up running." >> $BACKUP_DAY.LOG

exit
EOF

Last edited by duke0001; 05-09-2008 at 01:28 PM..

duke0001

View Public Profile for duke0001

Find all posts by duke0001

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Why script For...Loop doesn't work. Seek help

I have written a script to run on UNIX server. When I tested, it always hanged on after "date +"%D %T: XXXXXX script started." part. Then it wouldn't go further. UNIX server gave me one error message. I used the same code in another script. It works fine. I think the major problem may be in...

2. Solaris

Solaris 10 Tutor

I am looking to enter into the IT field and i'm very interestd in the Solaris 10 OS. Apart from shelling out outrageous sums to companies based here in the UK, I would appreciate any other advise on how to go about studying, understanding and certifiying in Solaris 10. I have tried to install...

3. AIX

server seek internet

hello i'm working with aix 5.3 hacmp 5.4 P550 and P520 those two serevr every 10 seconds seek connection to the internet web. i check with sniffer software and i've got this details. the problem is that when i've problem with the internet those server get frizzzzzzz. on those servers running...

4. UNIX for Advanced & Expert Users

dd seek problem

I want to seek to a location on the hard drive that will be written to that is different from the output block size. Is this possible? It seems the man page implies you can only seek in increments of the number of bytes you output. A bit of information about what I'm trying to do, if that...

5. UNIX for Dummies Questions & Answers

Seek help configuring Sendmail 8.14.4 Unix

Seek help configuring Sendmail 8.14.4 Unix server. Not sure if this is the correct place to post or the Unix/Linux Forums job board. Seeking help configuring sendmail 8.14.4 on my Unix server. It appears I have an open relay. I was advised I need to modify a etc/mail/dir , a command line entry...

6. Emergency UNIX and Linux Support

Seek help on shell script syntax errors

I want to delete archivelog files that has been archived and applied from primary database to standby database. This piece of script is working in Linux server. However, I copy it to Unix server with tiny modification. It won't work and generate the error message. I have checked code carefullt...

7. Shell Programming and Scripting

Tutor or help needed (online)

Hi, i like to know if any of the forum member happens to know any good tutor who is willing to provided on-line help to my scripting skills? jared

LEARN ABOUT OSF1

script

script(1)						      General Commands Manual							 script(1)

NAME

       script - Makes a transcript of terminal session

SYNOPSIS

       script [-a] [file]

       The script command makes a transcript of everything printed on your terminal.

OPTIONS

       Appends the transcript to file rather than writing it to file.

OPERANDS

       The name of an output file that will contain the transcript of the session.  If this parameter is omitted, the file typescript is written.

DESCRIPTION

       The transcript is written to file, or appended to file if the -a option is given.  If no file name is given, the transcript is saved in the
       file typescript.

       The script ends when the forked shell exits.

       This program is useful when you are using a CRT and want a hard-copy record of the dialog (for example, a technical writer might create	an
       example of a working session this way).

       If you specify the -a option and the file does not exist, it is created.

       If you do not specify the -a option and the file exists, it is replaced.

RESTRICTIONS

       The  script command requires a streams based terminal.  In single user mode, streams may not be enabled.  Under these circumstances, script
       will exit with no action.  If you are the superuser and need to run this command in single user mode, use the  following  special  instruc-
       tions.

   Enabling Streams
       If it is necessary to enable a streams environment in the single user mode, enter the command /sbin/init.d/streams.  This command is avail-
       able to the superuser only.

SEE ALSO

       Commands:  autopush(8), cat(1), echo(1), strsetup(8), tee(1)

       System Administration

																	 script(1)