RE: Archive log full
thx a lot all , for the info. (I'll look out for book Oracle9i for Windows 2000 Tips Techniques) -Original Message- From: Michael P Sale [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 7:43 PM To: Multiple recipients of list ORACLE-L Subject:RE: Archive log full You absolutely need to keep the log archive destination disk space free to create new logs. You NEED to keep these archives for at least the time of the last beginning of a hot backup, or, if you're doing cold backups (with the database service stopped) then you need the archives from at least the time of the last cold backup. I would strongly suggest that you stop by your favorite bookstore and read the at least the first 2 chapters of my book Oracle9i for Windows 2000 Tips Techniques. This will give you a great background to avoid these kinds of problems in the future. The advantage of this book over the typical (and VERY good) books is that it is directed to the windows user. Regards, Michael Sale Author: Oracle9i for Windows(R) 2000 Tips Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626 -Original Message- Sent: Friday, May 31, 2002 6:23 AM To: Multiple recipients of list ORACLE-L Hi List, I am new to oracle, Archive Log has filledup the entire hard disk. (No error thrown by the Oracle) Can I move those(zip) files safely to other location. (win2k,Oracle 8.1.6) (I did went thru the manual) thx Sam __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d 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: Archive log full
Title: RE: Archive log full Do a backup that includes deleteing the archive logs. -Original Message- From: sam d [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 2:23 PM To: Multiple recipients of list ORACLE-L Subject: Archive log full Hi List, I am new to oracle, Archive Log has filledup the entire hard disk. (No error thrown by the Oracle) Can I move those(zip) files safely to other location. (win2k,Oracle 8.1.6) (I did went thru the manual) thx Sam __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d 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: Archive log full
Hi If no error now you'll get one soon (read the alert logs) you can safely move all the archive logs that are finished writing. I assume you have more than a day worth of archives so if you move anything older than a day for now you should be fine. after that it's time to write your automated scripts to do this for you. jack sam d sam_orafan@yahooTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: Archive log full [EMAIL PROTECTED] 31-05-2002 14:23 Please respond to ORACLE-L Hi List, I am new to oracle, Archive Log has filledup the entire hard disk. (No error thrown by the Oracle) Can I move those(zip) files safely to other location. (win2k,Oracle 8.1.6) (I did went thru the manual) thx Sam __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d 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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the
RE: Archive log full
Sam, Yes, you may move and delete the files and copy them to tape for safekeeping. Note: If you are using Rman, you should run an Rman archivelog backup - otherwise, it will complain about needing to back the files up. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, May 31, 2002 8:23 AM To: Multiple recipients of list ORACLE-L Hi List, I am new to oracle, Archive Log has filledup the entire hard disk. (No error thrown by the Oracle) Can I move those(zip) files safely to other location. (win2k,Oracle 8.1.6) (I did went thru the manual) thx Sam __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d 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: Mercadante, Thomas F 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: Archive log full
You absolutely need to keep the log archive destination disk space free to create new logs. You NEED to keep these archives for at least the time of the last beginning of a hot backup, or, if you're doing cold backups (with the database service stopped) then you need the archives from at least the time of the last cold backup. I would strongly suggest that you stop by your favorite bookstore and read the at least the first 2 chapters of my book Oracle9i for Windows 2000 Tips Techniques. This will give you a great background to avoid these kinds of problems in the future. The advantage of this book over the typical (and VERY good) books is that it is directed to the windows user. Regards, Michael Sale Author: Oracle9i for Windows(R) 2000 Tips Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626 -Original Message- Sent: Friday, May 31, 2002 6:23 AM To: Multiple recipients of list ORACLE-L Hi List, I am new to oracle, Archive Log has filledup the entire hard disk. (No error thrown by the Oracle) Can I move those(zip) files safely to other location. (win2k,Oracle 8.1.6) (I did went thru the manual) thx Sam __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d 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: Michael P Sale 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).