Re: Managing Archived Redo Logs
Dave, yes you have the responsibility to get them off disk, ie: the database will appear to halt processing if the archive_dest gets full. RMAN is good for that, you can back them up and purge them in one step. Feel free to email direct if you want to talk in depth about it. joe Farnsworth, Dave wrote: I finally get to put our 8.1.7 on NT databases into archivelog mode. We have a third party app vendor that would not support us if I did this but I finally convinced them that is the way to go and it should not effect the app. Anyway, I am reading chapter 7 from the Administrators Guide, Managing Archived Redo Logs. I know I have to set the parameters in the init.ora to achieve automatic archiving; log_archive_start=true log_archive_dest_1 = location=my\disk\drive log_archive_format=%%ORACLE_SID%%T%T%S.ARC -or somthing like that One thing I don't see in TFM is, do these archived redo logs just keep accumulating in the destination directory set in the log_archive_dest_1 parameter? Do I need to create a process to get them to tape and then once on tape, delete these old archive redo logs through my process? I'm just excited to be able to finally go to archivelog mode. Once I get the basics down then I want to investigate using RMAN. Thanks, Dave -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Managing Archived Redo Logs
Hello, Yes , you sure need to delete the old archive files becuase if you don't, it will eat up your space. I keep my arch files for 1 week. the arch files oder than that, I just have a job to delete it. But besure to backup it first UK Farnsworth, Dave [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/24/2003 09:29 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Managing Archived Redo Logs I finally get to put our 8.1.7 on NT databases into archivelog mode. We have a third party app vendor that would not support us if I did this but I finally convinced them that is the way to go and it should not effect the app. Anyway, I am reading chapter 7 from the Administrators Guide, Managing Archived Redo Logs. I know I have to set the parameters in the init.ora to achieve automatic archiving; log_archive_start=true log_archive_dest_1 = location=my\disk\drive log_archive_format=%%ORACLE_SID%%T%T%S.ARC -or somthing like that One thing I don't see in TFM is, do these archived redo logs just keep accumulating in the destination directory set in the log_archive_dest_1 parameter? Do I need to create a process to get them to tape and then once on tape, delete these old archive redo logs through my process? I'm just excited to be able to finally go to archivelog mode. Once I get the basics down then I want to investigate using RMAN. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Managing Archived Redo Logs
Yes you have to move them to tape and either compress or delete them once you have backed up the logs and datafiles Check out the Backup and Recovery Handbook by Velpuri, there are some pretty good examples there. If you don't clean out the archive directory on occasion, the database will hang when that filesystem is filled. you won't get a message that it's hung but it will hang. --- Farnsworth, Dave [EMAIL PROTECTED] wrote: I finally get to put our 8.1.7 on NT databases into archivelog mode. We have a third party app vendor that would not support us if I did this but I finally convinced them that is the way to go and it should not effect the app. Anyway, I am reading chapter 7 from the Administrators Guide, Managing Archived Redo Logs. I know I have to set the parameters in the init.ora to achieve automatic archiving; log_archive_start=true log_archive_dest_1 = location=my\disk\drive log_archive_format=%%ORACLE_SID%%T%T%S.ARC -or somthing like that One thing I don't see in TFM is, do these archived redo logs just keep accumulating in the destination directory set in the log_archive_dest_1 parameter? Do I need to create a process to get them to tape and then once on tape, delete these old archive redo logs through my process? I'm just excited to be able to finally go to archivelog mode. Once I get the basics down then I want to investigate using RMAN. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Managing Archived Redo Logs
Just to add that you _can_ be informed of this if you monitor the alert log. The following errors are logged (from a live system, and way back from 7.3.4!) Thread 1 advanced to log sequence 69529 Current log# 1 seq# 69529 mem# 0: /u090/oradata//REDO0101.DBF Current log# 1 seq# 69529 mem# 1: /u091/oradata//REDO0102.DBF ...skipping... ORA-00255: error archiving log 1 of thread 1, sequence # 69616 ORA-00312: online log 1 thread 1: '/u090/oradata//REDO0101.DBF' ORA-00312: online log 1 thread 1: '/u091/oradata//REDO0102.DBF' ORA-00272: error writing archive log ORA-00334: archived log: '/u091/oradata//arch/arch1_69616.log' ARCH: ORA-00255: error archiving log 1 of thread 1, sequence # 69616 ORA-00312: online log 1 thread 1: '/u090/oradata//REDO0101.DBF' ORA-00312: online log 1 thread 1: '/u091/oradata//REDO0102.DBF' ORA-00272: error writing archive log ORA-00334: archived log: '/u091/oradata//arch/arch1_69616.log' Mon May 13 05:36:57 2002 Thread 1 cannot allocate new log, sequence 69618 Checkpoint not complete John Kanagaraj -Original Message- Sent: Wednesday, July 23, 2003 12:30 PM To: Multiple recipients of list ORACLE-L Yes you have to move them to tape and either compress or delete them once you have backed up the logs and datafiles Check out the Backup and Recovery Handbook by Velpuri, there are some pretty good examples there. If you don't clean out the archive directory on occasion, the database will hang when that filesystem is filled. you won't get a message that it's hung but it will hang. --- Farnsworth, Dave [EMAIL PROTECTED] wrote: I finally get to put our 8.1.7 on NT databases into archivelog mode. We have a third party app vendor that would not support us if I did this but I finally convinced them that is the way to go and it should not effect the app. Anyway, I am reading chapter 7 from the Administrators Guide, Managing Archived Redo Logs. I know I have to set the parameters in the init.ora to achieve automatic archiving; log_archive_start=true log_archive_dest_1 = location=my\disk\drive log_archive_format=%%ORACLE_SID%%T%T%S.ARC -or somthing like that One thing I don't see in TFM is, do these archived redo logs just keep accumulating in the destination directory set in the log_archive_dest_1 parameter? Do I need to create a process to get them to tape and then once on tape, delete these old archive redo logs through my process? I'm just excited to be able to finally go to archivelog mode. Once I get the basics down then I want to investigate using RMAN. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Managing Archived Redo Logs
Dave, Welcome to the world of archivelogs, Point it time recovery, and running out of disk space at 2 am. Yes the archive logs have to be saved to tape, a pc, or other storage device else the disk will full up and the instance will hang waiting for disk space to write the log. I have 200 GIG space for archivelogs and RMAN depository and I have to watch the space when I execute a long running update of the database. The RMAN backup process is slick and easy to set up and learn. There are some nice books on the market that really help. The can be confusing as they talk about the actions needed with 9i and 8i and the instruction sets are different for each version. I use a Linux pc to control the RMAN backup of the database (prod) and RMAN instance and depository are on the development server. I delete the files over 3 weeks old ( they are backed up on tape weekly) and then clean up the RMAN catalog. Works nice and easy. Recovery is fast and easy also. Ron [EMAIL PROTECTED] 07/23/03 03:09PM I finally get to put our 8.1.7 on NT databases into archivelog mode. We have a third party app vendor that would not support us if I did this but I finally convinced them that is the way to go and it should not effect the app. Anyway, I am reading chapter 7 from the Administrators Guide, Managing Archived Redo Logs. I know I have to set the parameters in the init.ora to achieve automatic archiving; log_archive_start=true log_archive_dest_1 = location=my\disk\drive log_archive_format=%%ORACLE_SID%%T%T%S.ARC -or somthing like that One thing I don't see in TFM is, do these archived redo logs just keep accumulating in the destination directory set in the log_archive_dest_1 parameter? Do I need to create a process to get them to tape and then once on tape, delete these old archive redo logs through my process? I'm just excited to be able to finally go to archivelog mode. Once I get the basics down then I want to investigate using RMAN. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Managing Archived Redo Logs
Yes, you need to establish some process to manage archived RedoLogs. All archived RedoLogs accumulated between two consecutive online/hot backups should be included into backup set. Then you can delete them or keep for a while if space permits. Read on backups for db in archivelog mode. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Farnsworth, Dave Sent: Wednesday, July 23, 2003 2:09 PM To: Multiple recipients of list ORACLE-L I finally get to put our 8.1.7 on NT databases into archivelog mode. We have a third party app vendor that would not support us if I did this but I finally convinced them that is the way to go and it should not effect the app. Anyway, I am reading chapter 7 from the Administrators Guide, Managing Archived Redo Logs. I know I have to set the parameters in the init.ora to achieve automatic archiving; log_archive_start=true log_archive_dest_1 = location=my\disk\drive log_archive_format=%%ORACLE_SID%%T%T%S.ARC -or somthing like that One thing I don't see in TFM is, do these archived redo logs just keep accumulating in the destination directory set in the log_archive_dest_1 parameter? Do I need to create a process to get them to tape and then once on tape, delete these old archive redo logs through my process? I'm just excited to be able to finally go to archivelog mode. Once I get the basics down then I want to investigate using RMAN. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Managing Archived Redo Logs
As much as I hate to disagree with the DBA Goddess... The database will not HANG. A more appropriate term is that further processing is halted until it is able to archive the redo log before it begins to overwrite it. You will receive a message in the alert log, I don't recall the exact text, but it is along the lines of archiver stuck or unable to archive a log. waiting for the lightning bolt... Rachel Carmichael wrote: Yes you have to move them to tape and either compress or delete them once you have backed up the logs and datafiles Check out the Backup and Recovery Handbook by Velpuri, there are some pretty good examples there. If you don't clean out the archive directory on occasion, the database will hang when that filesystem is filled. you won't get a message that it's hung but it will hang.begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
RE: Managing Archived Redo Logs
it's not exactly crystal clear but yes the error is there. I knew I was forgetting something :) --- John Kanagaraj [EMAIL PROTECTED] wrote: Just to add that you _can_ be informed of this if you monitor the alert log. The following errors are logged (from a live system, and way back from 7.3.4!) Thread 1 advanced to log sequence 69529 Current log# 1 seq# 69529 mem# 0: /u090/oradata//REDO0101.DBF Current log# 1 seq# 69529 mem# 1: /u091/oradata//REDO0102.DBF ...skipping... ORA-00255: error archiving log 1 of thread 1, sequence # 69616 ORA-00312: online log 1 thread 1: '/u090/oradata//REDO0101.DBF' ORA-00312: online log 1 thread 1: '/u091/oradata//REDO0102.DBF' ORA-00272: error writing archive log ORA-00334: archived log: '/u091/oradata//arch/arch1_69616.log' ARCH: ORA-00255: error archiving log 1 of thread 1, sequence # 69616 ORA-00312: online log 1 thread 1: '/u090/oradata//REDO0101.DBF' ORA-00312: online log 1 thread 1: '/u091/oradata//REDO0102.DBF' ORA-00272: error writing archive log ORA-00334: archived log: '/u091/oradata//arch/arch1_69616.log' Mon May 13 05:36:57 2002 Thread 1 cannot allocate new log, sequence 69618 Checkpoint not complete John Kanagaraj -Original Message- Sent: Wednesday, July 23, 2003 12:30 PM To: Multiple recipients of list ORACLE-L Yes you have to move them to tape and either compress or delete them once you have backed up the logs and datafiles Check out the Backup and Recovery Handbook by Velpuri, there are some pretty good examples there. If you don't clean out the archive directory on occasion, the database will hang when that filesystem is filled. you won't get a message that it's hung but it will hang. --- Farnsworth, Dave [EMAIL PROTECTED] wrote: I finally get to put our 8.1.7 on NT databases into archivelog mode. We have a third party app vendor that would not support us if I did this but I finally convinced them that is the way to go and it should not effect the app. Anyway, I am reading chapter 7 from the Administrators Guide, Managing Archived Redo Logs. I know I have to set the parameters in the init.ora to achieve automatic archiving; log_archive_start=true log_archive_dest_1 = location=my\disk\drive log_archive_format=%%ORACLE_SID%%T%T%S.ARC -or somthing like that One thing I don't see in TFM is, do these archived redo logs just keep accumulating in the destination directory set in the log_archive_dest_1 parameter? Do I need to create a process to get them to tape and then once on tape, delete these old archive redo logs through my process? I'm just excited to be able to finally go to archivelog mode. Once I get the basics down then I want to investigate using RMAN. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
Re: Managing Archived Redo Logs
no lightening bolt, remind me not to post things after lunch... the database will appear to hang. you like that phrasing better? :) If you cycle around in the redo logs to the point where Oracle would have to overwrite an unarchived log, no one can log into the database and most processes will stop, waiting for the log to be archived. --- Daniel Fink [EMAIL PROTECTED] wrote: As much as I hate to disagree with the DBA Goddess... The database will not HANG. A more appropriate term is that further processing is halted until it is able to archive the redo log before it begins to overwrite it. You will receive a message in the alert log, I don't recall the exact text, but it is along the lines of archiver stuck or unable to archive a log. waiting for the lightning bolt... Rachel Carmichael wrote: Yes you have to move them to tape and either compress or delete them once you have backed up the logs and datafiles Check out the Backup and Recovery Handbook by Velpuri, there are some pretty good examples there. If you don't clean out the archive directory on occasion, the database will hang when that filesystem is filled. you won't get a message that it's hung but it will hang. begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Managing Archived Redo Logs
You will have to write separate batch script or use some tool to back them up to tape . Yes, RMAN can do it all for you if setup accordingly to delete xyz days old archived log; -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 12:09 PM I finally get to put our 8.1.7 on NT databases into archivelog mode. We have a third party app vendor that would not support us if I did this but I finally convinced them that is the way to go and it should not effect the app. Anyway, I am reading chapter 7 from the Administrators Guide, Managing Archived Redo Logs. I know I have to set the parameters in the init.ora to achieve automatic archiving; log_archive_start=true log_archive_dest_1 = location=my\disk\drive log_archive_format=%%ORACLE_SID%%T%T%S.ARC -or somthing like that One thing I don't see in TFM is, do these archived redo logs just keep accumulating in the destination directory set in the log_archive_dest_1 parameter? Do I need to create a process to get them to tape and then once on tape, delete these old archive redo logs through my process? I'm just excited to be able to finally go to archivelog mode. Once I get the basics down then I want to investigate using RMAN. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Managing Archived Redo Logs
We have a third party app vendor that would not support us if I did this Just out of curiosity, why does this vendor not support archive log mode? Gudmundur -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Josepsson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Managing Archived Redo Logs
To piggyback on John's reply, one of our 8173 test systems filled the archive destination over the weekend during a application upgrade. Now the Unix directory was fill for less than 90 minutes and the database was hung/halted for less than 45 minutes but 10s of thousands of line of the following were written to the alert log: ARC2: Beginning to archive log# 9 seq# 160 ARC2: Failed to archive log# 9 seq# 160 ARC2: Beginning to archive log# 10 seq# 161 ARC2: Failed to archive log# 10 seq# 161 As the database spawned 9 ARCn processes and continued to attempt to write out filled redo logs. If this goes on too long you are also at risk of filling the 'background_dump_dest' directory as well. Mike Hand -Original Message- Sent: Wednesday, July 23, 2003 3:44 PM To: Multiple recipients of list ORACLE-L Just to add that you _can_ be informed of this if you monitor the alert log. The following errors are logged (from a live system, and way back from 7.3.4!) Thread 1 advanced to log sequence 69529 Current log# 1 seq# 69529 mem# 0: /u090/oradata//REDO0101.DBF Current log# 1 seq# 69529 mem# 1: /u091/oradata//REDO0102.DBF ..skipping... ORA-00255: error archiving log 1 of thread 1, sequence # 69616 ORA-00312: online log 1 thread 1: '/u090/oradata//REDO0101.DBF' ORA-00312: online log 1 thread 1: '/u091/oradata//REDO0102.DBF' ORA-00272: error writing archive log ORA-00334: archived log: '/u091/oradata//arch/arch1_69616.log' ARCH: ORA-00255: error archiving log 1 of thread 1, sequence # 69616 ORA-00312: online log 1 thread 1: '/u090/oradata//REDO0101.DBF' ORA-00312: online log 1 thread 1: '/u091/oradata//REDO0102.DBF' ORA-00272: error writing archive log ORA-00334: archived log: '/u091/oradata//arch/arch1_69616.log' Mon May 13 05:36:57 2002 Thread 1 cannot allocate new log, sequence 69618 Checkpoint not complete John Kanagaraj This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Managing Archived Redo Logs
I believe that if the database is hung because of the archiver unable to write because of the lack of disk space, you can still connect using the svrmgr. It at least gives you a method of snooping around of your alert log doesn't point to the problem. Ron [EMAIL PROTECTED] 07/23/03 04:14PM no lightening bolt, remind me not to post things after lunch... the database will appear to hang. you like that phrasing better? :) If you cycle around in the redo logs to the point where Oracle would have to overwrite an unarchived log, no one can log into the database and most processes will stop, waiting for the log to be archived. --- Daniel Fink [EMAIL PROTECTED] wrote: As much as I hate to disagree with the DBA Goddess... The database will not HANG. A more appropriate term is that further processing is halted until it is able to archive the redo log before it begins to overwrite it. You will receive a message in the alert log, I don't recall the exact text, but it is along the lines of archiver stuck or unable to archive a log. waiting for the lightning bolt... Rachel Carmichael wrote: Yes you have to move them to tape and either compress or delete them once you have backed up the logs and datafiles Check out the Backup and Recovery Handbook by Velpuri, there are some pretty good examples there. If you don't clean out the archive directory on occasion, the database will hang when that filesystem is filled. you won't get a message that it's hung but it will hang. begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Managing Archived Redo Logs
Dave - There is an alter command you need to issue as well. This often trips people up. Here are my instructions, which will work on 8.1.7 init.ora - log_archive_start = true startup mount alter database archivelog; archive log start alter database open Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 23, 2003 2:09 PM To: Multiple recipients of list ORACLE-L I finally get to put our 8.1.7 on NT databases into archivelog mode. We have a third party app vendor that would not support us if I did this but I finally convinced them that is the way to go and it should not effect the app. Anyway, I am reading chapter 7 from the Administrators Guide, Managing Archived Redo Logs. I know I have to set the parameters in the init.ora to achieve automatic archiving; log_archive_start=true log_archive_dest_1 = location=my\disk\drive log_archive_format=%%ORACLE_SID%%T%T%S.ARC -or somthing like that One thing I don't see in TFM is, do these archived redo logs just keep accumulating in the destination directory set in the log_archive_dest_1 parameter? Do I need to create a process to get them to tape and then once on tape, delete these old archive redo logs through my process? I'm just excited to be able to finally go to archivelog mode. Once I get the basics down then I want to investigate using RMAN. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Managing Archived Redo Logs
Hi! You actually can connect using sqlplus as well, even over the network, as long as your connection is sysdba (or probably sysoper as well). There's several more interesting issues with sysdba connections, for example if you got a bad after logon trigger which throws unhandled exceptions, regular users can't logon, but sysdba can (actually it comes from administer database trigger privilege), but the idea is that the database can behave quite differently for privileged users.. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 24, 2003 12:24 AM I believe that if the database is hung because of the archiver unable to write because of the lack of disk space, you can still connect using the svrmgr. It at least gives you a method of snooping around of your alert log doesn't point to the problem. Ron [EMAIL PROTECTED] 07/23/03 04:14PM no lightening bolt, remind me not to post things after lunch... the database will appear to hang. you like that phrasing better? :) If you cycle around in the redo logs to the point where Oracle would have to overwrite an unarchived log, no one can log into the database and most processes will stop, waiting for the log to be archived. --- Daniel Fink [EMAIL PROTECTED] wrote: As much as I hate to disagree with the DBA Goddess... The database will not HANG. A more appropriate term is that further processing is halted until it is able to archive the redo log before it begins to overwrite it. You will receive a message in the alert log, I don't recall the exact text, but it is along the lines of archiver stuck or unable to archive a log. waiting for the lightning bolt... Rachel Carmichael wrote: Yes you have to move them to tape and either compress or delete them once you have backed up the logs and datafiles Check out the Backup and Recovery Handbook by Velpuri, there are some pretty good examples there. If you don't clean out the archive directory on occasion, the database will hang when that filesystem is filled. you won't get a message that it's hung but it will hang. begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Managing Archived Redo Logs
Yes, the archive files will continue to accumulate. You will need to copy them to a backup directory, then copy the files to tape, then when the copy is confirmed as being completed, then delete the originals in the archive directory. Do not erase the current one that is being written. There are a couple of ways to avoid this. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] niture.com To: [EMAIL PROTECTED] Sent by:cc: [EMAIL PROTECTED] Subject: Managing Archived Redo Logs 07/23/2003 02:09 PM Please respond to ORACLE-L I finally get to put our 8.1.7 on NT databases into archivelog mode. We have a third party app vendor that would not support us if I did this but I finally convinced them that is the way to go and it should not effect the app. Anyway, I am reading chapter 7 from the Administrators Guide, Managing Archived Redo Logs. I know I have to set the parameters in the init.ora to achieve automatic archiving; log_archive_start=true log_archive_dest_1 = location=my\disk\drive log_archive_format=%%ORACLE_SID%%T%T%S.ARC -or somthing like that One thing I don't see in TFM is, do these archived redo logs just keep accumulating in the destination directory set in the log_archive_dest_1 parameter? Do I need to create a process to get them to tape and then once on tape, delete these old archive redo logs through my process? I'm just excited to be able to finally go to archivelog mode. Once I get the basics down then I want to investigate using RMAN. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
