RE: archive log curr v. switch logfile
I use Alter system archive log current. If your archiver process is caught up, you will get this error message when issuing Alter system archive log all: SQL alter system archive log all; alter system archive log all * ERROR at line 1: ORA-00271: there are no logs that need archiving Just don't like error messages in the logs :). Lisa's method seems the safest, but never had an archiver not keeping up and if I did, that would be an issue to be resolved quickly. Here's my hot backup model with help from list members and Velpuri/Adkoli's Backup/Recovery Book: # 1) Alter system archive log current ; # 2) Check backup status. # 3) Generate datafile listing. # 4) Alter tablespace tablespace_name begin backup ; # 5) Some other process,script,legato,etc. will copy database files # to disk or to tape. # 6) Alter tablespace tablespace_name end backup ; # 7) Backup controlfile. # 8) Alter system archive log current ; # Archives are backed up separately 2 x day to tape. Gene PS. Confident w/ hot backups, next to conquer RMAN cautiously. [EMAIL PROTECTED] 03/29/02 12:13PM Actually I use alter system archive log all. I saw that if the database was behind with archiving, this would ensure that all logs were written to the arc destination. archive log current only did the most recent. Am I wrong? Please correct me if I am . Lisa Koivu Oracle Database Baby Oven Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Post, Ethan [SMTP:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 11:48 AM To: Multiple recipients of list ORACLE-L Subject: RE: archive log curr v. switch logfile I believe alter system archive log current will wait until archiver has successfully archived the file, thus this is the one you would want to use in any backup scripts. - Ethan -Original Message- Sent: Friday, March 29, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Can anyone tell me the difference between alter system archive log current and alter system switch logfile (Seems they both perform checkpoint and both switch a log file). Is one preferred over the other for purposes of switching log files prior to applying to a standby database? Thanks for any insights. Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara 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: Post, Ethan 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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 curr v. switch logfile
Gene's afraid of R-Man! Gene's afraid of R-Man! Gene you will not believe how simple RMAN is once you start using it... Lisa Koivu Oracle Database TANK Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Gene Sais [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Subject: RE: archive log curr v. switch logfile I use Alter system archive log current. If your archiver process is caught up, you will get this error message when issuing Alter system archive log all: SQL alter system archive log all; alter system archive log all * ERROR at line 1: ORA-00271: there are no logs that need archiving Just don't like error messages in the logs :). Lisa's method seems the safest, but never had an archiver not keeping up and if I did, that would be an issue to be resolved quickly. Here's my hot backup model with help from list members and Velpuri/Adkoli's Backup/Recovery Book: # 1) Alter system archive log current ; # 2) Check backup status. # 3) Generate datafile listing. # 4) Alter tablespace tablespace_name begin backup ; # 5) Some other process,script,legato,etc. will copy database files # to disk or to tape. # 6) Alter tablespace tablespace_name end backup ; # 7) Backup controlfile. # 8) Alter system archive log current ; # Archives are backed up separately 2 x day to tape. Gene PS. Confident w/ hot backups, next to conquer RMAN cautiously. [EMAIL PROTECTED] 03/29/02 12:13PM Actually I use alter system archive log all. I saw that if the database was behind with archiving, this would ensure that all logs were written to the arc destination. archive log current only did the most recent. Am I wrong? Please correct me if I am . Lisa Koivu Oracle Database Baby Oven Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Post, Ethan [SMTP:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 11:48 AM To: Multiple recipients of list ORACLE-L Subject:RE: archive log curr v. switch logfile I believe alter system archive log current will wait until archiver has successfully archived the file, thus this is the one you would want to use in any backup scripts. - Ethan -Original Message- Sent: Friday, March 29, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Can anyone tell me the difference between alter system archive log current and alter system switch logfile (Seems they both perform checkpoint and both switch a log file). Is one preferred over the other for purposes of switching log files prior to applying to a standby database? Thanks for any insights. Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara 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: Post, Ethan 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network
Re: archive log curr v. switch logfile
Will alter system archive log current work, if the database is not in archive mode? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 29, 2002 11:23 AM Can anyone tell me the difference between alter system archive log current and alter system switch logfile (Seems they both perform checkpoint and both switch a log file). Is one preferred over the other for purposes of switching log files prior to applying to a standby database? Thanks for any insights. Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara 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: archive log curr v. switch logfile
Actually I use alter system archive log all. I saw that if the database was behind with archiving, this would ensure that all logs were written to the arc destination. archive log current only did the most recent. Am I wrong? Please correct me if I am . Lisa Koivu Oracle Database Baby Oven Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Post, Ethan [SMTP:[EMAIL PROTECTED]] Sent: Friday, March 29, 2002 11:48 AM To: Multiple recipients of list ORACLE-L Subject: RE: archive log curr v. switch logfile I believe alter system archive log current will wait until archiver has successfully archived the file, thus this is the one you would want to use in any backup scripts. - Ethan -Original Message- Sent: Friday, March 29, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Can anyone tell me the difference between alter system archive log current and alter system switch logfile (Seems they both perform checkpoint and both switch a log file). Is one preferred over the other for purposes of switching log files prior to applying to a standby database? Thanks for any insights. Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara 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: Post, Ethan 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: archive log curr v. switch logfile
I believe alter system archive log current will wait until archiver has successfully archived the file, thus this is the one you would want to use in any backup scripts. - Ethan -Original Message- Sent: Friday, March 29, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Can anyone tell me the difference between alter system archive log current and alter system switch logfile (Seems they both perform checkpoint and both switch a log file). Is one preferred over the other for purposes of switching log files prior to applying to a standby database? Thanks for any insights. Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara 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: Post, Ethan 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 curr v. switch logfile
SQL alter system archive log current; alter system archive log current * ERROR at line 1: ORA-00258: manual archiving in NOARCHIVELOG mode must identify log 1* alter system archive log current to '/tmp/dummy.log' SQL / alter system archive log current to '/tmp/dummy.log' * ERROR at line 1: ORA-00258: manual archiving in NOARCHIVELOG mode must identify log SQL !oerr ora 258 00258, 0, manual archiving in NOARCHIVELOG mode must identify log // *Cause: The database is in NOARCHIVELOG mode and a command to manually // archive a log did not specify the log explicitly by sequence // number, group number or filename. // *Action: Specify log by filename, by group number or by thread and // sequence number. SQL select * from v$log; #:-) GROUP#THREAD# SEQUENCE# BYTESMEMBERS ARC STATUS -- -- -- -- -- --- FIRST_CHANGE# FIRST_TIM - - 4 1 9006 67108864 1 NO CURRENT 1262712302 29-MAR-02 5 1 9004 67108864 1 YES INACTIVE 1262692183 29-MAR-02 6 1 9005 67108864 1 YES INACTIVE 1262692291 29-MAR-02 SQL alter system archive log group 4 to '/tmp/dummy.log'; alter system archive log group 4 to '/tmp/dummy.log' * ERROR at line 1: ORA-00259: log 4 of open thread 1 is the current log, cannot archive ORA-00312: online log 4 thread 1: '/db02/oracle/oradata/CCC/redo04.log' SQL alter system archive log group 5 to '/tmp/dummy.log'; alter system archive log group 5 to '/tmp/dummy.log' * ERROR at line 1: ORA-16013: log 5 sequence# 9004 does not need archiving ORA-00312: online log 5 thread 1: '/db02/oracle/oradata/CCC/redo05.log' Igor Neyman wrote: Will alter system archive log current work, if the database is not in archive mode? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 29, 2002 11:23 AM Can anyone tell me the difference between alter system archive log current and alter system switch logfile (Seems they both perform checkpoint and both switch a log file). Is one preferred over the other for purposes of switching log files prior to applying to a standby database? Thanks for any insights. Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara 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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Lead, follow, or at least have the courtesy to get out of my way! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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 curr v. switch logfile
No, actually it does not. I just tried it on a db with archive turned off and got an error message (ORA-00258: manual archiving in NOARCHIVELOG mode must identify log). Good point. Thanks. -- From: Igor Neyman[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Friday, March 29, 2002 9:48 AM To: Multiple recipients of list ORACLE-L Subject: Re: archive log curr v. switch logfile Will alter system archive log current work, if the database is not in archive mode? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 29, 2002 11:23 AM Can anyone tell me the difference between alter system archive log current and alter system switch logfile (Seems they both perform checkpoint and both switch a log file). Is one preferred over the other for purposes of switching log files prior to applying to a standby database? Thanks for any insights. Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara 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 curr v. switch logfile
The 'ALTER SYSTEM ARCHIVELOG CURRENT' is the preferred one that should be used for backup scripts. The reason being, if you have noticed when you do an 'ALTER SYSTEM SWITCH LOGFILE', you get the prompt back immediately. This command performs a database checkpoint, switches to the next log, signals the archiver to copy the logfile to the archive destination, and returns the prompt. Mind you, this command does not wait for the archive to complete. As the command indicates, it only performs a log switch. Hence, you might come across backup scripts which does an 'ALTER SYSTEM SWITCH LOGFILE' and then does a SLEEP for some time, thus allocating some time for the Archiver to finish archiving. Whereas, an 'ALTER SYSTEM ARCHIVE LOG CURRENT' does all of the above, but does not return back to the prompt until the archive is complete. Also, 'ALTER SYSTEM SWITCH LOGFILE' archives only the current thread. Whereas the 'ALTER SYSTEM ARCHIVELOG CURRENT' needs a thread to be specified and If you miss the thread parameter, Oracle archives all redo log file groups from all enabled threads, including logs previous to current logs. Hope this helps. Raj Baker, Barbara bbaker@denvernewspaperaTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] gency.com cc: Sent by:Subject: archive log curr v. switch logfile [EMAIL PROTECTED] March 29, 2002 11:23 AM Please respond to ORACLE-L Can anyone tell me the difference between alter system archive log current and alter system switch logfile (Seems they both perform checkpoint and both switch a log file). Is one preferred over the other for purposes of switching log files prior to applying to a standby database? Thanks for any insights. Barb -- 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: archive log curr v. switch logfile
That's exactly, what I meant (besides the fact, that alter system archive log current will return only after Archiver is done archiving current log). Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 29, 2002 12:48 PM SQL alter system archive log current; alter system archive log current * ERROR at line 1: ORA-00258: manual archiving in NOARCHIVELOG mode must identify log 1* alter system archive log current to '/tmp/dummy.log' SQL / alter system archive log current to '/tmp/dummy.log' * ERROR at line 1: ORA-00258: manual archiving in NOARCHIVELOG mode must identify log SQL !oerr ora 258 00258, 0, manual archiving in NOARCHIVELOG mode must identify log // *Cause: The database is in NOARCHIVELOG mode and a command to manually // archive a log did not specify the log explicitly by sequence // number, group number or filename. // *Action: Specify log by filename, by group number or by thread and // sequence number. SQL select * from v$log; #:-) GROUP#THREAD# SEQUENCE# BYTESMEMBERS ARC STATUS -- -- -- -- -- --- --- - FIRST_CHANGE# FIRST_TIM - - 4 1 9006 67108864 1 NO CURRENT 1262712302 29-MAR-02 5 1 9004 67108864 1 YES INACTIVE 1262692183 29-MAR-02 6 1 9005 67108864 1 YES INACTIVE 1262692291 29-MAR-02 SQL alter system archive log group 4 to '/tmp/dummy.log'; alter system archive log group 4 to '/tmp/dummy.log' * ERROR at line 1: ORA-00259: log 4 of open thread 1 is the current log, cannot archive ORA-00312: online log 4 thread 1: '/db02/oracle/oradata/CCC/redo04.log' SQL alter system archive log group 5 to '/tmp/dummy.log'; alter system archive log group 5 to '/tmp/dummy.log' * ERROR at line 1: ORA-16013: log 5 sequence# 9004 does not need archiving ORA-00312: online log 5 thread 1: '/db02/oracle/oradata/CCC/redo05.log' Igor Neyman wrote: Will alter system archive log current work, if the database is not in archive mode? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 29, 2002 11:23 AM Can anyone tell me the difference between alter system archive log current and alter system switch logfile (Seems they both perform checkpoint and both switch a log file). Is one preferred over the other for purposes of switching log files prior to applying to a standby database? Thanks for any insights. Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara 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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Lead, follow, or at least have the courtesy to get out of my way! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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
