Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> From noarchive log to archive log mode

From noarchive log to archive log mode

From: Kader Ben <kaderb_at_yahoo.com>
Date: Tue, 19 Sep 2000 09:09:30 -0700 (PDT)
Message-Id: <10624.117359@fatcity.com>


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. Received on Tue Sep 19 2000 - 11:09:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US