Help on parsing Oracle RMAN output for string and print sections of a file
Hi,
I need some advise on how to print 'sections' of the attached file. I am searching for some that says Marked Corrupt and print some lines after it.
At the moment I am running the command below:
Code:
sed -n -e '/Marked Corrupt/{N;N;p;}' rman_list_validate.txt
This gives me the following example output:
Code:
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
572 OK 0 699 88960 8317955790709
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
582 OK 0 11871 107520 8317956333446
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
623 OK 3 1504 1792 8317956324498
Now I want to print out a 'full' section of where the Marked Corrupt is greater than 0. How do I do that?
So in the attached file, I want to be able to see the following example lines and excluding those where Marked Corrupt is 0.
Code:
... found some above here ...
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
586 OK 5 2490 3328 8311568110013
File Name: /db/devq1/data/devq1_fin_cuaudit_a_01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 838
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
623 OK 3 1504 1792 8317956324498
File Name: /db/devq1/data/devq1_fin_tdapp_a_01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 13
Index 0 7
Other 0 268
... and so on
Hello All,
I am using Linux OS. My idea is get the host name when we do tnsping in oracle.
output of : tnsping DOELO01
TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 15-OCT-2015 20:20:05
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files:... (2 Replies)
Hi guys, i need a small help. I was writing an automation script for import utility of oracle datapump. I am getting stuck in one part of the shell script where i am doing a grep on one of the filesystem and if it is above threshold then it would kick off an oracle RMAN backup. Fyi. i am grepping... (3 Replies)
Hi,
tnsping is an Oracle tool that is sort of like a ping command. Unfortunately it does not come with a tool that can be used to parse its output which is very frustrating.
Example output of tnsping are as below:
$: tnsping testp1
TNS Ping Utility for Solaris: Version 11.2.0.2.0 -... (3 Replies)
Hi,
I have multiple files that each contain one column of strings:
File1:
123abc
456def
789ghi
File2:
123abc
456def
891jkl
File3:
234mno
123abc
456def
In total I have 25 of these type of file. (5 Replies)
Hi All,
I have around 900 Select Sql's which I would like to run in an awk script and print the output of those sql's in an txt file.
Can you anyone pls let me know how do I do it and execute the awk script? Thanks. (4 Replies)
I'm a sysadmin trying to help out one of our DBA's setup the RMAN backups (Oracle 11g on rhel5 ) so they can schedule and control them from the OEM grid control. But we want the oracle user to use ssh keys instead of a password. I have the working rsa keys in place for the user but the GUI seems to... (0 Replies)
Hey guys,
I have this file generated by me... i want to create some HTML output from it.
The problem is that i am really confused about how do I go about reading the file.
The file is in the following format:
TID1 Name1 ATime=xx AResult=yyy AExpected=yyy BTime=xx BResult=yyy... (8 Replies)
Here is a data file, which I believe is in YAML. I am trying to retrieve just the 'addon_domains" section, which doesnt seem to be as easy as I had originally thought. Any help on this would be greatly appreciated!! I have been trying to do this in awk and mostly bash scripting instead of perl... (3 Replies)