I am having a shell script that connects to database half hourly and pulls out the backlog from some tables. Now that logfile is growing too big and I need to housekeep it! effectively I want to keep last 30 days data in that file and move rest to archived file.
The file contents are as below.
the algorithm I want is as follow :

take input file my.log
go to first line, check if this is more than 90 days
if it is then
pick those lines fom log file till the next sql plus ( i.e. that block) and append to some archive file ( difficult ?)
delete these lines from current file

if it is not then leave it as it is

can somebody help me writting this please ?

---------------------------------------------------------------------------------SQL*Plus: Release 8.1.7.0.0 - Production on Thu Feb 27 19:20:00 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Enter user-name:
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production

SQL> SQL> 76834445

SQL> 76834445

SQL> 2 3 4 5 6 7 8 9 ELFORDE
75241084 1593361 25-NOV-02 18:18:10

HEWITTSA
76238384 596061 20-DEC-02 09:18:09
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Pro
duction
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Feb 27 19:50:00 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Enter user-name:
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production
---------------------------------------------------------------------------------

Thanks in advance.