On Mon, 7 Jun 1999, Shiva Maran wrote:

> Hi all,
> 
> I am working on Oracle 7.3.3.0. 
> My setting in the init.ORA is
> log_archive_start = true
> log_archive_dest = e:\tb1_arch
> log_archive_format = arch%s.arc
> In the table v_$log_history I find that the archive files have been
> created. 
> One line from this table :
>         1       305 06/03/99 13:40:08           8419         8421
> e:\tb1_arch\arch305.arc
> But when I see in the specified directory I do not find this file. 
> Where has the file gone??!!
> Oracle is installed on Wintows NT 4.0
> 
> Regards,
> Shiva
> 

Shiva,

You may not be in Archivelog Mode. Even though your
"log_archive_start=TRUE", the database has to be set (just once after its
creation) to be in ARCHIVE mode.

To find out your status, issue:

SELECT LOG_MODE FROM V$DATABASE;

The result will either be "ARCHIVELOG" or "NOARCHIVELOG".
If you are in "NOARCHIVELOG" and wish to change this, do the following:

1) Shut down your database (if possible back up your database now).
2) Start up the database in MOUNT mode (do not open it)
3) Issue "ALTER DATABASE ARCHIVELOG"
4) Open the database: "ALTER DATABASE OPEN"

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 300+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page index.htm"> Back to Ari Kaplan's Home Page