Re: Turn on Archivelog mode..

Thanks Norman. Sorry about the email address, but there is no way I want to use my real one on a newsgroup (spam) and I think the email address pretty much sums up my contempt for Yahoo :)

I have edited my .ora file and pasted those lines in, but I though that just enables automatic archiving and the documenation seems to show that this is actually completely different changing ARCHIVELOG mode. Excuse my ignorance, but are they two things (enabling ARCHIVELOG, and enabling automatic archive) actually the same?

Also, do I actually have to run the stuff in SQLPlus? Can't I just configure the .ORA file and bounce the box? :)

Thanks, I will give all your suggestions a shot.

Cheers

Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote in message news:<E2F6A70FE45242488C865C3BC1245DA703396D97_at_lnewton.leeds.lfs.co.uk>...
> With an email address of 'load of crap' you may find replies not
> forthcoming :o)
>
> To turn on Archive logging there are a couiple of steps :
>
> shutdown
> edit the init<SID>.ora file and set
>
> log_archivedest to where you want your logs to go,
> log_archive_format to the filename format you want
> log_archive_start to true
>
> (you may need to uncomment these if they have a '#' in front)
>
> That's stage one done. Now run the following :
>
> sqlplus /nolog
> connect / as sysdba
> startup mount
> alter database archivelog;
>
> alter database open;
> archive log list
>
> Now you should see the state of your database as something like the
> following :
>
> Database log mode Archive Mode
> Automatic archival Enabled
> Archive destination /archivelogs/<MYSID>/
> Oldest online log sequence 354
> Next log sequence to archive 355
> Current log sequence 355
>
> The first one shows the result of the alter database archivelog, while
> the second shows that the ARCH process is running thanks to the
> log_archive_start setting.
>
> Cheers,
> Norman.
>
> PS. I assume your email name is one you use of the SQL Server newsgroups
> and you just forgot to change it :o)
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
>
> -----Original Message-----
> From: loadofcr_ap_at_yahoo.com (gOD) [mailto:loadofcr_ap_at_yahoo.com]
> Posted At: Monday, January 27, 2003 9:23 AM
> Posted To: server
> Conversation: Turn on Archivelog mode..
> Subject: Turn on Archivelog mode..
>
>
> I am running Oracle 817 EE, on NT.
>
> No manuals, no experience, and I can't find any online documentation
> (if anyone know where there is an online admin guide please let me
> know, I found http://otn.oracle.com/documentation/oracle8i.html but
> there is not an admin guide as such that I can see).
>
> I need to turn on archiveog mode, and can't figure out how. The
> documentation (or lack of) supplied with my backup product
> (arcserve2k) says I can type ARCHIVE LOG LIST to give me the status,
> and then a list of commands starting with CONNECT INTERNAL to change
> it..
>
> As you can see below, it hasn't worked.. Can anyone give me a little
> more info?
>
>
> ************************************************************************
> **
> SQL*Plus: Release 8.0.5.0.0 - Production on Mon Jan 27 9:0:56 2003
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
>
> SQL> ARCHIVE LOG LIST
> unknown command beginning "ARCHIVE LO..." - rest of line ignored.
> SQL> CONNECT INTERNAL
> ERROR:
> ORA-12203: TNS:unable to connect to destination
>
>
> Warning: You are no longer connected to ORACLE.
> SQL>
>
> ************************************************************************
> **
Received on Mon Jan 27 2003 - 08:49:36 CST