12-10-2008
Selecting line ahead and next using AWK or SED
Good Day,
I have this script that gets the archive names and the time it applies based on the alert log. The application of archives are of daily basis and usually many so having this script helps my job become easier.
My problem is that when i get all the time stamps and archive names, it also gets the creation time stamp of the datafile which shouldnt have been included.
like the logs example below:
Wed Dec 10 13:18:26 2008
Media Recovery Log /oracle/P03/oraarch/P03arch1_8600.dbf
Wed Dec 10 13:19:19 2008
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Wed Dec 10 13:19:19 2008
ALTER DATABASE RECOVER CONTINUE DEFAULT
Wed Dec 10 13:19:19 2008
Media Recovery Log /oracle/P03/oraarch/P03arch1_8601.dbf
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Wed Dec 10 13:19:30 2008
ALTER DATABASE RECOVER CONTINUE DEFAULT
Wed Dec 10 13:19:30 2008
Media Recovery Log /oracle/P03/oraarch/P03arch1_8602.dbf
Wed Dec 10 13:19:44 2008
Recovery created file /oracle/P03/sapdata7/p03_252/p03.data252
Successfully added datafile 281 to media recovery
Datafile #281: '/oracle/P03/sapdata7/p03_252/p03.data252'
Wed Dec 10 13:20:00 2008
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Wed Dec 10 13:20:01 2008
ALTER DATABASE RECOVER CONTINUE DEFAULT
Wed Dec 10 13:20:01 2008
Media Recovery Log /oracle/P03/oraarch/P03arch1_8603.dbf
Wed Dec 10 13:20:27 2008
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
Wed Dec 10 13:20:27 2008
ALTER DATABASE RECOVER CONTINUE DEFAULT
Wed Dec 10 13:20:27 2008
Media Recovery Log /oracle/P03/oraarch/P03arch1_8604.dbf
Wed Dec 10 13:20:38 2008
I just want to get the time stamp of the archive which is not fixed. what AWK or SED command do i use to get the line leading and succeeding of my archive specified.
Wed Dec 10 13:19:30 2008
Media Recovery Log /oracle/P03/oraarch/P03arch1_8602.dbf
Wed Dec 10 13:19:44 2008
Media Recovery Log /oracle/P03/oraarch/P03arch1_8603.dbf
Wed Dec 10 13:19:44 2008
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I just wanted to know if there is a way in UNIX to select a line value from a list of words. there is no line number before each word, hence could not use grep. (4 Replies)
Discussion started by: unibboy
4 Replies
2. Shell Programming and Scripting
Hello,
I have a logfile which is in this format:
1211667249500#3265
1211667266687#2875
1211667270781#1828
Is there a way to read the logfile line by line every time I execute the code and put the two numbers in the line in two separate variables?
Something like:
1211667249500#3265... (7 Replies)
Discussion started by: dejavu88
7 Replies
3. Shell Programming and Scripting
I know this has been asked before but I just can't parse the syntax as explained. I have a set of files that has user information spread out over two lines that I wish to merge into one:
User1NameLast User1NameFirst User1Address
E-Mail:User1email
User2NameLast User2NameFirst User2Address... (11 Replies)
Discussion started by: walkerwheeler
11 Replies
4. Shell Programming and Scripting
Hi all,
I have a file with special characters like this
file1
691775025 ýÄqJ8^Z^Y{ 2004-08-23E P 100.00
45585025 0527541139295037342008-07-25OEP 100.00
6983025 ýB<9D>x<^F^Xb 2004-11-16SPP 100.00
I need a sed command to print the lines which don't have special characters.ie., only line 2... (9 Replies)
Discussion started by: allinshell
9 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I would like to get the specific line from the file taking specific coloumn as reference.
Thanks and Regards (1 Reply)
Discussion started by: kkarthik_kaja
1 Replies
6. Shell Programming and Scripting
Hello,
let's start by giving you guys a few examples of the text:
"READ /TEXT123/ABC123"
"READ /TEXT123/ABC123/"
"READ TEXT123/ABC123"
"READ TEXT123/ABC123/"
"READ TEXT123/TEXT456/ABC123"
"READ /TEXT123/TEXT456/ABC123"
"READ /TEXT123/TEXT456/ABC123/"
TEXT and ABC can be and I... (5 Replies)
Discussion started by: TehOne
5 Replies
7. Shell Programming and Scripting
Hello experts,
I am new to this group and to 'SED' and 'AWK'. I have data (text file) with 5 columns (C_1-5) and 100s of lines (only 10 lines are shown below as an example). I have to find or select only the id numbers (C-1) of specific lines with '90' in the same line (of C_3) AND with '20' in... (6 Replies)
Discussion started by: kamskamu
6 Replies
8. Shell Programming and Scripting
Hi,
I have a file with following lines:
chr1 10 AC=2;AF=1.00;AN=2;DP=2;Dels=0.00;HRun=0;HaplotypeScore=0.00;MQ=23.00;MQ0=0;QD=14.33;SB=-10.01
chrX 18 AB=0.52;AC=1;AF=0.50;AN=2;DP=203;DS;Dels=0.00;HRun=0;HaplotypeScore=20.01;MQ=15.63;MQ0=85;QD=12.80;SB=-1289.58
I need to extract 4... (2 Replies)
Discussion started by: menenuh
2 Replies
9. Shell Programming and Scripting
Hi,
I am running a script sample.sh in bash environment .In the script i am using sed and awk commands which when executed individually from terminal they are getting executed normally but when i give these sed and awk commands in the script it is giving the below errors :-
./sample.sh: line... (12 Replies)
Discussion started by: satishmallidi
12 Replies
10. Shell Programming and Scripting
All, I appreciate any help you can offer here as this is well beyond my grasp of awk/sed...
I have an input file similar to:
&LOG
&LOG Part: "@DB/TC10000021855/--F"
&LOG
&LOG
&LOG Part: "@DB/TC10000021852/--F"
&LOG Cloning_Action: RETAIN
&LOG Part: "@DB/TCCP000010713/--A"
&LOG
&LOG... (5 Replies)
Discussion started by: KarmaPoliceT2
5 Replies
BF_TAR(1) BF_TAR(1)
NAME
bf_tar - shell script to write a tar file of a bogofilter directory to stdout
SYNOPSIS
bf_tar [-r] [-R] bogofilter_directory
DESCRIPTION
bf_tar bundles a bogofilter working directory in tar format and copies it to standard output (your console, or where you redirect it, see
EXAMPLES below).
OPTIONS
The -r option causes bf_tar to remove inactive log files after the archive has been written successfully. The default is to leave log
files.
The -R option causes bf_tar to remove inactive log files before the archive is written. This may reduce chances that the resulting archive
is recoverable should it become damaged. The archive may be smaller though. The default is to leave log files.
EXIT STATUS
The script exits with status code 0 if everything went well, and nonzero if it encountered trouble.
EXAMPLES
o bf_tar ~/.bogofilter > outfile.tar
Writes a standard .tar file containing the essential files from ~/.bogofilter to outfile.tar.
o bf_tar ~/.bogofilter | gzip -9 -c > outfile.tar.gz
Writes a gzipped .tar.gz file containing the essential files from ~/.bogofilter to outfile.tar.gz.
o bf_tar `pwd`/mydirectory > outfile.tar
Prepend $(pwd)/ or `pwd`/ if you want to specify an absolute path instead of a relative path.
NOTES
This script is meant for use with Berkeley DB based bogofilter versions.
This script requires a SUSv2 compliant pax utility.
This script expects a SUSv2 compliant shell. Solaris systems should have the SUNWxcu4 package installed (when bogofilter is configured) so
that /usr/xpg4/bin/sh can be used.
07/23/2007 BF_TAR(1)