Help with sed in Oracle DB backup script.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help with sed in Oracle DB backup script.
# 1  
Old 02-22-2010
Help with sed in Oracle DB backup script.

I have a script like this ..

Code:
#!/bin/ksh
database=$(echo $@ | sed 's/.*-S \([a-zA-Z0-9]*\).*/\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 ...

Code:
ksh -x rman_wrap.sh rman_backup.pl -S IRMD51 -io 
+ echo /opt/dba/oraadmin/temp/rman_backup.pl -S IRMD51 -io
+ sed 's/.*-S \([a-zA-Z0-9]*\).*/\1/'
+ database=IRMD51
+ grep IRMD51 /var/opt/oracle/oratab
+ awk -F : '{print $1}'
+ instance=IRMD511
+ echo /opt/dba/oraadmin/temp/rman_backup.pl -S IRMD51 -io
+ sed 's/"$database"/"$instance"/'
+ command='/opt/dba/oraadmin/temp/rman_backup.pl -S IRMD51 -io'
+ echo /opt/dba/oraadmin/temp/rman_backup.pl -S IRMD51 -io
/opt/dba/oraadmin/temp/rman_backup.pl -S IRMD51 -io


it's failing on sed command . syntax is correct . Can anyone suggest what's wrong ?

Thanks

Last edited by pludi; 02-22-2010 at 03:59 PM.. Reason: code tags, please...
# 2  
Old 02-22-2010
Code:
sed 's/'"$database"'/'"$instance"'/'

# 3  
Old 02-22-2010
Modify the line as :

Code:
command=$(echo $@ | sed  "s/$database/$instance/")

# 4  
Old 02-22-2010
I am executing this script ( via AUTOSYS) from another host . And it's still giving me this error ....

sed: -e expression #1, char 8: unknown option to `s'
# 5  
Old 02-22-2010
Well it really depends on what's in those variables you're feeding into sed there.
# 6  
Old 02-22-2010
Perhaps this may be of use, some awk to change the first occurence of string s with replacement text r in a way that isn't susceptible to regular expression metacharacters nor string escape sequences:

Code:
awk -v s="$database" -v r="$instance" 'i=index($0,s){$0=substr($0,1,i-1) r substr($0,i+length(s))}1'

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. Shell Programming and Scripting

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... (8 Replies)
Discussion started by: beilstwh
8 Replies
Login or Register to Ask a Question