Re: From noarchive log to archive log mode

Thanks a lot Dinesh for your prompt reply.   I resolved the problem as advice by Ron. I had the same parameter : log_archive_start = true mentioned both in config and init.ora files.

Thanks again Deinesh,

Kader   

• DINESH SINGH <dsingh_at_newworldapps.com> wrote:
  > Hello Kadar
  > Did you check whether
  > /raid5/opt/oracle/admin/cash/arch directory exist or
  > not.If not please create such directory.After that
  > please follow following
  > steps
  > SVRMGR> connect internal;
  > SVRMGR> startup mount
  > SVRMGR> alter database archivelog;
  > SVRMGR> alter database open;
  > SVRMGR> alter database archive log start ;
  > HOPE YOU WILL get solution.
  > thanks
  >
  > Dinesh
  > Oracle DBA
  > Virginia.
  >
  > ----- Original Message -----
  > To: "Multiple recipients of list ORACLE-L"
  > <ORACLE-L_at_fatcity.com>
  > Sent: Tuesday, September 19, 2000 10:10 AM
  >
  >
  > > 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>
  > >
  > > After that I did :
  > > 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
  > >
  > >
  > >
  > > __________________________________________________
  > > Do You Yahoo!?
  > > Send instant messages & get email alerts with
  > Yahoo! Messenger.
  > > http://im.yahoo.com/
  > > --
  > > 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: DINESH SINGH
  > INET: dsingh_at_newworldapps.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).
  

  ---