RE: Redo log size MAX = ?
True. ;-) But considering my foot-in-mouth disease lately, I figured I'd phrase my response as a question... Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Tim Sawmiller [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 03, 2001 2:41 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Redo log size MAX = ? > > So, based on the responses I've seen, this statement can be declared to be > false. > > > >>> [EMAIL PROTECTED] 04/03/01 11:05AM >>> > hi > forget about recovery from online redo logs > It doesn't exist in Oracle > > Regards > Tapiwa > > -Original Message- > Sent: Tuesday, April 03, 2001 3:01 PM > To: Multiple recipients of list ORACLE-L > > > Hi, > > My database = noarchive mode (compulsory for our application) > In case of instance failure can oracle perform recovery from redo log ? if > can what will be tne maximum size of the redo log recommended. > Because I need set that size for whole day transaction currently 512K (3 > redo logs) switched every 15 - 30 minutes. > Can oracle perform recovery from inactive or "other status" redo log ? > > Thank you. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Redo log size MAX = ?
So, based on the responses I've seen, this statement can be declared to be false. >>> [EMAIL PROTECTED] 04/03/01 11:05AM >>> hi forget about recovery from online redo logs It doesn't exist in Oracle Regards Tapiwa -Original Message- Sent: Tuesday, April 03, 2001 3:01 PM To: Multiple recipients of list ORACLE-L Hi, My database = noarchive mode (compulsory for our application) In case of instance failure can oracle perform recovery from redo log ? if can what will be tne maximum size of the redo log recommended. Because I need set that size for whole day transaction currently 512K (3 redo logs) switched every 15 - 30 minutes. Can oracle perform recovery from inactive or "other status" redo log ? Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Zhou, Tapiwanashe 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: Tim Sawmiller 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: Redo log size MAX = ?
That is true. The archive logs are nothing more then copies of the redo logs before they are reused. >>> [EMAIL PROTECTED] 04/03/01 01:10PM >>> Is this true? I thought that if the transactions needed for recovery are in the online redo logs, and the online logs are available, then the RECOVER DATABASE statement will read from the online logs. Just did it this morning on a noarchivelog database, Oracle 7.3.3. If however, the data needed for recovery in the online logs has been overwritten, then the database will be unrecoverable. Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Zhou, Tapiwanashe [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 03, 2001 10:05 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Redo log size MAX = ? > > hi > forget about recovery from online redo logs > It doesn't exist in Oracle > > Regards > Tapiwa > > -Original Message- > Sent: Tuesday, April 03, 2001 3:01 PM > To: Multiple recipients of list ORACLE-L > > > Hi, > > My database = noarchive mode (compulsory for our application) > In case of instance failure can oracle perform recovery from redo log ? if > can what will be tne maximum size of the redo log recommended. > Because I need set that size for whole day transaction currently 512K (3 > redo logs) switched every 15 - 30 minutes. > Can oracle perform recovery from inactive or "other status" redo log ? > > Thank you. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy Xing > 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: Zhou, Tapiwanashe > 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: 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: William Beilstein 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: Redo log size MAX = ?
Is this true? I thought that if the transactions needed for recovery are in the online redo logs, and the online logs are available, then the RECOVER DATABASE statement will read from the online logs. Just did it this morning on a noarchivelog database, Oracle 7.3.3. If however, the data needed for recovery in the online logs has been overwritten, then the database will be unrecoverable. Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Zhou, Tapiwanashe [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 03, 2001 10:05 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Redo log size MAX = ? > > hi > forget about recovery from online redo logs > It doesn't exist in Oracle > > Regards > Tapiwa > > -Original Message- > Sent: Tuesday, April 03, 2001 3:01 PM > To: Multiple recipients of list ORACLE-L > > > Hi, > > My database = noarchive mode (compulsory for our application) > In case of instance failure can oracle perform recovery from redo log ? if > can what will be tne maximum size of the redo log recommended. > Because I need set that size for whole day transaction currently 512K (3 > redo logs) switched every 15 - 30 minutes. > Can oracle perform recovery from inactive or "other status" redo log ? > > Thank you. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy Xing > 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: Zhou, Tapiwanashe > 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: 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: Redo log size MAX = ?
That would be one of those RTFM questions, don't you think? -Original Message- Sent: Tuesday, April 03, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Why can't you use archiving? It doesn't effect the applications running on the database in anyway (except space to store the archives) >>> [EMAIL PROTECTED] 04/03/01 09:00AM >>> Hi, My database = noarchive mode (compulsory for our application) In case of instance failure can oracle perform recovery from redo log ? if can what will be tne maximum size of the redo log recommended. Because I need set that size for whole day transaction currently 512K (3 redo logs) switched every 15 - 30 minutes. Can oracle perform recovery from inactive or "other status" redo log ? Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: William Beilstein 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: Gogala, Mladen 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: Redo log size MAX = ?
hi forget about recovery from online redo logs It doesn't exist in Oracle Regards Tapiwa -Original Message- Sent: Tuesday, April 03, 2001 3:01 PM To: Multiple recipients of list ORACLE-L Hi, My database = noarchive mode (compulsory for our application) In case of instance failure can oracle perform recovery from redo log ? if can what will be tne maximum size of the redo log recommended. Because I need set that size for whole day transaction currently 512K (3 redo logs) switched every 15 - 30 minutes. Can oracle perform recovery from inactive or "other status" redo log ? Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Zhou, Tapiwanashe 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: Redo log size MAX = ?
Why can't you use archiving? It doesn't effect the applications running on the database in anyway (except space to store the archives) >>> [EMAIL PROTECTED] 04/03/01 09:00AM >>> Hi, My database = noarchive mode (compulsory for our application) In case of instance failure can oracle perform recovery from redo log ? if can what will be tne maximum size of the redo log recommended. Because I need set that size for whole day transaction currently 512K (3 redo logs) switched every 15 - 30 minutes. Can oracle perform recovery from inactive or "other status" redo log ? Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: William Beilstein 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).
Redo log size MAX = ?
Hi, My database = noarchive mode (compulsory for our application) In case of instance failure can oracle perform recovery from redo log ? if can what will be tne maximum size of the redo log recommended. Because I need set that size for whole day transaction currently 512K (3 redo logs) switched every 15 - 30 minutes. Can oracle perform recovery from inactive or "other status" redo log ? Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).