Re: Names of Archive files!

"James" <james_at_nothing.com> wrote in message news:<1045597262.691549_at_ftp.adept.co.za>...
> Hi there
> Can someone please tell me what the names of the archive redo log files
> are(full path), and how the names are chosen. I have searched the
> documentation but am battling to find the names.
>
> Or can some one point me in the direction of the document .
>
> Thanks in advance
> James

James,

   for the path, you would specify it in log_archive_dest     

       log_archive_dest = d:\oracle\ordata\dbname\archive\

 ... for example.

   For the name, you would use log_archive_format. I usually use something like:

      log_archive_format = dbname_%.arc

  ... so I get dbname_1.arc, dbname_2.arc, etc.

   As for your system, I would check the init.ora. A couple of places you might check would be (assuming version 8i)

     d:\oracle\ora81\database ...   

  or the database directory..

    d:\oracle\oradata\dbanme\

   Thats where mine seem to end up when I first install db.

  hope this helps. Received on Wed Feb 19 2003 - 05:33:17 CET