Sponsored Content
Top Forums Shell Programming and Scripting Need help with oracle backup script Post 84017 by beilstwh on Wednesday 21st of September 2005 08:46:08 AM
Old 09-21-2005
Need help with oracle backup script

I have written a script to perfrom a cold backup on an oracle database. The script is failing everytime. Can anyone tell me what (stupid) error I am making.

The output from the uname command follows

Linux rayora 2.2.14-6.1.1smp #1 SMP Thu Apr 13 19:55:55 EDT 2000 i686 unknown


The error that I am getting on my script is:

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production

SVRMGR> Connected.
SVRMGR> Database closed.
Database dismounted.
ORACLE instance shut down.
SVRMGR> Server Manager complete.
/home/rf/bin/oracle_backup.sh: /home/rf/bin/oracle_backup.sh: line 53: syntax error: unexpected end of file



The script that I wrote follows:

Code:
#!/bin/sh
########################################################################
# Program Name - backup_full.sh                                        #
# Purpose - To perform a cold backup of the Rayora database and the    #
#            Archive Logs                                              #
#                                                                      #
# Author - xxx.xxx.xxx                                       #
# Date last Change - 09/14/2005                                        #
########################################################################

. /home/rf/common/cron_oracle_env.sh
LOG_FILE=/home/oracle/backup.log
########################################################################
# Execute the backup procedure                                         #
########################################################################
echo `date +%c` >> $LOG_FILE
echo "Database RAYORA BACKUP starting." >> $LOG_FILE
svrmgrl <<EOT
connect internal
shutdown immediate
quit
EOT
if [ $? -eq 0 ]
 then
 echo "Database RAYORA shut down." >> $LOG_FILE
 echo "Previous Backup is being removed." >> $LOG_FILE
 touch /home/oracle/backup/junk
 rm /home/oracle/backup/*
 echo "Cold backup being performed." >> $LOG_FILE
 cp -p -f -v /home/oracle/oraInventory/oradata/rayora/*  /home/oracle/backup/
 echo "Cold backup of archive logs being performed." >> $LOG_FILE
 mv -f -v /home/oracle/oraInventory/oradata/arch/*       /home/oracle/backup/
 echo "Restarting Database RAYORA." >> $LOG_FILE
 svrmgrl <<EOT
 connect internal
 startup
 quit
 EOT
 if [ $? -eq 0 ]
 then
   echo "Database RAYORA started up." >> $LOG_FILE
 else
   echo "Database RAYORA will NOT start up." >> $LOG_FILE
 fi
 echo "Moving the backup files to the NFS share." >> $LOG_FILE
 cp -p -f -v /home/oracle/backup/* /usr/local/backup/oracle_back/
 echo "Remove Archive Logs older then seven (7) days" >> $LOG_FILE
 find /usr/local/backup/oracle_back/ -type f -name "*arc" -mtime 6 -exec rm {}\;
else
 echo "Database RAYORA failed to shut down." >> $LOG_FILE
fi
echo `date +%c` >> $LOG_FILE
echo "Database RAYORA BACKUP has completed." >> $LOG_FILE

 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Shell script on Oracle hot backup got an error

Hi Unix Shell Script Expert, We have a robust shell script (from old time) for our 9i database hot backup but generated error: Shell Script Content: #check for auto log mode and redirect as early as possible # autolog_enable $AUTOLOG_MODE $ORACLE_BASE/${ORASID_LOW}log/cron_hotbackup.log... (1 Reply)
Discussion started by: oradbus
1 Replies

2. Shell Programming and Scripting

Oracle hot backup script issue

Hi, I have a script which we use to take hot backup of oracle database.It connects to database and saves all database related activities in a spool file.Then the spool file is run for taking hot backup. But at one stage it is giving an error. Please find my hot backup script as below: ... (2 Replies)
Discussion started by: dwiravi
2 Replies

3. Shell Programming and Scripting

Help with sed in Oracle DB backup script.

I have a script like this .. #!/bin/ksh database=$(echo $@ | sed 's/.*-S \(*\).*/\1/') instance=$(grep "$database" /var/opt/oracle/oratab | awk -F : '{print $1}') command=$(echo $@ | sed 's/"$database"/"$instance"/') echo $command when I tried to execute the script like this ... ksh... (5 Replies)
Discussion started by: talashil
5 Replies

4. HP-UX

Can we restore omni oracle db backup

We have omni backup of oracle database about 40Gb, tablespaces are distributed over 2 partitions . But because of some reason both partition are not available more . Now we are in need to restore the entire data on new partitions .Can any guru's confirm if tried so earlier will this going to... (1 Reply)
Discussion started by: Shirishlnx
1 Replies

5. Shell Programming and Scripting

Cold backup oracle and Restore to new db

Hello All, I am very new to Linux i have assignment to take offline backup in linux and restore it to new database oracle 10g? Help me out any script of it and steps i will be very thankful Regards, Sameer (0 Replies)
Discussion started by: sameer_123
0 Replies

6. Shell Programming and Scripting

Oracle Data BackUp with Help Of Perl

Hi All I am able to connect my oracle database with Perl and able to execute the queries. There is one schema names master19 which contains 50 table. I want to take backup of each table in and store at a given directory location in Perl For example suppose if a table student is present in... (1 Reply)
Discussion started by: parthmittal2007
1 Replies

7. Shell Programming and Scripting

Oracle Data BackUp with Help Of Perl

Hi All I am able to connect my oracle database with Perl and able to execute the queries. There is one schema names master19 which contains 50 table. I want to take backup of each table in and store at a given directory location in Perl For example suppose if a table student is present in... (3 Replies)
Discussion started by: parthmittal2007
3 Replies

8. Shell Programming and Scripting

Cold Backup of Oracle database.

Hi i need a command to cut the last column from the location in a file and want write a gzip command like cat a.txt /data01/oracle/oradata/vas/data/system01.dbf /data01/oracle/oradata/vas/data/sysaux01.dbf /data01/oracle/oradata/vas/data/undotbs01.dbf... (3 Replies)
Discussion started by: javeedkaleem
3 Replies

9. UNIX for Dummies Questions & Answers

I need perl script on cold backup in Oracle 10 g

Hi , I am new to Perl script.Can u please provide me perl scripts for the following: 1. Perl script on Cold backup in Oracle 10g 2.Perl script on Hot backup in Oracle 10g (0 Replies)
Discussion started by: Niharika Srivas
0 Replies

10. Shell Programming and Scripting

Shell script to call Oracle archive backup script when file system reaches threshold value

Hello All, I need immediate help in creating shell script to call archivebkup.ksh script when archive file system capacity reaches threshold value or 60% Need to identify the unique file system that reaches threshold value. ex: capacity ... (4 Replies)
Discussion started by: sasikanthdba
4 Replies
BAK2DB(8)						      System Manager's Manual							 BAK2DB(8)

NAME
bak2db - Directory Server script for restoring a backup SYNOPSIS
bak2db archivedir [-Z serverID] [-n backendname] [-q] | [-h] DESCRIPTION
Restores the database from a archived backup. The Directory Server must be stopped prior to running this script. OPTIONS
A summary of options is included below: archivedir The directory of the archived database. -Z Server Identifier The server ID of the Directory Server instance. If there is only one instance on the system, this option can be skipped. -n Backend Name The name of the LDBM database to restore. Example: userRoot -q Quiet mode. Reduces output of task. -h Display the usage. EXAMPLE
bak2db /LDAP/backups/20130305/ -Z instance1 -n userRoot bak2db /LDAP/backups/20130305/ -n example DIAGNOSTICS
Exit status is zero if no errors occur. Errors result in a non-zero exit status and a diagnostic message being written to standard error. AUTHOR
bak2db was written by the 389 Project. REPORTING BUGS
Report bugs to http://bugzilla.redhat.com. COPYRIGHT
Copyright (C) 2013 Red Hat, Inc. Mar 5, 2013 BAK2DB(8)
All times are GMT -4. The time now is 02:01 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy