Re: From noarchive log to archive log mode

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 ----- From: "Kader Ben" <kaderb_at_yahoo.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, September 19, 2000 10:10 AM Subject: From noarchive log to archive log mode

> 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
Received on Tue Sep 19 2000 - 15:49:51 CDT