RE: Deleting old archive log files.
Or you could install Perl My god, I am starting to sound like Jared. -Original Message- McDonald Sent: Thursday, April 04, 2002 3:43 AM To: Multiple recipients of list ORACLE-L I don't - but maybe take a look at the rman package (dbms_rman.delete_file or something like that) which allows you to delete files from the operating system. You could then use PL/SQl and the various v$ views to determine which archives you want to toast. hth connor --- Mark Leith [EMAIL PROTECTED] wrote: Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this doesn't have a date/time based attribute parameter.. Has anybody been through this already? All help appreciated! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Deleting old archive log files.
Is it that terrible? :)) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 8:53 AM Or you could install Perl My god, I am starting to sound like Jared. -Original Message- McDonald Sent: Thursday, April 04, 2002 3:43 AM To: Multiple recipients of list ORACLE-L I don't - but maybe take a look at the rman package (dbms_rman.delete_file or something like that) which allows you to delete files from the operating system. You could then use PL/SQl and the various v$ views to determine which archives you want to toast. hth connor --- Mark Leith [EMAIL PROTECTED] wrote: Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this doesn't have a date/time based attribute parameter.. Has anybody been through this already? All help appreciated! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Deleting old archive log files.
Years of Perl evangelism are finally paying off. :) Jared On Friday 05 April 2002 07:18, Igor Neyman wrote: Is it that terrible? :)) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 8:53 AM Or you could install Perl My god, I am starting to sound like Jared. -Original Message- McDonald Sent: Thursday, April 04, 2002 3:43 AM To: Multiple recipients of list ORACLE-L I don't - but maybe take a look at the rman package (dbms_rman.delete_file or something like that) which allows you to delete files from the operating system. You could then use PL/SQl and the various v$ views to determine which archives you want to toast. hth connor --- Mark Leith [EMAIL PROTECTED] wrote: Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this doesn't have a date/time based attribute parameter.. Has anybody been through this already? All help appreciated! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Deleting old archive log files.
Jared, Without the signature (you've been using before) it's not that persuasive :)) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 12:08 PM Years of Perl evangelism are finally paying off. :) Jared On Friday 05 April 2002 07:18, Igor Neyman wrote: Is it that terrible? :)) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 05, 2002 8:53 AM Or you could install Perl My god, I am starting to sound like Jared. -Original Message- McDonald Sent: Thursday, April 04, 2002 3:43 AM To: Multiple recipients of list ORACLE-L I don't - but maybe take a look at the rman package (dbms_rman.delete_file or something like that) which allows you to delete files from the operating system. You could then use PL/SQl and the various v$ views to determine which archives you want to toast. hth connor --- Mark Leith [EMAIL PROTECTED] wrote: Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this doesn't have a date/time based attribute parameter.. Has anybody been through this already? All help appreciated! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Deleting old archive log files.
I don't - but maybe take a look at the rman package (dbms_rman.delete_file or something like that) which allows you to delete files from the operating system. You could then use PL/SQl and the various v$ views to determine which archives you want to toast. hth connor --- Mark Leith [EMAIL PROTECTED] wrote: Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this doesn't have a date/time based attribute parameter.. Has anybody been through this already? All help appreciated! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Deleting old archive log files.
I think you can use pearl script. Thanks, Ashoke -Original Message- Sent: Thursday, April 04, 2002 5:43 AM To: Multiple recipients of list ORACLE-L I don't - but maybe take a look at the rman package (dbms_rman.delete_file or something like that) which allows you to delete files from the operating system. You could then use PL/SQl and the various v$ views to determine which archives you want to toast. hth connor --- Mark Leith [EMAIL PROTECTED] wrote: Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this doesn't have a date/time based attribute parameter.. Has anybody been through this already? All help appreciated! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Deleting old archive log files.
Mark, I have a simple Perl script that can do the job for you. I've not found a way to do this using NT scripting. Attached is the script. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 04, 2002 6:43 AM To: Multiple recipients of list ORACLE-L I don't - but maybe take a look at the rman package (dbms_rman.delete_file or something like that) which allows you to delete files from the operating system. You could then use PL/SQl and the various v$ views to determine which archives you want to toast. hth connor --- Mark Leith [EMAIL PROTECTED] wrote: Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this doesn't have a date/time based attribute parameter.. Has anybody been through this already? All help appreciated! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). deldays.pl Description: Binary data
RE: Deleting old archive log files.
Tom, This is perfect! Thanks! Best wishes Mark -Original Message- Thomas F Sent: 04 April 2002 14:04 To: Multiple recipients of list ORACLE-L Mark, I have a simple Perl script that can do the job for you. I've not found a way to do this using NT scripting. Attached is the script. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, April 04, 2002 6:43 AM To: Multiple recipients of list ORACLE-L I don't - but maybe take a look at the rman package (dbms_rman.delete_file or something like that) which allows you to delete files from the operating system. You could then use PL/SQl and the various v$ views to determine which archives you want to toast. hth connor --- Mark Leith [EMAIL PROTECTED] wrote: Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this doesn't have a date/time based attribute parameter.. Has anybody been through this already? All help appreciated! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Deleting old archive log files.
Install the resource kit. Use the command forfiles. (I don't remember the syntax.) Todd Carlson Oracle Database Administrator Tripos, Inc. (314) 647-8837 Ext.3246 -Original Message- Sent: Thursday, April 04, 2002 4:39 AM To: Multiple recipients of list ORACLE-L Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this doesn't have a date/time based attribute parameter.. Has anybody been through this already? All help appreciated! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Todd Carlson INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Deleting old archive log files.
Hi Mark,
We use xxcopy utility to do that. but here is the sample script to do
this.
http://www.ultratech-llc.com/KB/?File=DelOld.TXT
Delete Files Older Than XX Days
Last Modified: 15 Aug 2001
~~~
*** PLEASE NOTE: Link(s), If Provided, May Be Wrapped ***
The following batch file will step through the specified
starting folder (%@FOLDER%) and its subfolders, and delete
all files older than %@AGE%.
It requires the use of Windows NT4 or higher, and several
utilities from the Resource Kit, such as FORFILES and
ROBOCOPY v1.95 or higher.
The folder must be the shortname if entered at the command
line. Longname folders should be entered directly into the
batch file.
The syntax is:
DELETEOLD.BAT folder age
Example:
DELETEOLD D:\LOGS 25
~~~
NOTE: The version below (C) will only work in Win2K.
See version D for a version compatible with
both NT4 and Win2K.
~~~
@ECHO OFF
rem ==
rem === Initialize Environment Variables
rem === Last Modified On 06 Jul 2000
rem ==
:Variables
SETLOCAL
SET @FOLDER=%1 IF /I %1== SET @FOLDER=C:\TEMP
SET @AGE=%2 IF /I %2== SET @AGE=30
SET @LOGFILE=%@FOLDER%\DeleteOld.LOG
rem ==
rem === Recurse Through Subfolders And Delete Old Files
rem === Last Modified On 17 Oct 2000
rem ==
:SetFolders
NOW Hunting Through %@FOLDER% And Subfolders For Old Files...
%@LOGFILE%
ECHO.
%@LOGFILE%
ECHO.
ECHO Hunting Through %@FOLDER% And Subfolders For Old Files...
ECHO.
FOR /F TOKENS=* %%D IN ('FORFILES -p%@FOLDER% -d-%@AGE% -s -cCMD
/C ECHO @PATH\@FILE') DO CALL :RemoveFiles %%D
rem ==
rem === Reset Environment Variables and Exit Batch File
rem === Last Modified On 27 Jun 2000
rem ==
:ExitBatch
ENDLOCAL
GOTO :EOF
rem ==
rem === SUBROUTINE: Remove Files That Are Over XX Days Old
rem === Last Modified On 17 Oct 2000
rem ==
:RemoveFiles
rem %* = Current Filename
ECHO. %@LOGFILE%
ECHO -- Purging %*...
ECHO -- Purging %*... %@LOGFILE%
ATTRIB -R -S -H %*
DEL %*%@LOGFILE%
GOTO :EOF
JOan
Mark Leith wrote:
Hi All,
To save me re-inventing the wheel:
Does anybody have a batch script (that runs on NT) that deletes archive log
files that are older than X days old? I've looked at the DEL command, but
this doesn't have a date/time based attribute parameter..
Has anybody been through this already?
All help appreciated!
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL PROTECTED]
===
http://www.cool-tools.co.uk
Maximising throughput performance
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joan Hsieh
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
Re: Deleting old archive log files.
If you are not using RMAN, the best, safest, and most portable approach whether deleting archived redo log files on UNIX, VMS, or Windows is the technique of SQL-generating-OScmd. Query the V$ARCHIVED_LOG view to retrieve the file's NAME where COMPLETION_TIME whatever-you-want and ARCHIVED='Y'. The query should be written to spool the OS-specific remove command along with the file-name, and the spool output can be run as a .bat script in Windows, a shell script in UNIX, or DCL script in OpenVMS. However, the most portable and sanest route is to use RMAN for backups and deletion of archived redo log files (and datafiles, of course), as all of RMAN's actions are recorded and are viewable through V$ARCHIVED_LOG and other views. RMAN not only handles archived redo log files according to the rules you specify, it can backup the log files multiple times before deleting them, keeping track of everything. If you have a bad tape, look for the archived redo log file on an older tape. RMAN also validates the redo log files during the backup to verify that it is not corrupted, an invaluable service. Yes, RMAN is tough to set up, but it's very name indicates it's focus. It's not called backup manager or BMAN for a reason. Being able to issue only two commands (i.e. RESTORE DATABASE and RECOVER DATABASE) over dialup from home after being roused at 2:30am and having RMAN do all the thinking for you is sublime. Every DBA who has been around for a couple years has their own backup scripts that they love and trust (myself included), but how many have bothered to automate restore and recovery? Those who have are certainly aware of the shortcomings of their own efforts and probably use their restore/recovery scripts very sparingly, if they are wise, as the most common cause of failed recoveries by far is not tape failure, but human error or (worse yet) semi-automated human error. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 5:58 AM I think you can use pearl script. Thanks, Ashoke -Original Message- Sent: Thursday, April 04, 2002 5:43 AM To: Multiple recipients of list ORACLE-L I don't - but maybe take a look at the rman package (dbms_rman.delete_file or something like that) which allows you to delete files from the operating system. You could then use PL/SQl and the various v$ views to determine which archives you want to toast. hth connor --- Mark Leith [EMAIL PROTECTED] wrote: Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this doesn't have a date/time based attribute parameter.. Has anybody been through this already? All help appreciated! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services
RE: Deleting old archive log files.
Mark, We use the forfiles.exe utility that comes with the NT Resource kit. I have attached it here and below I have pulled the code out of our hotbackup.cmd which runs our hotbackups. Its the last step in our hotbackup, to clean up old archived logs which have already been archived to tape. If you need any help with it just let me know. I've cc:ed you directly because I assume the listserv will strip the executable out of my email. Reed obviously, at the beginning of the script all the variables, like %bkupdir%, are defined rem rem Remove archived redo log files older than 3 days. rem forfiles is from the NT Resource Kit rem -p specifies search path rem -m specifies search mask rem -d specifies number of days (+/-) from today rem -c specifies the command to execute on each file remcmd /c executes command specified then terminates the shell rem %bkupdir%\forfiles -p%archdir%\%ORACLE_SID% -m*.arc -d-3 -ccmd /c del @FILE rem rem Remove trace files older than 35 days. rem %bkupdir%\forfiles -p%udumpdir% -m*.trc -d-35 -ccmd /c del @FILE -Original Message- Sent: Thursday, April 04, 2002 5:39 AM To: Multiple recipients of list ORACLE-L Hi All, To save me re-inventing the wheel: Does anybody have a batch script (that runs on NT) that deletes archive log files that are older than X days old? I've looked at the DEL command, but this doesn't have a date/time based attribute parameter.. Has anybody been through this already? All help appreciated! Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). attachment: forfiles.exe
RE: Deleting old archive log files.
the most portable and sanest route is to use RMAN Agreed. Go RMAN... Gorman... Hmmm... :-) Being able to issue only two commands (i.e. RESTORE DATABASE and RECOVER DATABASE) over dialup from home after being roused at 2:30am and having RMAN do all the thinking for you is sublime. If you do a RESTORE/RECOVER DATABASE doesn't RMAN retrieve and restore ALL datafiles from tape? Wouldn't this unnecessarily increase the mean time to recovery if you just need to recover one datafile? Orrman for RMAN, Steve Orr Bozeman, MT -Original Message- Sent: Thursday, April 04, 2002 7:19 AM To: Multiple recipients of list ORACLE-L If you are not using RMAN, the best, safest, and most portable approach whether deleting archived redo log files on UNIX, VMS, or Windows is the technique of SQL-generating-OScmd. Query the V$ARCHIVED_LOG view to retrieve the file's NAME where COMPLETION_TIME whatever-you-want and ARCHIVED='Y'. The query should be written to spool the OS-specific remove command along with the file-name, and the spool output can be run as a .bat script in Windows, a shell script in UNIX, or DCL script in OpenVMS. However, the most portable and sanest route is to use RMAN for backups and deletion of archived redo log files (and datafiles, of course), as all of RMAN's actions are recorded and are viewable through V$ARCHIVED_LOG and other views. RMAN not only handles archived redo log files according to the rules you specify, it can backup the log files multiple times before deleting them, keeping track of everything. If you have a bad tape, look for the archived redo log file on an older tape. RMAN also validates the redo log files during the backup to verify that it is not corrupted, an invaluable service. Yes, RMAN is tough to set up, but it's very name indicates it's focus. It's not called backup manager or BMAN for a reason. Being able to issue only two commands (i.e. RESTORE DATABASE and RECOVER DATABASE) over dialup from home after being roused at 2:30am and having RMAN do all the thinking for you is sublime. Every DBA who has been around for a couple years has their own backup scripts that they love and trust (myself included), but how many have bothered to automate restore and recovery? Those who have are certainly aware of the shortcomings of their own efforts and probably use their restore/recovery scripts very sparingly, if they are wise, as the most common cause of failed recoveries by far is not tape failure, but human error or (worse yet) semi-automated human error. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Deleting old archive log files.
Oh I agree as well.. Unfortunately, this was for a customer of ours, so the choice of backup utility is not up to me, and not our domain to recommend (though I did ask whether they had considered RMAN).. ours is not to reason why .. .. Thanks for all of your help though guys! Cheers Mark -Original Message- Sent: 04 April 2002 16:24 To: Multiple recipients of list ORACLE-L the most portable and sanest route is to use RMAN Agreed. Go RMAN... Gorman... Hmmm... :-) Being able to issue only two commands (i.e. RESTORE DATABASE and RECOVER DATABASE) over dialup from home after being roused at 2:30am and having RMAN do all the thinking for you is sublime. If you do a RESTORE/RECOVER DATABASE doesn't RMAN retrieve and restore ALL datafiles from tape? Wouldn't this unnecessarily increase the mean time to recovery if you just need to recover one datafile? Orrman for RMAN, Steve Orr Bozeman, MT -Original Message- Sent: Thursday, April 04, 2002 7:19 AM To: Multiple recipients of list ORACLE-L If you are not using RMAN, the best, safest, and most portable approach whether deleting archived redo log files on UNIX, VMS, or Windows is the technique of SQL-generating-OScmd. Query the V$ARCHIVED_LOG view to retrieve the file's NAME where COMPLETION_TIME whatever-you-want and ARCHIVED='Y'. The query should be written to spool the OS-specific remove command along with the file-name, and the spool output can be run as a .bat script in Windows, a shell script in UNIX, or DCL script in OpenVMS. However, the most portable and sanest route is to use RMAN for backups and deletion of archived redo log files (and datafiles, of course), as all of RMAN's actions are recorded and are viewable through V$ARCHIVED_LOG and other views. RMAN not only handles archived redo log files according to the rules you specify, it can backup the log files multiple times before deleting them, keeping track of everything. If you have a bad tape, look for the archived redo log file on an older tape. RMAN also validates the redo log files during the backup to verify that it is not corrupted, an invaluable service. Yes, RMAN is tough to set up, but it's very name indicates it's focus. It's not called backup manager or BMAN for a reason. Being able to issue only two commands (i.e. RESTORE DATABASE and RECOVER DATABASE) over dialup from home after being roused at 2:30am and having RMAN do all the thinking for you is sublime. Every DBA who has been around for a couple years has their own backup scripts that they love and trust (myself included), but how many have bothered to automate restore and recovery? Those who have are certainly aware of the shortcomings of their own efforts and probably use their restore/recovery scripts very sparingly, if they are wise, as the most common cause of failed recoveries by far is not tape failure, but human error or (worse yet) semi-automated human error. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Deleting old archive log files.
No, not from what I saw. I may be wrong, though. Lisa -Original Message- From: Orr, Steve [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Deleting old archive log files. the most portable and sanest route is to use RMAN Agreed. Go RMAN... Gorman... Hmmm... :-) Being able to issue only two commands (i.e. RESTORE DATABASE and RECOVER DATABASE) over dialup from home after being roused at 2:30am and having RMAN do all the thinking for you is sublime. If you do a RESTORE/RECOVER DATABASE doesn't RMAN retrieve and restore ALL datafiles from tape? Wouldn't this unnecessarily increase the mean time to recovery if you just need to recover one datafile? Orrman for RMAN, Steve Orr Bozeman, MT -Original Message- Sent: Thursday, April 04, 2002 7:19 AM To: Multiple recipients of list ORACLE-L If you are not using RMAN, the best, safest, and most portable approach whether deleting archived redo log files on UNIX, VMS, or Windows is the technique of SQL-generating-OScmd. Query the V$ARCHIVED_LOG view to retrieve the file's NAME where COMPLETION_TIME whatever-you-want and ARCHIVED='Y'. The query should be written to spool the OS-specific remove command along with the file-name, and the spool output can be run as a .bat script in Windows, a shell script in UNIX, or DCL script in OpenVMS. However, the most portable and sanest route is to use RMAN for backups and deletion of archived redo log files (and datafiles, of course), as all of RMAN's actions are recorded and are viewable through V$ARCHIVED_LOG and other views. RMAN not only handles archived redo log files according to the rules you specify, it can backup the log files multiple times before deleting them, keeping track of everything. If you have a bad tape, look for the archived redo log file on an older tape. RMAN also validates the redo log files during the backup to verify that it is not corrupted, an invaluable service. Yes, RMAN is tough to set up, but it's very name indicates it's focus. It's not called backup manager or BMAN for a reason. Being able to issue only two commands (i.e. RESTORE DATABASE and RECOVER DATABASE) over dialup from home after being roused at 2:30am and having RMAN do all the thinking for you is sublime. Every DBA who has been around for a couple years has their own backup scripts that they love and trust (myself included), but how many have bothered to automate restore and recovery? Those who have are certainly aware of the shortcomings of their own efforts and probably use their restore/recovery scripts very sparingly, if they are wise, as the most common cause of failed recoveries by far is not tape failure, but human error or (worse yet) semi-automated human error. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: RE: Deleting old archive log files.
You can recover just one or a set of datafiles with RMAN. I've had to do that for a recovery before. It will recover just the datafiles you need plus the necessary archive logs. Jim Koivu, Lisa [EMAIL PROTECTED] wrote: No, not from what I saw. I may be wrong, though. Lisa -Original Message- From: Orr, Steve [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Subject: RE: Deleting old archive log files. the most portable and sanest route is to use RMAN Agreed. Go RMAN... Gorman... Hmmm... :-) Being able to issue only two commands (i.e. RESTORE DATABASE and RECOVER DATABASE) over dialup from home after being roused at 2:30am and having RMAN do all the thinking for you is sublime. If you do a RESTORE/RECOVER DATABASE doesn't RMAN retrieve and restore ALL datafiles from tape? Wouldn't this unnecessarily increase the mean time to recovery if you just need to recover one datafile? Orrman for RMAN, Steve Orr Bozeman, MT -Original Message- Sent: Thursday, April 04, 2002 7:19 AM To: Multiple recipients of list ORACLE-L If you are not using RMAN, the best, safest, and most portable approach whether deleting archived redo log files on UNIX, VMS, or Windows is the technique of SQL-generating-OScmd. Query the V$ARCHIVED_LOG view to retrieve the file's NAME where COMPLETION_TIME whatever-you-want and ARCHIVED='Y'. The query should be written to spool the OS-specific remove command along with the file-name, and the spool output can be run as a .bat script in Windows, a shell script in UNIX, or DCL script in OpenVMS. However, the most portable and sanest route is to use RMAN for backups and deletion of archived redo log files (and datafiles, of course), as all of RMAN's actions are recorded and are viewable through V$ARCHIVED_LOG and other views. RMAN not only handles archived redo log files according to the rules you specify, it can backup the log files multiple times before deleting them, keeping track of everything. If you have a bad tape, look for the archived redo log file on an older tape. RMAN also validates the redo log files during the backup to verify that it is not corrupted, an invaluable service. Yes, RMAN is tough to set up, but it's very name indicates it's focus. It's not called backup manager or BMAN for a reason. Being able to issue only two commands (i.e. RESTORE DATABASE and RECOVER DATABASE) over dialup from home after being roused at 2:30am and having RMAN do all the thinking for you is sublime. Every DBA who has been around for a couple years has their own backup scripts that they love and trust (myself included), but how many have bothered to automate restore and recovery? Those who have are certainly aware of the shortcomings of their own efforts and probably use their restore/recovery scripts very sparingly, if they are wise, as the most common cause of failed recoveries by far is not tape failure, but human error or (worse yet) semi-automated human error. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services
