Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: From noarchive log to archive log mode
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C02278.7B3D1256
Content-Type: text/plain;
charset="iso-8859-1"
do you have this entry in init.ora file?
log_archive_start = true
-----Original Message-----
From: David Barbour [mailto:DBarbour_at_connectsouth.com]
Sent: Tuesday, September 19, 2000 3:17 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: From noarchive log to archive log mode
Ken,
Try:
ALTER SYSTEM ARCHIVE LOG START;
David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com
-----Original Message-----
Sent: Tuesday, September 19, 2000 12:10 PM
To: Multiple recipients of list ORACLE-L
Hi friends,
I had have DB running on noarchive log mode. I modified the init.ora parameters to running it on archive log mode. This is what I do in init.ora:
log_archive_start = true log_archive_dest = /raid5/opt/oracle/admin/cash/arch log_archive_format = cash-arch%S.arc
And I started the DB with these commands:
SVRMGR> startup mount SVRMGR> alter database archivelog; SVRMGR> alter database open;
But on I ran the command :
SVRMGR> archive log list;
I found :
Database log mode Archive Mode Automatic archival Disabled Archive destination ?/dbs/arch Oldest online log sequence 299 Next log sequence to archive 302 Current log sequence 302
SVRMGR> alter database archive log start to SVRMGR> '/raid5/opt/oracle/admin/cash/arch'; SVRMGR>
If I restart de DB I run into the same error!
May be some thing it's wrong in init.ora but I cannot see what's.
Thank you in advance for your help.
Kader
-- Author: Kader Ben INET: kaderb_at_yahoo.com 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: ListGuru_at_fatcity.com (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). -- Author: David Barbour INET: DBarbour_at_connectsouth.com 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: ListGuru_at_fatcity.com (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). ------_=_NextPart_001_01C02278.7B3D1256 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printableReceived on Tue Sep 19 2000 - 15:30:42 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: From noarchive log to archive log mode</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>do you have this entry in init.ora file?</FONT>
</P>
<P><FONT SIZE=3D2>log_archive_start =3D true </FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: David Barbour [<A =
HREF=3D"mailto:DBarbour_at_connectsouth.com">mailto:DBarbour_at_connectsouth.c= om</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, September 19, 2000 3:17 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: RE: From noarchive log to archive log =
mode</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Ken,</FONT>
<BR><FONT SIZE=3D2>Try:</FONT>
</P>
<P> <FONT SIZE=3D2>ALTER =
SYSTEM ARCHIVE LOG START;</FONT>
</P>
<P><FONT SIZE=3D2>David A. Barbour</FONT>
<BR><FONT SIZE=3D2>Oracle DBA - ConnectSouth</FONT>
<BR><FONT SIZE=3D2>512-681-9438</FONT>
<BR><FONT SIZE=3D2>dbarbour_at_connectsouth.com</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, September 19, 2000 12:10 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hi friends,</FONT>
</P>
<P><FONT SIZE=3D2> I had have DB running on noarchive log mode. =
I</FONT>
<BR><FONT SIZE=3D2>modified the init.ora parameters to running it =
on</FONT>
<BR><FONT SIZE=3D2>archive log mode. This is what I do in =
init.ora:</FONT>
<BR><FONT SIZE=3D2>log_archive_start =3D true</FONT>
<BR><FONT SIZE=3D2>log_archive_dest =3D =
/raid5/opt/oracle/admin/cash/arch</FONT>
<BR><FONT SIZE=3D2>log_archive_format =3D cash-arch%S.arc</FONT>
</P>
<P><FONT SIZE=3D2>And I started the DB with these commands:</FONT>
<BR><FONT SIZE=3D2>SVRMGR> startup mount</FONT>
<BR><FONT SIZE=3D2>SVRMGR> alter database archivelog;</FONT>
<BR><FONT SIZE=3D2>SVRMGR> alter database open;</FONT>
</P>
<P><FONT SIZE=3D2>But on I ran the command :</FONT>
</P>
<P><FONT SIZE=3D2>SVRMGR> archive log list;</FONT>
<BR><FONT SIZE=3D2>I found :</FONT>
</P>
<P><FONT SIZE=3D2>Database log =
mode = Archive Mode</FONT>
<BR><FONT SIZE=3D2>Automatic =
archival = Disabled</FONT>
<BR><FONT SIZE=3D2>Archive =
destination = ?/dbs/arch </FONT>
<BR><FONT SIZE=3D2>Oldest online log sequence =
299</FONT>
<BR><FONT SIZE=3D2>Next log sequence to archive 302</FONT>
<BR><FONT SIZE=3D2>Current log =
sequence = 302</FONT>
<BR><FONT SIZE=3D2>SVRMGR></FONT>
</P>
<P><FONT SIZE=3D2>After that I did :</FONT>
<BR><FONT SIZE=3D2>SVRMGR> alter database archive log start to =
</FONT>
<BR><FONT SIZE=3D2>SVRMGR> =
'/raid5/opt/oracle/admin/cash/arch';</FONT>
<BR><FONT SIZE=3D2>SVRMGR></FONT>
</P>
<P><FONT SIZE=3D2>If I restart de DB I run into the same error!</FONT>
</P>
<P><FONT SIZE=3D2>May be some thing it's wrong in init.ora but I =
cannot</FONT>
<BR><FONT SIZE=3D2>see what's.</FONT>
</P>
<P><FONT SIZE=3D2>Thank you in advance for your help.</FONT>
</P>
<P><FONT SIZE=3D2>Kader</FONT>
</P>
<BR>
<BR>
<P><FONT =
SIZE=3D2>__________________________________________________</FONT>
<BR><FONT SIZE=3D2>Do You Yahoo!?</FONT>
<BR><FONT SIZE=3D2>Send instant messages & get email alerts with =
Yahoo! Messenger.</FONT>
<BR><FONT SIZE=3D2><A HREF=3D"http://im.yahoo.com/" =
TARGET=3D"_blank">http://im.yahoo.com/</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Kader Ben</FONT>
<BR><FONT SIZE=3D2> INET: kaderb_at_yahoo.com</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from). You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =
(like subscribing).</FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: David Barbour</FONT>
<BR><FONT SIZE=3D2> INET: DBarbour_at_connectsouth.com</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
![]() |
![]() |