I can’t imagine that this would be useful in a well managed system, but if you find yourself with a “raw” log file that is not in the dictionary, you can at least extract the SCN range it encompasses using what is below.<\/p>\n
\r\n[oracle@dell11gr1 ~]$ awk --version\r\nGNU Awk 3.1.5\r\nCopyright (C) 1989, 1991-2005 Free Software Foundation.\r\n\r\nThis program is free software; you can redistribute it and\/or modify\r\nit under the terms of the GNU General Public License as published by\r\nthe Free Software Foundation; either version 2 of the License, or\r\n(at your option) any later version.\r\n\r\nThis program is distributed in the hope that it will be useful,\r\nbut WITHOUT ANY WARRANTY; without even the implied warranty of\r\nMERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the\r\nGNU General Public License for more details.\r\n\r\nYou should have received a copy of the GNU General Public License\r\nalong with this program; if not, write to the Free Software\r\nFoundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.\r\n[oracle@dell11gr1 ~]$ strings -a arch1.arc | head -20 | grep SCN | awk -F \",\" '{split($3,t,\" \");split(t[2],t2,\"-\");printf(\"Start SCN = %d, End SCN = %d\\n\",strtonum(t2[1]),strtonum(t2[2]))}'\r\nStart SCN = 5345720, End SCN = 5350856\r\n[oracle@dell11gr1 ~]$ \r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"I can’t imagine that this would be useful in a well managed system, but if you find yourself with a “raw” log file that is not in the dictionary, you can at least extract the SCN range it encompasses using…<\/p>\n