[HPADM] How to extract lines from a file using sed without using line numbers.

From: Latone, Philip (PLatone@miracosta.edu)
Date: Wed Dec 17 2003 - 21:04:07 EST

Next message: Paul.Soltermann@vonroll-isola.com: "[HPADM] SUMMARY: problems printing umlaute äöü"
Previous message: Timothy A Reed: "[HPADM] password expiration different between 10.20 and 11.0"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Hello Admins,

I need to extract lines from a file. I can't count lines. I don't know how many there will be, and the number could change. I need to extract only the portion in red. The first line will be always be STARTUP NOMOUNT and the last line will be always be # End of tempfile additions. The first and last lines just described are not unique as they show up again in the bottom half of the file.

begin file.............
Dump file /home/oracle/admin/EP88DMO/udump/ep88dmo_ora_11039.trc

Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production

With the Partitioning option

JServer Release 9.2.0.1.0 - Production

ORACLE_HOME = /home/oracle/product/9.2.0

System name: HP-UX

Node name: iceman

Release: B.11.11

Version: U

Machine: 9000/800

Instance name: EP88DMO

Redo thread mounted by this instance: 1

Oracle process number: 9

Unix process pid: 11039, image: oracle@iceman (TNS V1-V3)

*** SESSION ID:(8.12070) 2003-12-17 15:03:56.528

*** 2003-12-17 15:03:56.528

# The following are current System-scope REDO Log Archival related

# parameters and can be included in the database initialization file.

# LOG_ARCHIVE_DEST=''

# LOG_ARCHIVE_DUPLEX_DEST=''

# LOG_ARCHIVE_FORMAT=%t_%s.dbf

# REMOTE_ARCHIVE_ENABLE=TRUE

# LOG_ARCHIVE_MAX_PROCESSES=2

# STANDBY_FILE_MANAGEMENT=MANUAL

# STANDBY_ARCHIVE_DEST=?/dbs/arch

# FAL_CLIENT=''

# FAL_SERVER=''

# LOG_ARCHIVE_DEST_1='LOCATION=/home/oracle/product/9.2.0/dbs/arch'

# LOG_ARCHIVE_DEST_1='MANDATORY NOREOPEN NODELAY'

# LOG_ARCHIVE_DEST_1='ARCH NOAFFIRM SYNC'

# LOG_ARCHIVE_DEST_1='NOREGISTER NOALTERNATE NODEPENDENCY'

# LOG_ARCHIVE_DEST_1='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED'

# LOG_ARCHIVE_DEST_STATE_1=ENABLE

# Below are two sets of SQL statements, each of which creates a new

# control file and uses it to open the database. The first set opens

# the database with the NORESETLOGS option and should be used only if

# the current versions of all online logs are available. The second

# set opens the database with the RESETLOGS option and should be used

# if online logs are unavailable.

# The appropriate set of statements can be copied from the trace into

# a script file, edited as necessary, and executed when there is a

# need to re-create the control file.

# Set #1. NORESETLOGS case

# The following commands will create a new control file and use it

# to open the database.

# Data used by the recovery manager will be lost. Additional logs may

# be required for media recovery of offline data files. Use this

# only if the current version of all online logs are available.

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "EP88DMO" NORESETLOGS NOARCHIVELOG

-- SET STANDBY TO MAXIMIZE PERFORMANCE

MAXLOGFILES 8

MAXLOGMEMBERS 4

MAXDATAFILES 256

MAXINSTANCES 1

MAXLOGHISTORY 453

LOGFILE

GROUP 1 (

'/u01/oradata/EP88DMO/log1a.dbf',

'/u02/oradata/EP88DMO/log1b.dbf'

) SIZE 20M

-- STANDBY LOGFILE

DATAFILE

'/u04/oradata/EP88DMO/system01.dbf',

'/u08/oradata/EP88DMO/wawork.dbf'

CHARACTER SET WE8ISO8859P15

;

# Recovery is required if any of the datafiles are restored backups,

# or if the last shutdown was not normal or immediate.

RECOVER DATABASE

# Database can now be opened normally.

ALTER DATABASE OPEN;

# Commands to add tempfiles to temporary tablespaces.

# Online tempfiles have complete space information.

# Other tempfiles may require adjustment.

ALTER TABLESPACE PSTEMP ADD TEMPFILE '/u05/oradata/EP88DMO/pstemp01.dbf'

SIZE 524288000 REUSE AUTOEXTEND OFF;

# End of tempfile additions.

# Set #2. RESETLOGS case