Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grep gived 0652-226 Maximum line length 2048 error

Status
Not open for further replies.
MCubitt

MCubitt

Programmer
Mar 14, 2002
1,081
0
0
GB
Is this a restriction I can change (ie is 2048 set somewhere)?

This is the script which has the grep:
Code: 
# Take input control file, 
# remove ALL lines upto (but not incl) 2nd STARTUP NO MOUNT,
#/bin/ksh
rm -f $2
startup_count=0
while read line 
do 
   wrk1=`echo $line | grep ^STARTUP | cut -d" " -f1` 
   if [ "$wrk1" = "STARTUP" ]
   then 
      let startup_count=startup_count+1
   fi

   if [ "$startup_count" -gt 1 ]
   then
     echo "$line" >> $2
   else
     continue
   fi
done < $1

exit 0

I am sure it never used to happen, perhaps the input file has increaed a lot.

The input fille:
Code: 
Dump file /oracle/app/oracle/admin/IFSD/udump/ifsd_ora_69852.trc
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /oracle/app/oracle/product/9.2.0.1.0
System name:	AIX
Node name:	IFSSERVER
Release:	1
Version:	5
Machine:	006D87BC4C22
Instance name: IFSD
Redo thread mounted by this instance: 1
Oracle process number: 14
Unix process pid: 69852, image: oracle@IFSSERVER (TNS V1-V3)

*** SESSION ID:(16.2922) 2005-03-21 09:03:07.575
*** 2005-03-21 09:03:07.575
# 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=/oracle/app/oracle/product/9.2.0.1.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 "IFSD" NORESETLOGS  NOARCHIVELOG
--  SET STANDBY TO MAXIMIZE PERFORMANCE
    MAXLOGFILES 5
    MAXLOGMEMBERS 5
    MAXDATAFILES 254
    MAXINSTANCES 1
    MAXLOGHISTORY 1134
LOGFILE
  GROUP 1 (
    '/redolog1/IFSD/redo01.log',
    '/redolog2/IFSD/redo01a.log'
  ) SIZE 50M,
  GROUP 2 (
    '/redolog1/IFSD/redo02.log',
    '/redolog2/IFSD/redo02a.log'
  ) SIZE 50M,
  GROUP 3 (
    '/redolog1/IFSD/redo03.log',
    '/redolog2/IFSD/redo03a.log'
  ) SIZE 50M,
  GROUP 4 (
    '/redolog1/IFSD/redo04.log',
    '/redolog2/IFSD/redo04a.log'
  ) SIZE 50M,
  GROUP 5 (
    '/redolog1/IFSD/redo05.log',
    '/redolog2/IFSD/redo05a.log'
  ) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
  '/redolog1/IFSD/system01.dbf',
  '/redolog2/IFSD/undotbs01.dbf',
  '/oracleindex/IFSD/users01.dbf',
  '/oracledata/IFSD/ifsapp_data01.dbf',
  '/oracleindex/IFSD/ifsapp_index01.dbf',
  '/oracledata/IFSD/ifsapp_report_data01.dbf',
  '/oracleindex/IFSD/ifsapp_report_index01.dbf',
  '/oracledata/IFSD/ifsapp_archive_data01.dbf',
  '/oracleindex/IFSD/ifsapp_archive_index01.dbf',
  '/oracledata/IFSD/ifsapp_data02.dbf',
  '/oracleindex/IFSD/ifsapp_index02.dbf',
  '/oracledata/IFSD/ifsapp_data03.dbf',
  '/oracleindex/IFSD/ifsapp_index03.dbf',
  '/oracledata/IFSD/oem_repository01.dbf',
  '/oracledata/IFSD/ifsapp_data04.dbf',
  '/oracleindex/IFSD/ifsapp_index04.dbf',
  '/oracledata/IFSD/ifsapp_data05.dbf',
  '/oracleindex/IFSD/ifsapp_index05.dbf',
  '/oracledata/IFSD/ifsapp_data06.dbf',
  '/oracledata/IFSD/ifsapp_data07.dbf',
  '/oracledata/IFSD/ifsapp_data08.dbf',
  '/oracledata/IFSD/ifsapp_data09.dbf',
  '/oracledata/IFSD/ifsapp_data10.dbf',
  '/oracledata/IFSD/ifsapp_data11.dbf',
  '/oracleindex/IFSD/ifsapp_index06.dbf',
  '/oracledata/IFSD/sp_data01.dbf',
  '/oracledata/IFSD/ifsapp_data12.dbf',
  '/oracleindex/IFSD/ifsapp_index07.dbf',
  '/oracledata/IFSD/ifsapp_data13.dbf',
  '/oracleindex/IFSD/ifsapp_index08.dbf',
  '/oracledata/IFSD/ifsapp_data14.dbf',
  '/oracledata/IFSD/ifsapp_data15.dbf',
  '/oracledata/IFSD/QUEST.dbf'
CHARACTER SET WE8MSWIN1252
;
# 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 TEMP ADD TEMPFILE '/oracledata/IFSD/temp01.dbf'
     SIZE 524288000  REUSE AUTOEXTEND OFF;
# End of tempfile additions.
#
#     Set #2. RESETLOGS case
#
# The following commands will create a new control file and use it
# to open the database.
# The contents of online logs will be lost and all backups will
# be invalidated. Use this only if online logs are damaged.
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "IFSD" RESETLOGS  NOARCHIVELOG
--  SET STANDBY TO MAXIMIZE PERFORMANCE
    MAXLOGFILES 5
    MAXLOGMEMBERS 5
    MAXDATAFILES 254
    MAXINSTANCES 1
    MAXLOGHISTORY 1134
LOGFILE
  GROUP 1 (
    '/redolog1/IFSD/redo01.log',
    '/redolog2/IFSD/redo01a.log'
  ) SIZE 50M,
  GROUP 2 (
    '/redolog1/IFSD/redo02.log',
    '/redolog2/IFSD/redo02a.log'
  ) SIZE 50M,
  GROUP 3 (
    '/redolog1/IFSD/redo03.log',
    '/redolog2/IFSD/redo03a.log'
  ) SIZE 50M,
  GROUP 4 (
    '/redolog1/IFSD/redo04.log',
    '/redolog2/IFSD/redo04a.log'
  ) SIZE 50M,
  GROUP 5 (
    '/redolog1/IFSD/redo05.log',
    '/redolog2/IFSD/redo05a.log'
  ) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
  '/redolog1/IFSD/system01.dbf',
  '/redolog2/IFSD/undotbs01.dbf',
  '/oracleindex/IFSD/users01.dbf',
  '/oracledata/IFSD/ifsapp_data01.dbf',
  '/oracleindex/IFSD/ifsapp_index01.dbf',
  '/oracledata/IFSD/ifsapp_report_data01.dbf',
  '/oracleindex/IFSD/ifsapp_report_index01.dbf',
  '/oracledata/IFSD/ifsapp_archive_data01.dbf',
  '/oracleindex/IFSD/ifsapp_archive_index01.dbf',
  '/oracledata/IFSD/ifsapp_data02.dbf',
  '/oracleindex/IFSD/ifsapp_index02.dbf',
  '/oracledata/IFSD/ifsapp_data03.dbf',
  '/oracleindex/IFSD/ifsapp_index03.dbf',
  '/oracledata/IFSD/oem_repository01.dbf',
  '/oracledata/IFSD/ifsapp_data04.dbf',
  '/oracleindex/IFSD/ifsapp_index04.dbf',
  '/oracledata/IFSD/ifsapp_data05.dbf',
  '/oracleindex/IFSD/ifsapp_index05.dbf',
  '/oracledata/IFSD/ifsapp_data06.dbf',
  '/oracledata/IFSD/ifsapp_data07.dbf',
  '/oracledata/IFSD/ifsapp_data08.dbf',
  '/oracledata/IFSD/ifsapp_data09.dbf',
  '/oracledata/IFSD/ifsapp_data10.dbf',
  '/oracledata/IFSD/ifsapp_data11.dbf',
  '/oracleindex/IFSD/ifsapp_index06.dbf',
  '/oracledata/IFSD/sp_data01.dbf',
  '/oracledata/IFSD/ifsapp_data12.dbf',
  '/oracleindex/IFSD/ifsapp_index07.dbf',
  '/oracledata/IFSD/ifsapp_data13.dbf',
  '/oracleindex/IFSD/ifsapp_index08.dbf',
  '/oracledata/IFSD/ifsapp_data14.dbf',
  '/oracledata/IFSD/ifsapp_data15.dbf',
  '/oracledata/IFSD/QUEST.dbf'
CHARACTER SET WE8MSWIN1252
;
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE USING BACKUP CONTROLFILE
# Database can now be opened zeroing the online logs.
ALTER DATABASE OPEN RESETLOGS;
# Commands to add tempfiles to temporary tablespaces.
# Online tempfiles have complete space information.
# Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/oracledata/IFSD/temp01.dbf'
     SIZE 524288000  REUSE AUTOEXTEND OFF;
# End of tempfile additions.
#

Any pointers, please?

Thanks



Applications Support
UK
 
Sort by date Sort by votes
You may try something like this:
awk '
/^STARTUP/{++c}
c>1{print}
' $1 > $2

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
PHV,

So the single line replaces that entire script? It does appear to by the result, I have to say.




Applications Support
UK
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grazinggoat2
  • Locked
  • Question
ksh script to add multiple lines to csv cell formatting help
Replies
0
Views
72
grazinggoat2
grazinggoat2
BauV
  • Locked
  • Question
diff to show differed lines only (hiding common lines)
Replies
3
Views
100
BauV
BauV
tulsantide
  • Locked
  • Question
setenv not found error in cshrc on a solaris 11 machine
Replies
0
Views
58
tulsantide
tulsantide
rigstars2
  • Locked
  • Question
bash script bad substitution error message
Replies
2
Views
119
Christian Feard
Christian Feard
Sreekanth1521
  • Locked
  • Question
script is printing the code lines as part of the output
Replies
1
Views
83
SamBones
SamBones

Part and Inventory Search

Sponsor

Back
Top