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
BBSTOREACCOUNTS(8)						    Box Backup							BBSTOREACCOUNTS(8)

NAME
bbstoreaccounts - Box Backup store accounts manager SYNOPSIS
bbstoreaccounts [-c config-file] command account-id [command-specific arguments] DESCRIPTION
bbstoreaccounts is the tool for managing accounts on the store server. It can be used to view information related to accounts, as well as create, change and delete accounts on the store server. bbstoreaccounts always takes at least 2 parameters: the command name and the account ID. Some commands require additional parameters, and some commands have optional parameters. Options -c config-file The configfile to use for connecting to the store. Default is /etc/box/bbstored.conf. Commands The commands tells bbstoreaccounts what action to perform. check account-id [fix] The check command verifies the integrity of the store account given, and optionally fixes any corruptions. Note: It is recommended to run the 'simple' check command (without fix) before using the fix option. This gives an overview of the extent of any problems, before attempting to fix them. create account-id disc-set soft-limit hard-limit Creates a new store account with the parameters given. The parameters are as follows: account-id The ID of the new account to be created. A 32-bit hexadecimal number. Cannot already exist on the server. disc-set The disc set from raidfile.conf(5) where the backups for this client will be stored. A number. Each RAID-file set has a number in raidfile.conf. This number is what's used. soft-limit The soft limit is the amount of storage that the server will guarantee to be available for storage. hard-limit The amount of storage that the the server will allow, before rejecting uploads, and starting to eliminate old and deleted files to get back down to soft-limit. delete account-id [yes] Deletes the account from the store server completely. Removes all backups and deletes all references to the account in the config files. delete will ask for confirmation from the user, when called. Using the yes flag, eliminates that need. This is useful when deleting accounts from within a script or some other automated means. 0 info account-id Display information about the given account. Example: [root]# bbstoreaccounts info 1 Account ID: 00000001 Last object ID: 58757 Blocks used: 9864063 (38531.50Mb) Blocks used by old files: 62058 (242.41Mb) Blocks used by deleted files: 34025 (132.91Mb) Blocks used by directories: 6679 (26.09Mb) Block soft limit: 11796480 (46080.00Mb) Block hard limit: 13107200 (51200.00Mb) Client store marker: 1139559852000000 Explanation: Account ID The account ID being displayed. Last Object ID A counter that keeps track of the objects that have been backed up. This number refers to the last file that was written to the store. The ID is displayed as a decimal number, and the object ID can be converted to a path name to a file as follows: convert the number to hex (e.g.: 58757 => 0xE585); The last backed up file will be (relative from the client's store root): e5/o85.rfw. Longer numbers infer more directories in the structure, so as an example 3952697264 as the last object ID gives 0xEB995FB0, which translates to a backup pathname of eb/99/5f/ob0.rfw. Blocks used The number of blocks used by the store. The size in Mb depends on the number of blocks, as well as the block size for the disc set given in raidfile.conf(5). In this case the block size is 4096. Blocks used by old files The number of blocks occupied by files that have newer versions in the store. This data is at risk for being removed during housekeeping. Blocks used by deleted files The number of blocks used by files that have been deleted on the client. This data is at risk for being removed during housekeeping. Blocks used by directories The number of blocks used by directories in the store. Block soft limit The soft limit in blocks. The soft limit is the maximum guaranteed storage space available to the account. When housekeeping starts, and the old and deleted files are removed, they are removed in chronological order (oldest first), until the data used is less than the soft limit. Block hard limit The hard limit in blocks. The hard limit is the most amount of storage the server will allow in an account. Any data above this amount will be rejected. Housekeeping will reduce the storage use, so more data can be uploaded. Client store marker bbstored(8) uses this number to determine if it needs to rescan the entire store. If this number is different from the last time it checked, a rescan will take place. setlimit account-id soft-limit hard-limit Changes the storage space allocation for the given account. No server restart is needed. Parameters: account-id The ID of the account to be modified. soft-limit The soft limit is the amount of storage that the server will guarantee to be available for storage. hard-limit The amount of storage that the the server will allow before rejecting uploads and starting to eliminate old and deleted files to get back down to soft-limit. EXAMPLES
Create an account with ID 3af on disc set 0, with a 20GB soft-limit and a 22GB hard-limit: bbstoreaccounts create 3af 0 20G 22G Alter existing account ID 20 to have a 50GB soft-limit and a 55GB hard-limit: bbstoreaccounts setlimit 20 50G 55G FILES
/etc/box/bbstored/accounts.txt SEE ALSO
bbstored(8), bbstored-config(8) AUTHORS
Ben Summers Per Thomsen James O'Gorman Box Backup 0.11 10/28/2011 BBSTOREACCOUNTS(8)
All times are GMT -4. The time now is 10:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy