Today we had to parse one SQL error log file in UNIX box and I saw a kind diff file format -
#grep "Database mirroring is inactive" ERRORLOG.1
And i saw no output. :-(
I thought its dos2unix which can help me. BUT not!!
#file ERRORLOG.4
ERRORLOG.4: Little-endian UTF-16 Unicode English character data, with very long lines, with CRLF line terminators
grep command couldn’t parse the UTF-16 Unicode file. Hence, the file had to be converted to the format which ‘grep’ can parse.
#iconv -f UTF-16 -t UTF-8 ERRORLOG.1 | grep "Database mirroring is inactive"
And cheers! I am done.
-DK
Subscribe to:
Post Comments (Atom)
🔭 First Impression: Exploring Grafana Mimir ... After Years with Thanos! Not an observability( OE ) purist, but I do appreci...

-
RTO = Recovery Time Objective tells how quickly you will able to resume the normal operations back by connecting users to the data. ...
-
Effective Time-management and Time-boxing is a concern for 'always ready people'. Being from a background that I am from, I am...
-
Why I started blogging... Well, this is the ultimate question I get asked when I tell people I started a blog! I have taken a lot of time to...
No comments:
Post a Comment