Re: Archivelog

From: Kimberly Smith <KSMITH1_at_gmd.fujitsu.com>
Date: 06 Jun 2000 08:37:52 -0700
Message-Id: <10520.107899@fatcity.com>

--=_ORCL_6414354_0r0

Content-Type:text/plain; charset="iso-8859-1" Content-Transfer-Encoding:quoted-printable

Looking at his statement it looks like archiving is on. There are a couple of things to try. Maybe there really shouldn't be any archives yet. In other
words you haven't modified enough data to fill out a log yet. Force a switc= h
on your logs and see what happens.

Another thing is that in different versions of Oracle on different operating systems part of the destination actually becomes part of the format. So in you case check the oradata4/dbs_prod/dbarchlog directory. It will sometimes take that last part and use it as a prefix to the file name. If this is you= r
case you can force it to the proper directory by putting a '/' at the end of the directory name.

Kimberly Smith
EDS/Fujitsu
Gresham, Oregon
Work: 503-669-6050
Email: kimberly.smith_at_gmd.fujitsu.com

kimberly.smith_at_eds.com

--=_ORCL_6414354_0r0

content-type:message/rfc822

Date: 06 Jun 2000 04:39:14
From:"Gurgaon, DBA (CAP, GECSI, CONTRACTOR)" <DBA.Gurgaon_at_geind.GE.com> To:Multiple recipients of list ORACLE-L <ORACLE-L> Subject:RE: Archivelog
Reply-to:UNIX.IOGMD:ORACLE-L_at_fatcity.com Return-Path:root_at_fatcity.cts.com

Message-ID:<F001.001720DF.20000606033914_at_fatcity.com> X-Comment:Oracle RDBMS Community Forum
X-Sender:"Gurgaon, DBA (CAP, GECSI, CONTRACTOR)" <DBA.Gurgaon_at_geind.GE.com> Sender:root_at_fatcity.com
Errors-To:ML-ERRORS_at_fatcity.com
Organization:Fat City Network Services, San Diego, California X-ListServer:v1.0f, build 69; ListGuru (c) 1996-2000 Bruce A. Bergman Precedence: bulk
MIME-Version: 1.0
Content-Type:text/plain; charset=iso-8859-1 Content-Transfer-Encoding:7bit

Check the parameters
log_archive_start=true
log_archive_dest=/oradata4/dbs_prod/dbarchlog/arch

are set and enabled in your init<sid>.ora file

then from your svrmgr prompt

svrmgr>connect internal
svrmgr>startup mount
svrmgr> alter database archivelog
svrmgr> archive log start
svrmgr> alter database open

This will make your archiving on

Vikas

-----Original Message-----
Sent: Tuesday, June 06, 2000 3:25 PM
To: Multiple recipients of list ORACLE-L

Maybe a silly thing I am missing here, but a bit inexperienced with this all :

Looking at the log_mode in sys.v$database it says ARCHIVELOG

When I do Archive log list i get the following :

SVRMGR> archive log list;

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /oradata4/dbs_prod/dbarchlog/arch
Oldest online log sequence     60178
Next log sequence to archive   60182
Current log sequence           60182

So I go to Archive Destination directory and find the dir to be empty?

What am I missing ?

Thnx for any advise !

Greets,

Kirsten

-- 
Author: Weerd de E.C. Kirsten
  INET: Kirsten.deWeerd_at_Oranjewoud.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Author: Gurgaon, DBA (CAP, GECSI, CONTRACTOR)
  INET: DBA.Gurgaon_at_geind.GE.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



--=_ORCL_6414354_0r0--




------------------------------

 From: Bruce Bergman <bbergman_at_BridgeMedical.com>
 Date: Tue, 6 Jun 2000 08:38:02 -0700 
 Subject: Re: Mailing List

Vipul,

The mailing list you mentioned is for Developer 2000 topics, hence the name
"-DEV2K".  Perhaps you meant to tell Pallav of the more appropriate mailing
list named ODTUG-SQLPLUS-L, which covers PL/SQL in addition to SQL*Plus
topics.

Also, you cannot join a mailing list by sending mail to the list itself.
All that happens is that your message is rejected and returned to you.  The
correct instruction to join a mailing list is send an E-mail to:

    ListGuru_at_fatcity.com

And in the message BODY, put:

    SUB ODTUG-SQLPLUS-L Pallav Kalva

That will get you on the list.  Vipul, please check your facts before
posting incorrect information, as it causes a lot of people to get confused
and ultimately ask me for help anyhow.

thanks,
bruce
ListMaster_at_fatcity.com


-------Original Message----------

 From: Vipul Mukund Shah <vipul.shah_at_almarai.com>
 Date: Tue, 6 Jun 2000 08:25:48 +0300 
 Subject: RE: Mailing List

Hi Pallav

send a subscription mail to ODTUG-DEV2K-L_at_fatcity.com
<mailto:ODTUG-DEV2K-L_at_fatcity.com> 

Regards,
VMS

	-----Original Message-----
	From:	Pallav Kalva [SMTP:pallav_at_starmedia.net]
	Sent:	Tuesday, June 06, 2000 12:58 AM
	To:	Multiple recipients of list ORACLE-L
	Subject:	Mailing List

	Hi, 

	   Does anyone know any good mailing lists for Oracle PL/SQL
developers ??
	If so, can you please send me the url.

	Thanks!
	Pallav


------------------------------

 From: "Deshpande, Kirti" <Kirti.Deshpande_at_gtedc.gte.com>
 Date: Tue, 6 Jun 2000 10:39:42 -0500 
 Subject: RE: Cloning Oracle8i

I am using Transporatable Tablespaces to share/copy data between two
test/development databases with success. We would soon begin using it in
Production dataabses as well. However, I have not yet tried to clone the
entire database in this way. May be it is a good idea. But I haven't found a
need to do it that way.  
 
- Kirti 

> -----Original Message-----
> From:	Anthony Keller [SMTP:akeller_at_sctcorp.com]
> Sent:	Tuesday, June 06, 2000 10:10 AM
> To:	Multiple recipients of list ORACLE-L
> Subject:	Cloning Oracle8i
> 
> Hi,
> 
> I got only one response to my previous question about using the new

Received on Tue Jun 06 2000 - 10:37:52 CDT