Turn on Archivelog mode..

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 27 Jan 2003 10:05:48 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703396D97@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

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 - 04:05:48 CST