RE: From noarchive log to archive log mode

From: David Barbour <DBarbour_at_connectsouth.com>
Date: Tue, 19 Sep 2000 13:11:17 -0500
Message-Id: <10624.117373@fatcity.com>

Ken,
Try:

ALTER SYSTEM ARCHIVE LOG START; David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----
From: Kader Ben [mailto:kaderb_at_yahoo.com] Sent: Tuesday, September 19, 2000 12:10 PM To: Multiple recipients of list ORACLE-L 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 - 13:11:17 CDT