| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Archive Logs Growing to Fast
Hello,
In the NT resource kit there is a utility called FORFILES.EXE which may =
be
of some help.
I have also seen it as freeware on the web. If you can get a DDMMYY =
format
using DATE /T
you've got it made. Please share it with the group if you succeed.
HTH
C:\>forfiles /?
Batch processing of files in a directory or tree.
emmanubo_at_microsoft.com
FORFILES [-pPath] [-mSearch Mask] [-ccommand] [-dDDMMYY] [-s] [-?]
-pPath Path where to start searching -mSearch Mask Search files according to <Search Mask> -cCommand Command to execute on each file(s) -dDDMMYY Select file with date>=3DDDMMYY -v Verbose mode -s Recurse into sub-directories -? Display this usage screen
The following variables can be used in Command : @FILE, @PATH, @RELPATH
Default : <Directory : .> <Search Mask : *.*> <Command : "CMD /C Echo
@FILE">
Example : FORFILES -pc:\ -s -m*.BAT -c"CMD /C Echo @FILE is a batch =
file"
-- Chris J. Guidry P.Eng. ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: chris.guidry_at_atcoelectric.comReceived on Wed Nov 22 2000 - 11:11:39 CST
> -----Original Message-----
> From: Dash, Saroj (CAP,CEF) [SMTP:Saroj.Dash_at_gecapital.com]
> Sent: Tuesday, November 21, 2000 9:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: ?: Archive Logs Growing to Fast
>=20
> How to remove the old archive file in NT.In unix it is ok.
>=20
> Any body has idea how to delete old 2day or 3 days archive files in =
NT . >=20
> -----OE=B3'=CCf=81fbfZ=81[fW-----
> =8D=B7=8Fo=90l: Suhen Pather [mailto:Suhen.Pather_at_strandbags.com.au]
> '-=90M"=FAZz: Wednesday, November 22, 2000 PM 12:45
> ^=B6=90=E6: Multiple recipients of list ORACLE-L
> OE=8F-=BC: RE: Archive Logs Growing to Fast
>=20
> Hi Larry
>=20
> Are you doing physical backups on your database???
> If not then the archives may be of no use.
> You can switch off archiving.
>=20
> If you are doing hot/cold backups and need the archives
> then you need to backup the logs before deleting them.
> The reason for so many archives is either the system=20
> is very busy (lots of write activity) or the online redo=20
> logs are too small. Try to resize the redo logs larger.
>=20
> Write a cron job to remove the old archives (older than 3 days).
> I do not have a script with me though.
> I have written a script like this and it is quite simple to write.
> Do a man on find and there are examples of how to write the ksh =
script
> to remove the old files.
>=20
> HTH
>=20
> Best Regards
>=20
> Suhen Pather
> Oracle DBA
> Strandbags (Australia)
> 02 9479 7791
> email suhen.pather_at_strandbags.com.au
>=20 >=20 >=20
> -----Original Message-----
> Sent: Wednesday, 22 November 2000 12:18
> To: Multiple recipients of list ORACLE-L
>=20 >=20
> Hi All,
>=20
> I need a script that will delete (rm) a file(s) if the file(s) is 3 =
days
> old.
> My archive logs are filling up my disk at a rapid pace.
>=20
> Does anyone have any suggestions?
>=20
> This is what the files look like:
>=20
> -rw-r----- 1 oracle dba 209715712 Nov 19 19:27 =
0000097621.arc
> -rw-r----- 1 oracle dba 209715712 Nov 19 19:38 =
0000097622.arc
> -rw-r----- 1 oracle dba 209715712 Nov 19 19:48 =
0000097623.arc
> -rw-r----- 1 oracle dba 209715712 Nov 19 19:59 =
0000097624.arc
> -rw-r----- 1 oracle dba 209715712 Nov 19 20:10 =
0000097625.arc
> -rw-r----- 1 oracle dba 209715712 Nov 19 20:20 =
0000097626.arc
> -rw-r----- 1 oracle dba 209715712 Nov 19 20:31 =
0000097627.arc
> -rw-r----- 1 oracle dba 209715712 Nov 19 20:42 =
0000097628.arc
> -rw-r----- 1 oracle dba 209715712 Nov 19 20:53 =
0000097629.arc
> -rw-r----- 1 oracle dba 209715712 Nov 19 21:04 =
0000097630.arc
> -rw-r----- 1 oracle dba 209715712 Nov 19 21:15 =
0000097631.arc
> -rw-r----- 1 oracle dba 209715712 Nov 19 21:26 =
0000097632.arc
> -rw-r----- 1 oracle dba 209715712 Nov 19 21:38 =
0000097633.arc >=20 >=20
> Thanks in advance
>=20
> larry
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Larry Taylor
> INET: ltaylor_at_iq.com
>=20
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Suhen Pather
> INET: Suhen.Pather_at_strandbags.com.au
>=20
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Dash, Saroj (CAP,CEF)
> INET: Saroj.Dash_at_gecapital.com
>=20
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
 |
 |