Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Help on parsing Oracle RMAN output for string and print sections of a file Post 302966518 by newbie_01 on Saturday 13th of February 2016 02:33:31 AM
Old 02-13-2016
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

Any advice much appreciated. Thanks.
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Parsing file, yaml file? Extracting specific sections

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)
Discussion started by: Rhije
3 Replies

2. Shell Programming and Scripting

Parsing of file for Report Generation (String parsing and splitting)

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)
Discussion started by: umar.shaikh
8 Replies

3. UNIX and Linux Applications

Running RMAN backups from grid control but using oracle account with rsa keys vs a password ?

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)
Discussion started by: samael00
0 Replies

4. Shell Programming and Scripting

Awk script to run a sql and print the output to an output file

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)
Discussion started by: adept
4 Replies

5. Shell Programming and Scripting

Compare columns of multiple files and print those unique string from File1 in an output file.

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)
Discussion started by: owwow14
5 Replies

6. Shell Programming and Scripting

Help/advice parsing Oracle tnsping output

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)
Discussion started by: newbie_01
3 Replies

7. Shell Programming and Scripting

Usage of disc group to kick off Oracle RMAN backup

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)
Discussion started by: sub
3 Replies

8. UNIX for Dummies Questions & Answers

How to get/print host string only from tnsping output?

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)
Discussion started by: Ariean
2 Replies
AMDD(8) 						      System Manager's Manual							   AMDD(8)

NAME
amdd - Amanda version of dd SYNOPSIS
amdd [ -d ] [ if=input ] [ of=output ] [ bs=blocksize ] [ skip=count ] [ count=count ] DESCRIPTION
Amdd provides just enough of the standard dd command for the needs of Amanda. This is handy when doing a full restore and the standard dd program has not yet been found. Amdd also provides access to the Amanda output drivers that support various tape simulations. This may be used for debugging or to convert from one format to another. See the amanda(8) man page for more details about Amanda. See the OUTPUT DRIVERS section of amanda(8) for more information on the Amanda output drivers. OPTIONS
-d Turn on debugging output. -llength Set the output length. If the output driver limits the output size, this controls when end of tape will be simulated. Length may have a multiplier suffix: k 1024 (Kilobytes) b 512 (Blocks) M 1024*1024 (Megabytes) The default is no multipler (bytes). if=input Input to dd. Default is stdin. of=output Where to send the output of dd. Default is stdout. bs=blocksize Size of each record. Input records smaller than this will not be padded. Output records will be the same size as the corresponding input record. Default is 512 bytes. Blocksize may have a multiplier suffix: k 1024 (Kilobytes) b 512 (Blocks) M 1024*1024 (Megabytes) The default is no multipler (bytes). count=count Number of records to copy. Default is all records until end of file. skip=count Number of records to skip before copying input to output. Default is zero. AUTHOR
Marc Mengel <mengel@fnal.gov> John R. Jackson <jrj@purdue.edu> SEE ALSO
amanda(8) AMDD(8)
All times are GMT -4. The time now is 10:29 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy