date:20020318


Yes, its basically an insert into SYS.JOB$

hth
connor

 --- John Dunn <[EMAIL PROTECTED]> wrote: > Will
submitting jobs via dbms_jobs result, in
> itself,  in transactions being
> writen to redo logs?
> 
> John
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: John Dunn
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Locally Managed Tablespaces

2002-03-18 Thread antonio . belloni



Hi,

Anyone using LMT for rollback segments ? Any issues , suggestions , ... ?

TIA,
Antonio Belloni

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: dbms_jobs and redo activity

2002-03-18 Thread Igor Neyman


Yes.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 18, 2002 5:43 AM


> Will submitting jobs via dbms_jobs result, in itself,  in transactions
being
> writen to redo logs?
>
> John
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Dunn
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Another partitioning question

2002-03-18 Thread Shaw John-P55297


Thanks for the help.

-Original Message-
Sent: Friday, March 15, 2002 11:28 AM
To: Multiple recipients of list ORACLE-L


John - At last a question I can answer! Anyway I think so.
You can partition on a concatenated key. I just did this on our data
warehouse and brought query times from over 2 minutes to under 10 seconds.
Here is what my partition looks like.

create table sumacctfact2
nologging
pctfree 5
partition by range ( periodgrain, periodenddate )
(
partition sum_fy_01 values less than ('FY', to_date('01011999','mmdd'))
   tablespace data_fy_01
   storage ( maxextents unlimited ),
partition sum_fy_02 values less than ('FY', to_date('01012000','mmdd'))
   tablespace data_fy_02
   storage ( maxextents unlimited ),
partition sum_fy_03 values less than ('FY', to_date('01012001','mmdd'))
   tablespace data_fy_03
   storage ( maxextents unlimited ),
partition sum_fy_04 values less than ('FY', to_date('02012001','mmdd'))
   tablespace data_fy_04
   storage ( maxextents unlimited ),   

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, March 15, 2002 10:38 AM
To: Multiple recipients of list ORACLE-L


I think what my boss is asking me to do is not possible, but since I don't
have much experience with partitioning I thought I'd ask here (I did read
some of manuals but didn't find an answer that suited my conditions). My
boss wants a table partitioned by 2 columns - seq_no and type. If the type =
'X' then it's just a range partition, but then he wants another partition
that contains all data that type!='X' but is inclusive of the entire range.
Is this possible?
Something like (I know this syntax isn't correct )
create table test_part(
id number(11) unique,
owner_id number(11) not null,
type varchar2(30) not null,
name varchar2(40))
partition by range(owner_id,type)
(partition p1 values less than (2000) and type ='X' tablespace test,
partition p2 values less than (5000) and owner_table ='X' tablespace
test,
partition p3 values less than (1) and owner_table ='X' tablespace
test,
partition p4 values less than (5) and owner_table ='X' tablespace
test,
partition p5 values less than (10) and owner_table ='X' tablespace
test)
partition p6 values less that (10) and owner_table !='X' tablespace
test;
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shaw John-P55297
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shaw John-P55297
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Sql loader - schedule

2002-03-18 Thread Roland . Skoldblom


Hallo,

How is it possible to schedule an sql loader script, which is running on network(not 
unix).  Let us say this should run at 6 pm every day.
This sqlloader simply loads a textfile into a table in the database.

Thanks in advance

Roland

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Sql loader - schedule

2002-03-18 Thread אדר יחיאל


Not Unix - I will presume NT.
On NT you can use the AT command to schedule task.
Just type AT at the command prompt.

One more thing: activate the scheduling service.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Mon, March 18, 2002 3:48 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Sql loader - schedule
> 
> Hallo,
> 
> How is it possible to schedule an sql loader script, which is running on
> network(not unix).  Let us say this should run at 6 pm every day.
> This sqlloader simply loads a textfile into a table in the database.
> 
> Thanks in advance
> 
> Roland
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Sql loader - schedule

2002-03-18 Thread Alex

what does running on a network(not unix) mean? any way you can use a
scheduler. There are alot of free ones avaiable.

On Mon, 18 Mar 2002 [EMAIL PROTECTED] wrote:

> Hallo,
> 
> How is it possible to schedule an sql loader script, which is running on network(not 
>unix).  Let us say this should run at 6 pm every day.
> This sqlloader simply loads a textfile into a table in the database.
> 
> Thanks in advance
> 
> Roland
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alex
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Oracle DBA- Solaris System Administrator Needed in Cambridge,

2002-03-18 Thread OraStaff


Cambridge, Massachusetts Biotech company needs an Oracle DBA/Unix System
administrator who
has solid Unix Solaris Systems Administration experience .

This is a staff opportunity... No sub-contractors or third parties please.

* DO NOT send your resume unless you have a stable work history.
  This company will not consider candidates who are consultants
  or anybody who has changed jobs frequently.

NO Sponsorship is available!


Requirements:
-BS degree in Computer Science or related degree.
-Solid Oracle DBA experience.
-4+ yrs as a Unix Solaris Sys Admin-must include Solaris 8.
-1+ years of Shell/Perl. 
-Knowledge of at least part of Veritas suite- Volume Manager, NetBackup etc. 
-Able to handle intranet, mail, extranet.  
-Knowledge of science or lab would be big plus.
-U.S. citizenship or permanent residency is also required.

Base Salary is Open and depends on experience.
Relocation assistance is provided.

For  immediate consideration, please send your resume
as an attachment to:

Email: [EMAIL PROTECTED]
Please use job code: One/Cambridge/DBA-U.Sys Admin/Sondra
Phone: 800-549-8502

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: OraStaff
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Sql loader - schedule

2002-03-18 Thread Ora NT DBA

Hi Roland,

You could do this via the OEM job system.  

Or whatever batch scheduling system exists in your environment

John

[EMAIL PROTECTED] wrote:

>Hallo,
>
>How is it possible to schedule an sql loader script, which is running on network(not 
>unix).  Let us say this should run at 6 pm every day.
>This sqlloader simply loads a textfile into a table in the database.
>
>Thanks in advance
>
>Roland
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ora NT DBA
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE:

2002-03-18 Thread Seefelt, Beth



If you close all the gui applications, is there a jre or jrew process
still running?  You might try killing those completely (that may cause
your oracle management server to abort and it will have to be restarted
manually) and then restarting DBCA.  I don't know about DBCA, but I've
seen similar problems with the other Oracle GUIs and the java runtime
environment.

HTH,

Beth

-Original Message-
Sent: Monday, March 18, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L
Subject: 


I was trying to user the DBCA on the server this weekend and it won't
start. The hourglass comes up and then just disappears.  It has worked
in the past. It throws no error messages, no trace files, writes nothing
to the alert log.  I have 2 instances on this NT4.0 box and everything
appears to be just fine with them and the users.  I am running 8i
8.1.6.0.0.  Does anybody have any idea why it would not start?



David Ehresmann
Oracle DBA 8i OCP
MCI Worldcom
[EMAIL PROTECTED]
972.656.1015

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Ehresmann
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seefelt, Beth
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Oracle9i init.ora file

2002-03-18 Thread Michael Wu


Hi list,

Can someone out there share a Oracle 9i init.ora for a production database
on Sun Solaris?

Thanks,

Mike 



**
This e-mail contains privileged attorney-client communications and/or confidential 
information, and is only for the use by the intended recipient. Receipt by an 
unintended recipient does not constitute a waiver of any applicable privilege."

Reading, disclosure, discussion, dissemination, distribution or copying of this 
information by anyone other than the intended recipient or his or her employees or 
agents is strictly prohibited.  If you have received this communication in error, 
please immediately notify us and delete the original material from your computer."

Sempra Energy Trading Corp. (SET) is not the same company as SDG&E or SoCalGas, the 
utilities owned by SET's parent company.  SET is not regulated by the California 
Public Utilities Commission and you do not have to buy SET's products and services to 
continue to receive quality regulated service from the utilities."
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michael Wu
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend...


A I only knew about it (and tried it) in 8i+... thanks for the
info!!

Rf

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Sunday, March 17, 2002 1:08 PM
To: Multiple recipients of list ORACLE-L


Robert:

I was about to tell that. You hit the reply before me (that too on Sunday!!)

BTW THis method is available from 7.x onwards. TO be precious from 7.3.3


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Robert
Sent: Sunday, March 17, 2002 7:53 AM
To: Multiple recipients of list ORACLE-L


Given this situation (which I face from time to time), you have a couple of
options.

1. You do not open the database to users until AFTER you do a backup (hot or
cold, dosen't mater) at point t2.

2. There is a method of recovering a database (8i +) after RESETLOGS has
been
issued with archived redo logs. I discussed it in my DBA World Tour backup
and
recovery presentation. To do this, you MUST have the control file for the
database from BEFORE the resetlogs operation, and backup of the control file
from AFTER the same operation. I've done this about 3 times in testing and
it works fine but it very very picky about the control file images.

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Friday, March 15, 2002 7:28 PM
To: Multiple recipients of list ORACLE-L


Hi Jared,

> > * You *have* to take a COLD backup of the database after using
> resetlogs.
> > (Not required - a Hot backup and archive logs is adequate. All hot
> backups /
> > archive logs prior to that are invalid, though...)
>
> Consider the following:
>
> Time:
>
> t0: database restored
> t1: database opened with RESETLOGS
> t2: hot backup started ( database in archive log mode )
> t3: users input very important transactions
> t4: database crashes, and must be restored
>
> How will you recover the transactions from time t3?

As long as the online redologs are available, this should be no problem. I
have successfully recovered databases where a log switch did not occur and
recovery had to use an online redo log. (I am assuming that the lost
datafiles will be restored from this hot backup fresh off the tapes)

On the other hand, if the online redolog is hosed you have lost the
transactions anyway, _regardless_ of the fact that a Cold backup was taken.
Then you will have to go back to the _previous_ incarnation and redo the
restore and then perform a ccf/resetlogs (i.e. back to square one). If you
have a Cold backup, you restore the cold backup and go on with life. I.e. in
both cases (availability of cold or hot backup, lost online redo log), you
have lost transactions...

Additionally, with a Hot backup and depending on what was lost, you can at
least perform tablespace/datafile recovery . With a cold backup, you will
have to restore the whole database

The point I was trying to make was that a Cold backup after a RESETLOGS does
not serve anything. Maybe there is still a gotcha I have not been able to
figure out, so Backup/restore Gurus: take a bash at this logic! I would love
to be corrected.

(Btw, the previous recovery scenario was on 7.3.4 - things could have
changed since, and I have not been able to test that out...)


John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Grace - Getting something we don't deserve
Mercy - NOT getting something we deserve

Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!

** The opinions and statements above are entirely my own and not those of my
employer or clients **


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the

RE: Fav. Urban Legend...


And hey, it was Sunday morning at 0700 something... what do you
expect from me anyways??? :-)))

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Sunday, March 17, 2002 6:43 PM
To: Multiple recipients of list ORACLE-L


On Sunday 17 March 2002 07:53, Freeman, Robert  wrote:

> 1. You do not open the database to users until AFTER you do a backup (hot
> or cold, dosen't mater) at point t2.

Well, yeah, that was the point.  It doesn't have to be a cold backup, but 
since you can't do any work, it may as well be a cold backup.

Jared

>
> 2. There is a method of recovering a database (8i +) after RESETLOGS has
> been
> issued with archived redo logs. I discussed it in my DBA World Tour backup
> and
> recovery presentation. To do this, you MUST have the control file for the
> database from BEFORE the resetlogs operation, and backup of the control
> file from AFTER the same operation. I've done this about 3 times in
testing
> and it works fine but it very very picky about the control file images.
>
> RF
>
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
>
> The Cigarette Smoking Man: Anyone who can appease a man's conscience can
> take his freedom away from him.
>
>
>
> -Original Message-
> Sent: Friday, March 15, 2002 7:28 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Jared,
>
> > > * You *have* to take a COLD backup of the database after using
> >
> > resetlogs.
> >
> > > (Not required - a Hot backup and archive logs is adequate. All hot
> >
> > backups /
> >
> > > archive logs prior to that are invalid, though...)
> >
> > Consider the following:
> >
> > Time:
> >
> > t0: database restored
> > t1: database opened with RESETLOGS
> > t2: hot backup started ( database in archive log mode )
> > t3: users input very important transactions
> > t4: database crashes, and must be restored
> >
> > How will you recover the transactions from time t3?
>
> As long as the online redologs are available, this should be no problem. I
> have successfully recovered databases where a log switch did not occur and
> recovery had to use an online redo log. (I am assuming that the lost
> datafiles will be restored from this hot backup fresh off the tapes)
>
> On the other hand, if the online redolog is hosed you have lost the
> transactions anyway, _regardless_ of the fact that a Cold backup was
taken.
> Then you will have to go back to the _previous_ incarnation and redo the
> restore and then perform a ccf/resetlogs (i.e. back to square one). If you
> have a Cold backup, you restore the cold backup and go on with life. I.e.
> in both cases (availability of cold or hot backup, lost online redo log),
> you have lost transactions...
>
> Additionally, with a Hot backup and depending on what was lost, you can at
> least perform tablespace/datafile recovery . With a cold backup, you will
> have to restore the whole database
>
> The point I was trying to make was that a Cold backup after a RESETLOGS
> does not serve anything. Maybe there is still a gotcha I have not been
able
> to figure out, so Backup/restore Gurus: take a bash at this logic! I would
> love to be corrected.
>
> (Btw, the previous recovery scenario was on 7.3.4 - things could have
> changed since, and I have not been able to test that out...)
>
>
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
>
> Grace - Getting something we don't deserve
> Mercy - NOT getting something we deserve
>
> Click on 'http://www.needhim.org' for Grace and Mercy that is freely
> available!
>
> ** The opinions and statements above are entirely my own and not those of
> my employer or clients **
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, incl

RE: Fav. Urban Legend...


Point taken... I assume you mean a cold backup in ARCHIVELOG mode... :-)

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Sunday, March 17, 2002 6:43 PM
To: Multiple recipients of list ORACLE-L


On Sunday 17 March 2002 07:53, Freeman, Robert  wrote:

> 1. You do not open the database to users until AFTER you do a backup (hot
> or cold, dosen't mater) at point t2.

Well, yeah, that was the point.  It doesn't have to be a cold backup, but 
since you can't do any work, it may as well be a cold backup.

Jared

>
> 2. There is a method of recovering a database (8i +) after RESETLOGS has
> been
> issued with archived redo logs. I discussed it in my DBA World Tour backup
> and
> recovery presentation. To do this, you MUST have the control file for the
> database from BEFORE the resetlogs operation, and backup of the control
> file from AFTER the same operation. I've done this about 3 times in
testing
> and it works fine but it very very picky about the control file images.
>
> RF
>
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
>
> The Cigarette Smoking Man: Anyone who can appease a man's conscience can
> take his freedom away from him.
>
>
>
> -Original Message-
> Sent: Friday, March 15, 2002 7:28 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Jared,
>
> > > * You *have* to take a COLD backup of the database after using
> >
> > resetlogs.
> >
> > > (Not required - a Hot backup and archive logs is adequate. All hot
> >
> > backups /
> >
> > > archive logs prior to that are invalid, though...)
> >
> > Consider the following:
> >
> > Time:
> >
> > t0: database restored
> > t1: database opened with RESETLOGS
> > t2: hot backup started ( database in archive log mode )
> > t3: users input very important transactions
> > t4: database crashes, and must be restored
> >
> > How will you recover the transactions from time t3?
>
> As long as the online redologs are available, this should be no problem. I
> have successfully recovered databases where a log switch did not occur and
> recovery had to use an online redo log. (I am assuming that the lost
> datafiles will be restored from this hot backup fresh off the tapes)
>
> On the other hand, if the online redolog is hosed you have lost the
> transactions anyway, _regardless_ of the fact that a Cold backup was
taken.
> Then you will have to go back to the _previous_ incarnation and redo the
> restore and then perform a ccf/resetlogs (i.e. back to square one). If you
> have a Cold backup, you restore the cold backup and go on with life. I.e.
> in both cases (availability of cold or hot backup, lost online redo log),
> you have lost transactions...
>
> Additionally, with a Hot backup and depending on what was lost, you can at
> least perform tablespace/datafile recovery . With a cold backup, you will
> have to restore the whole database
>
> The point I was trying to make was that a Cold backup after a RESETLOGS
> does not serve anything. Maybe there is still a gotcha I have not been
able
> to figure out, so Backup/restore Gurus: take a bash at this logic! I would
> love to be corrected.
>
> (Btw, the previous recovery scenario was on 7.3.4 - things could have
> changed since, and I have not been able to test that out...)
>
>
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
>
> Grace - Getting something we don't deserve
> Mercy - NOT getting something we deserve
>
> Click on 'http://www.needhim.org' for Grace and Mercy that is freely
> available!
>
> ** The opinions and statements above are entirely my own and not those of
> my employer or clients **
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB OR

Re: Locally Managed Tablespaces


Yes  - on 8i and 9i.

There were a couple of issues under 8i, where you
needed to have an additional rollback segment in a
non-LMT (ie SYSTEM) in order to create lmt rollback
tspaces and segments, but other than that, there have
been no problems so far.

hth
connor

 --- [EMAIL PROTECTED] wrote: > 
> Hi,
> 
> Anyone using LMT for rollback segments ? Any issues
> , suggestions , ... ?
> 
> TIA,
> Antonio Belloni
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Excel to Oracle

2002-03-18 Thread Rick_Cale


Hi All,

What is the best/quickest way to move data from excel to Oracle?

Thanks
Rick


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Locally Managed Tablespaces

2002-03-18 Thread Jack C. Applewhite


Antonio,

We use LMTs for all tablespaces - except for System, of course.  No issues,
problems, etc.  We're happy.

8.1.7.2.5 on Win2k; ~340GB in 29 tablespaces.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
[EMAIL PROTECTED]
Sent: Monday, March 18, 2002 7:28 AM
To: Multiple recipients of list ORACLE-L



Hi,

Anyone using LMT for rollback segments ? Any issues , suggestions , ... ?

TIA,
Antonio Belloni



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Oracle vs. MS SQL EE vs. SE


I have been asked to compare Oracle and Microsoft SQL Server. I notice that
Microsoft has introduced Standard Edition and Enterprise Edition versions.
Can anyone point me to resources that will help me compare these versions
with Oracle versions?
My impression is that Oracle introduced SE as a way to have something
equivalent to MS SQL. Now I am concerned that MS is trying to have SE and EE
versions to show equivalence to Oracle. But I need some evidence to
demonstrate this.
Any assistance will be appreciated.
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Another partitioning question part 2

2002-03-18 Thread Shaw John-P55297


I tried the partition by range feature and didn't get the results I
expected. It seemed to ignore the second key when inserting data.
create table test_part(
id number(11) ,
owner_id number(11) not null,
owner varchar2(30) not null,
street varchar2(40))
partition by range(owner,owner_id )
(
partition p5 values less than ('V',99) tablespace test,
partition p1 values less than ('W',2000) tablespace test,
 partition p2 values less than ('W',5000) tablespace test,
 partition p3 values less than ('W',1) tablespace test,
 partition p4 values less than ('W',5) tablespace test,
 partition p6 values less than ('W',9) tablespace test,
 partition p7 values less than (maxvalue,9) tablespace test
);
What I am trying to accomplish is to get all values less than 'V' into one
partion , all values = 'V' into 5 partitions by numeric range , and all
owner values greater that 'V' into the last partition. 
It is sorting correctly one the first value 'owner' but is ignoring the
second range value when inserting records into the table, all owner_id
reanges are just going into the first partition. Anybody tell me what I did
wrong - or maybe the book and chapter. 
8.1.6 on NT

-Original Message-
Sent: Friday, March 15, 2002 2:48 PM
To: Multiple recipients of list ORACLE-L


Kirti - If I can humbly beg to differ. I assumed that it would work the way
you described. However, I conducted some tests and found to my surprise that
it seems to base decisions on the right-most column (although I only tested
two columns). Therefore, to use your examples, 

P1 -- values less than ('X', 99) will contain values where column1 = 'X'
and column2 less than 99
P2 -- values less than ('Y', 99) will contain values where column1 = 'Y'
and column2 less than 99.

Since my column1 only has two values, I didn't test what it does with
"unlimited" in the first column.
 I'm not saying that didn't miss something. My ulterior motive for
responding on the list is that I frequently get some fuzzy ideas clarified
by others on the list.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, March 15, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L


If I understood the original question correctly, with the given conditions
there will be three partitions. Oracle evaluates concatenated key from left
to right order, so if the type and seq number are the partitioning columns
here then the partitions would be:  
P1 -- values less than ('X', 99) This will contain everything where type
< X 
P2 -- values less then ('Y', 99) This will contain everything where type
= X
P3 -- values less then (MAXVALUE, MAXVALUE) This will contain everything
else.  I am using 99 to denote the highest value for the seq number. 

Any other ideas? 

- Kirti 



-Original Message-
Sent: Friday, March 15, 2002 11:28 AM
To: Multiple recipients of list ORACLE-L


John - At last a question I can answer! Anyway I think so.
You can partition on a concatenated key. I just did this on our data
warehouse and brought query times from over 2 minutes to under 10 seconds.
Here is what my partition looks like.

create table sumacctfact2
nologging
pctfree 5
partition by range ( periodgrain, periodenddate )
(
partition sum_fy_01 values less than ('FY', to_date('01011999','mmdd'))
   tablespace data_fy_01
   storage ( maxextents unlimited ),
partition sum_fy_02 values less than ('FY', to_date('01012000','mmdd'))
   tablespace data_fy_02
   storage ( maxextents unlimited ),
partition sum_fy_03 values less than ('FY', to_date('01012001','mmdd'))
   tablespace data_fy_03
   storage ( maxextents unlimited ),
partition sum_fy_04 values less than ('FY', to_date('02012001','mmdd'))
   tablespace data_fy_04
   storage ( maxextents unlimited ),   

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, March 15, 2002 10:38 AM
To: Multiple recipients of list ORACLE-L


I think what my boss is asking me to do is not possible, but since I don't
have much experience with partitioning I thought I'd ask here (I did read
some of manuals but didn't find an answer that suited my conditions). My
boss wants a table partitioned by 2 columns - seq_no and type. If the type =
'X' then it's just a range partition, but then he wants another partition
that contains all data that type!='X' but is inclusive of the entire range.
Is this possible?
Something like (I know this syntax isn't correct )
create table test_part(
id number(11) unique,
owner_id number(11) not null,
type varchar2(30) not null,
name varchar2(40))
partition by range(owner_id,type)
(partition p1 values less than (2000) and type ='X' tablespace test,
partition p2 values less than (5000) and owner_table ='X' tablespace
test,
partition p3 values less than (1) and owner_table ='X' tablespace
test,
partition p4 values less than (5) and owner_table ='X' tablespace
test,
partition p5

RE: Excel to Oracle

2002-03-18 Thread Oberkofler, Dieter

Title: RE: Excel to Oracle





hi!


i would probably just export the table in a "portable" csv
format and then use the oracle sql*loader to import it into
oracle. simple but it works!


cheers


dieter


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 16:44
To: Multiple recipients of list ORACLE-L
Subject: Excel to Oracle



Hi All,


What is the best/quickest way to move data from excel to Oracle?


Thanks
Rick



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]


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: [EMAIL PROTECTED] (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).

Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELOG mo


Ok maybe you will think this is a silly thread, but I've wondered
about this before...

We (DBA's) use the terms hot and cold backups all the time. I wonder though,
when we talk about cold backups if the terminology should not include the
mode of the backup:

cold archivelog mode backup
cold noarchivelog mode backup

When we say "cold" backup, do we just assume it's NOARCHIVELOG mode...and
enjoy the fact that we don't have to type or say as much...or should we be
more specific to help the junior DBA's (or perhaps even those out there who
have never really considered that there is a distinction between the two)
out there? When books are written, I notice that they mostly just talk about
hot and cold backups, assuming that the cold backup is in NOARCHIVELOG
mode... 

what about the junior DBA who does a cold backup in ARCHIVELOG mode and
follows the standard cold backup procedure (backing up control files and
redo logs) assuming that he can just recover them(granted, anyone should
test
their backup and recovery strategy, but this is a Jr. DBA!)

Just thinking aloud... is it a silly question?

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Excel to Oracle

2002-03-18 Thread Mark Leith


http://www.oraexcel.com

-Original Message-
[EMAIL PROTECTED]
Sent: 18 March 2002 15:44
To: Multiple recipients of list ORACLE-L


Hi All,

What is the best/quickest way to move data from excel to Oracle?

Thanks
Rick


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Logminer

2002-03-18 Thread John Dunn


I get the following error when running SYS.DBMS_LOGMNR_D

ERROR at line 1:
ORA-06532: Subscript outside of limit
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 793
ORA-06512: at line 1

Anyone else seen this?

John

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Dunn
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Another partitioning question


Kirti - Thanks so much for your reply and taking the time to work out an
example. I learned a couple of new techniques from your example. That one is
going in my files.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, March 15, 2002 6:53 PM
To: Multiple recipients of list ORACLE-L


Hi Dennis,

Yes, your are right. 
Thanks for catching it. 
I messed up. 
 
However, the order is still left to right...

While deciding on the partition when composite partition key is involved,
the partition is selected as follows (for 2 column composite key): 
 1. Value < column1 
  then select that partition.
 2. If Value = column1 
 then if value < column2 
then select that partition.

Here is what I did: 

SQL> create table t1 (c varchar2(1), n number(4))
  2  partition by range (c, n)
  3  ( partition p1 values less than ('X', 400),
  4partition p2 values less than ('Y', 800),
  5partition p3 values less than (maxvalue, maxvalue)
  6   );

Table created.

SQL> insert into t1 values ('A', 900);

1 row created.

SQL> insert into t1 values ('X', 900);

1 row created.

SQL> insert into t1 values ('X', 100);

1 row created.

SQL> insert into t1 values ('Y', 900); 

1 row created.

SQL> insert into t1 values ('Y', 500);

1 row created.

SQL> insert into t1 values ('Z', 1000);

1 row created.

SQL> commit;

Commit complete.

SQL>  select * from t1 partition (p1);

C  N
- --
A900
X100

SQL> select * from t1 partition (p2);

C  N
- --
X900
Y500

SQL> select * from t1 partition (p3);

C  N
- --
Y900
Z   1000

Unless I am still confused :(

Thanks.

- Kirti 

-Original Message-
Sent: Friday, March 15, 2002 2:48 PM
To: Multiple recipients of list ORACLE-L


Kirti - If I can humbly beg to differ. I assumed that it would work the way
you described. However, I conducted some tests and found to my surprise that
it seems to base decisions on the right-most column (although I only tested
two columns). Therefore, to use your examples, 

P1 -- values less than ('X', 99) will contain values where column1 = 'X'
and column2 less than 99
P2 -- values less than ('Y', 99) will contain values where column1 = 'Y'
and column2 less than 99.

Since my column1 only has two values, I didn't test what it does with
"unlimited" in the first column.
 I'm not saying that didn't miss something. My ulterior motive for
responding on the list is that I frequently get some fuzzy ideas clarified
by others on the list.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, March 15, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L


If I understood the original question correctly, with the given conditions
there will be three partitions. Oracle evaluates concatenated key from left
to right order, so if the type and seq number are the partitioning columns
here then the partitions would be:  
P1 -- values less than ('X', 99) This will contain everything where type
< X 
P2 -- values less then ('Y', 99) This will contain everything where type
= X
P3 -- values less then (MAXVALUE, MAXVALUE) This will contain everything
else.  I am using 99 to denote the highest value for the seq number. 

Any other ideas? 

- Kirti 



-Original Message-
Sent: Friday, March 15, 2002 11:28 AM
To: Multiple recipients of list ORACLE-L


John - At last a question I can answer! Anyway I think so.
You can partition on a concatenated key. I just did this on our data
warehouse and brought query times from over 2 minutes to under 10 seconds.
Here is what my partition looks like.

create table sumacctfact2
nologging
pctfree 5
partition by range ( periodgrain, periodenddate )
(
partition sum_fy_01 values less than ('FY', to_date('01011999','mmdd'))
   tablespace data_fy_01
   storage ( maxextents unlimited ),
partition sum_fy_02 values less than ('FY', to_date('01012000','mmdd'))
   tablespace data_fy_02
   storage ( maxextents unlimited ),
partition sum_fy_03 values less than ('FY', to_date('01012001','mmdd'))
   tablespace data_fy_03
   storage ( maxextents unlimited ),
partition sum_fy_04 values less than ('FY', to_date('02012001','mmdd'))
   tablespace data_fy_04
   storage ( maxextents unlimited ),   

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Friday, March 15, 2002 10:38 AM
To: Multiple recipients of list ORACLE-L


I think what my boss is asking me to do is not possible, but since I don't
have much experience with partitioning I thought I'd ask here (I did read
some of manuals but didn't find an answer that suited my conditions). My
boss wants a table partitioned by 2 columns - seq_no and type. If the type =
'X' then it's just a range partition, but then he wants another partition
that contains all data that type!='X' but is inclusive of the entire range.
Is this

Re: Excel to Oracle

2002-03-18 Thread DBarbour



sqlldr

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   

Rick_Cale@team 

health.com   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
Sent by: cc:   

[EMAIL PROTECTED]   Subject: Excel to Oracle  

om 

   

   

03/18/2002 

09:43 AM   

Please respond 

to ORACLE-L

   

   





Hi All,

What is the best/quickest way to move data from excel to Oracle?

Thanks
Rick


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Excel to Oracle

2002-03-18 Thread Pardee, Roy E


One way that you might consider is going through MS Access & ODBC.  Link
your Oracle tables via ODBC; import the excel data, and then point-n-click
up some Access "action queries" (aka INSERT statements).

HTH,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Monday, March 18, 2002 7:44 AM
To: Multiple recipients of list ORACLE-L


Hi All,

What is the best/quickest way to move data from excel to Oracle?

Thanks
Rick


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Pardee, Roy E
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Excel to Oracle

2002-03-18 Thread Alec Macdonell


I would dump the excel sheet to a text file and use SQL*LOADER to move it
into Oracle.

Alec

-Original Message-
[EMAIL PROTECTED]
Sent: Monday, March 18, 2002 7:44 AM
To: Multiple recipients of list ORACLE-L


Hi All,

What is the best/quickest way to move data from excel to Oracle?

Thanks
Rick


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alec Macdonell
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Oracle vs. MS SQL EE vs. SE

2002-03-18 Thread Weaver, Walt


Check out the following URL; it will get you started.

http://www.microsoft.com/partner/licensing/embeddedlicensing/faqs/sqllicensi
ng_faq.asp

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Monday, March 18, 2002 8:48 AM
To: Multiple recipients of list ORACLE-L


I have been asked to compare Oracle and Microsoft SQL Server. I notice that
Microsoft has introduced Standard Edition and Enterprise Edition versions.
Can anyone point me to resources that will help me compare these versions
with Oracle versions?
My impression is that Oracle introduced SE as a way to have something
equivalent to MS SQL. Now I am concerned that MS is trying to have SE and EE
versions to show equivalence to Oracle. But I need some evidence to
demonstrate this.
Any assistance will be appreciated.
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: CRONTAB JOB

2002-03-18 Thread Suzy Vordos



Cron has a log file, generally /var/cron/log (requires root privs to
read it).  Also check for mail of the user executing the cron job for
errors.

Hamid Alavi wrote:
> 
> Hi All,
> 
> I have a crontab job but this job never started, I have no idea what's
> wrong, actualy i am not a unix person, here is the job:
> cron job name is :  qqad.cron
> 04 17 * * 1-5  /opt/qqad/sql/QQAD_backupscript.sh
> and here is the QQAD_backupscript.sh (in /opt/qqad/sql)
> 
> sqlplus system/manager@QQAD @COLD_BAKUP_FOR_QQADha.SQL; cold_back.sql is
> generated by COLD_BAKUP_FOR_QQADha.SQL
> 
> @/opt/qqad/sql/cold_back.sql;
> 
> If I run the job manualy it is going OK but crontab never start.
> Any Idea??
> 
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
> 
> The information contained in this message and any attachments is intended
> only for the use of the individual or entity to which it is addressed, and
> may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
> disclosure under applicable law. If you have received this message in error,
> you are prohibited from copying, distributing, or using the information.
> Please contact the sender immediately by return e-mail and delete the
> original message from your system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Excel to Oracle

2002-03-18 Thread Tomita Koga, Alex - (Per)


Hi...

Here we use a text file .css generated in Excel and then we use sqlloader...
it's very fast..

bye

AT&T Latin America
Alex Tomita Koga - ITS
e-mail: [EMAIL PROTECTED]
phone: (51) 1 610- extension 2619
Av. Larco 1301 Torre Parque Mar - Miraflores



-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 18 de Marzo de 2002 10:44 a.m.
Para: Multiple recipients of list ORACLE-L
Asunto: Excel to Oracle


Hi All,

What is the best/quickest way to move data from excel to Oracle?

Thanks
Rick


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tomita Koga, Alex  - (Per)
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: CRONTAB JOB

2002-03-18 Thread Kevin Lange


Also ... are there other cron jobs for that ID that already work ??  It
could be that your sysop needs to give privledges for that ID to run a cron
job.   Also, if the job is actually starting, check to make sure the
environment is set right for it to find sqlplus.  We have to run a small
script at the begining of our jobs to setup the correct paths.  As Suzy
said, check mail to see if there are any outputs there that can help you
debug.

-Original Message-
Sent: Monday, March 18, 2002 10:45 AM
To: Multiple recipients of list ORACLE-L



Cron has a log file, generally /var/cron/log (requires root privs to
read it).  Also check for mail of the user executing the cron job for
errors.

Hamid Alavi wrote:
> 
> Hi All,
> 
> I have a crontab job but this job never started, I have no idea what's
> wrong, actualy i am not a unix person, here is the job:
> cron job name is :  qqad.cron
> 04 17 * * 1-5  /opt/qqad/sql/QQAD_backupscript.sh
> and here is the QQAD_backupscript.sh (in /opt/qqad/sql)
> 
> sqlplus system/manager@QQAD @COLD_BAKUP_FOR_QQADha.SQL; cold_back.sql
is
> generated by COLD_BAKUP_FOR_QQADha.SQL
> 
> @/opt/qqad/sql/cold_back.sql;
> 
> If I run the job manualy it is going OK but crontab never start.
> Any Idea??
> 
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
> 
> The information contained in this message and any attachments is intended
> only for the use of the individual or entity to which it is addressed, and
> may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
> disclosure under applicable law. If you have received this message in
error,
> you are prohibited from copying, distributing, or using the information.
> Please contact the sender immediately by return e-mail and delete the
> original message from your system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Suzy Vordos
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Installs and Extra Cost Options

2002-03-18 Thread MacGregor, Ian A.


Do you control your databases to such an extent that you can guarantee no one will use 
one of the unlicensed features?  Currently we don't install any option for which we 
are not licensed, but I am questioning that strategy.  The idea of unlinking features 
which are not licensed is to prevent their unauthorized use.  

I find Oracle's use of partitioning for logminer interesting.  It will not do so with 
the option turned off.
If one knows that Oracle will use partitioning for logminer and one lets it do so 
despite not being licensed for the option, is that a license violation?  There's one 
for the lawyers.

Here's another one to ponder.  Oracle's Advanced Networking/Security Option, whatever 
they are calling it today, is installed, despite its not being licensed.  Another site 
which is fully licensed for that option needs to access your database.  The remote 
site DBA configures the clients to use MD5 check-summing and 128 bit encryption.  Your 
database because  it has the option installed will support this.   My gut feeling is 
that it would not be until you knew about .  Before you knew, there was no intent to 
defraud.

Once can avoid all this by delinking the unlicensed options.

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]



-Original Message-
Sent: Sunday, March 17, 2002 6:33 AM
To: Multiple recipients of list ORACLE-L


We are working with EE on nt. There is no need to link and all the options
are available.
If we work with a new option then we check if we have to pay for it and
arrange a new contract.
So, why not do a full link?. 
If oracle wants to use something for internal use why should you care?

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

> -Original Message-
> From: MacGregor, Ian A. [SMTP:[EMAIL PROTECTED]]
> Sent: Sat, March 16, 2002 4:23 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Installs and Extra Cost Options
> 
> Sometimes I wonder if the correct thing to do is to install everything and
> then relink the Oracle executable disabling the unpaid for options.  My
> thinking is this:  a need arises where the option would be extremely
> useful;  a successful case is made to management; and an agreement is
> successfully made with Oracle to add the product to our license.  However,
> not all files required by the option are on disk.  You have also
> installed  the latest patchset which contains bug fixes to the option.
> You'd have to install from the CD and then again apply the patchset. 
> 
> However if you had everything installed.  It would just be a matter of
> relinking "oracle" to include the new option.  
>  
> We have a very limited concurrent user license for the partitioning
> option.  Here are some of the partitions
> 
> 
> SQL> select table_owner, table_name, partition_name from
> dba_tab_partitions;
> 
> TABLE_OWNERTABLE_NAME
> PARTITION_NAME
> -- --
> --
> SYSTEM LOGMNR_DICTSTATE$
> P_LESSTHAN100
> SYSTEM LOGMNR_DICTIONARY$
> P_LESSTHAN100
> SYSTEM LOGMNR_OBJ$
> P_LESSTHAN100
> SYSTEM LOGMNR_TAB$
> P_LESSTHAN100
> SYSTEM LOGMNR_COL$
> P_LESSTHAN100
> SYSTEM LOGMNR_ATTRCOL$
> P_LESSTHAN100
> SYSTEM LOGMNR_TS$
> P_LESSTHAN100
> SYSTEM LOGMNR_IND$
> P_LESSTHAN100
> SYSTEM LOGMNR_USER$
> P_LESSTHAN100
> SYSTEM LOGMNR_TABPART$
> P_LESSTHAN100
> SYSTEM LOGMNR_TABSUBPART$
> P_LESSTHAN100
> 
> TABLE_OWNERTABLE_NAME
> PARTITION_NAME
> -- --
> --
> SYSTEM LOGMNR_TABCOMPART$
> P_LESSTHAN100
> SYSTEM LOGMNR_TYPE$
> P_LESSTHAN100
> SYSTEM LOGMNR_COLTYPE$
> P_LESSTHAN100
> SYSTEM LOGMNR_ATTRIBUTE$
> P_LESSTHAN100
> SYSTEM LOGMNR_LOB$
> P_LESSTHAN100
> SYSTEM LOGMNR_CDEF$
> P_LESSTHAN100
> SYSTEM LOGMNR_CCOL$
> P_LESSTHAN100
> SYSTEM LOGMNR_ICOL$
> P_LESSTHAN100
> --
> -
> 
> These our not our partitions, but Oracle's.   If you don't delink it,
> Oracle itself may use it   
> 
> 
> Ian MacGregor
> Stanford Linear Accelerator Center
> [EMAIL PROTECTED]
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: MacGregor, Ian A.
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> --

Re: Fav. Urban Legend...

2002-03-18 Thread Jared Still



Hey, you're an author!

I expect perfection, grace and infallibility.  ;)

Jared

On Monday 18 March 2002 07:33, Freeman, Robert  wrote:
> And hey, it was Sunday morning at 0700 something... what do you
> expect from me anyways??? :-)))
>
> RF
>
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
>
> The Cigarette Smoking Man: Anyone who can appease a man's conscience can
> take his freedom away from him.
>
>
>
> -Original Message-
> Sent: Sunday, March 17, 2002 6:43 PM
> To: Multiple recipients of list ORACLE-L
>
> On Sunday 17 March 2002 07:53, Freeman, Robert  wrote:
> > 1. You do not open the database to users until AFTER you do a backup (hot
> > or cold, dosen't mater) at point t2.
>
> Well, yeah, that was the point.  It doesn't have to be a cold backup, but
> since you can't do any work, it may as well be a cold backup.
>
> Jared
>
> > 2. There is a method of recovering a database (8i +) after RESETLOGS has
> > been
> > issued with archived redo logs. I discussed it in my DBA World Tour
> > backup and
> > recovery presentation. To do this, you MUST have the control file for the
> > database from BEFORE the resetlogs operation, and backup of the control
> > file from AFTER the same operation. I've done this about 3 times in
>
> testing
>
> > and it works fine but it very very picky about the control file images.
> >
> > RF
> >
> > Robert G. Freeman - Oracle8i OCP
> > Oracle DBA Technical Lead
> > CSX Midtier Database Administration
> >
> > The Cigarette Smoking Man: Anyone who can appease a man's conscience can
> > take his freedom away from him.
> >
> >
> >
> > -Original Message-
> > Sent: Friday, March 15, 2002 7:28 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi Jared,
> >
> > > > * You *have* to take a COLD backup of the database after using
> > >
> > > resetlogs.
> > >
> > > > (Not required - a Hot backup and archive logs is adequate. All hot
> > >
> > > backups /
> > >
> > > > archive logs prior to that are invalid, though...)
> > >
> > > Consider the following:
> > >
> > > Time:
> > >
> > > t0: database restored
> > > t1: database opened with RESETLOGS
> > > t2: hot backup started ( database in archive log mode )
> > > t3: users input very important transactions
> > > t4: database crashes, and must be restored
> > >
> > > How will you recover the transactions from time t3?
> >
> > As long as the online redologs are available, this should be no problem.
> > I have successfully recovered databases where a log switch did not occur
> > and recovery had to use an online redo log. (I am assuming that the lost
> > datafiles will be restored from this hot backup fresh off the tapes)
> >
> > On the other hand, if the online redolog is hosed you have lost the
> > transactions anyway, _regardless_ of the fact that a Cold backup was
>
> taken.
>
> > Then you will have to go back to the _previous_ incarnation and redo the
> > restore and then perform a ccf/resetlogs (i.e. back to square one). If
> > you have a Cold backup, you restore the cold backup and go on with life.
> > I.e. in both cases (availability of cold or hot backup, lost online redo
> > log), you have lost transactions...
> >
> > Additionally, with a Hot backup and depending on what was lost, you can
> > at least perform tablespace/datafile recovery . With a cold backup, you
> > will have to restore the whole database
> >
> > The point I was trying to make was that a Cold backup after a RESETLOGS
> > does not serve anything. Maybe there is still a gotcha I have not been
>
> able
>
> > to figure out, so Backup/restore Gurus: take a bash at this logic! I
> > would love to be corrected.
> >
> > (Btw, the previous recovery scenario was on 7.3.4 - things could have
> > changed since, and I have not been able to test that out...)
> >
> >
> > John Kanagaraj
> > Oracle Applications DBA
> > DBSoft Inc
> > (W): 408-970-7002
> >
> > Grace - Getting something we don't deserve
> > Mercy - NOT getting something we deserve
> >
> > Click on 'http://www.needhim.org' for Grace and Mercy that is freely
> > available!
> >
> > ** The opinions and statements above are entirely my own and not those of
> > my employer or clients **
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

cannot delete jobs in OEM ???

2002-03-18 Thread Leslie Lu


Hi all,

I'm using OEM 9.0.1 on Win2000.  On Jobs' Active tab,
after I highlighted some jobs and click Remove Jobs,
the jobs are still there, and the status shows
Deleting, but they are never actually deleted.

The agent, ManagementServer are running.  Preference
Credential user is set with Log on as a batch job
rights.  Looks like command never sent to the agent! 
What's going on?  Thank you.

Leslie

__
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Logminer

2002-03-18 Thread Lyubomir Petrov


Hi John,

You did not mention the Oracle version, but I hope
this will help. 

In $ORACLE_HOME/rdbms/admin/dbmslmd.sql (the script
that builds DBMS_LOGMNR_D package) there is a line:

TYPE col_desc_array IS VARRAY(513) OF col_description;

Replace it with something like:

TYPE col_desc_array IS VARRAY(1000) OF
col_description;

and then rebuild the package.


HTH,
Lyubomir Petrov


--- John Dunn <[EMAIL PROTECTED]> wrote:
> I get the following error when running
> SYS.DBMS_LOGMNR_D
> 
> ERROR at line 1:
> ORA-06532: Subscript outside of limit
> ORA-06512: at "SYS.DBMS_LOGMNR_D", line 793
> ORA-06512: at line 1
> 
> Anyone else seen this?
> 
> John
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: John Dunn
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).


__
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lyubomir Petrov
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Time Zone convert

2002-03-18 Thread Steven Joshua


Hello, All:

In Oracle 8i, How can we convert day/time from the
Time Zone that Oracle 8i does not support to GMT (or
any other Time Zone)? (Oracle 8i only support about 13
convertions.)

I think someone just mentioned this a while ago, but I
didn't write it down.

Thanks for the info.

Steven

__
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Joshua
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELOG mo

2002-03-18 Thread Ora NT DBA


Hi Robert,

Oracle University training uses the terms online and offline and points out
that online backups can only be made to databases that are in archivelog
mode.  Offline backups can be made to either archivelog or noarchivelog
databases.

John

[EMAIL PROTECTED] wrote:

>Ok maybe you will think this is a silly thread, but I've wondered
>about this before...
>
>We (DBA's) use the terms hot and cold backups all the time. I wonder though,
>when we talk about cold backups if the terminology should not include the
>mode of the backup:
>
>cold archivelog mode backup
>cold noarchivelog mode backup
>
>When we say "cold" backup, do we just assume it's NOARCHIVELOG mode...and
>enjoy the fact that we don't have to type or say as much...or should we be
>more specific to help the junior DBA's (or perhaps even those out there who
>have never really considered that there is a distinction between the two)
>out there? When books are written, I notice that they mostly just talk about
>hot and cold backups, assuming that the cold backup is in NOARCHIVELOG
>mode... 
>
>what about the junior DBA who does a cold backup in ARCHIVELOG mode and
>follows the standard cold backup procedure (backing up control files and
>redo logs) assuming that he can just recover them(granted, anyone should
>test
>their backup and recovery strategy, but this is a Jr. DBA!)
>
>Just thinking aloud... is it a silly question?
>
>Robert G. Freeman - Oracle8i OCP
>Oracle DBA Technical Lead
>CSX Midtier Database Administration
>
>The Cigarette Smoking Man: Anyone who can appease a man's conscience can
>take his freedom away from him.
>
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ora NT DBA
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re:RE: Oracle vs. MS SQL EE vs. SE

2002-03-18 Thread dgoulet


Hu, Looks like Oracle's license model, Smells like Oracle's license model. 
Wonder who thought of it first, Bill or Larry??

Dick Goulet

Reply Separator
Author: "Weaver; Walt" <[EMAIL PROTECTED]>
Date:   3/18/2002 8:44 AM

Check out the following URL; it will get you started.

http://www.microsoft.com/partner/licensing/embeddedlicensing/faqs/sqllicensi
ng_faq.asp

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Monday, March 18, 2002 8:48 AM
To: Multiple recipients of list ORACLE-L


I have been asked to compare Oracle and Microsoft SQL Server. I notice that
Microsoft has introduced Standard Edition and Enterprise Edition versions.
Can anyone point me to resources that will help me compare these versions
with Oracle versions?
My impression is that Oracle introduced SE as a way to have something
equivalent to MS SQL. Now I am concerned that MS is trying to have SE and EE
versions to show equivalence to Oracle. But I need some evidence to
demonstrate this.
Any assistance will be appreciated.
Dennis Williams 
DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend... Hot vs Cold

2002-03-18 Thread John Kanagaraj


Hi all,

Notice the renamed heading - this thread has really taken off!

Coming back to the issue: While I agree that you should not open the
database until after you backup (hot or cold), I am still rooting for a hot
backup. If you know the application well enough, you can perform 'selective
hot backup' of a required set of tablespaces that you know will be changed,
and continue hot backup of the others after the database is opened up. In a
cold backup situation, the whole database is down for backup (including
large TEMP tablespaces - 13Gb out of 130 Gb on one of my Production Apps
databases!) for a longer duration than is necessary, which does not look too
good on your availability reports. (And also remember to switch logfiles so
that archivelogs are generated prior to release to users).

Having said all that, a soft mirror that can be used exclusively for backup
is invaluable. The whole database can be put in backup mode for a short
time, the mirror 'broken' and the database backup ended. The mirror can then
be used for backup to tape. In addition to this, you also have an online
backup available (until the resilver starts) and you work off this disk
backup for producting clones. Let me say that again - Invaluable!

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Grace - Getting something we don't deserve
Mercy - NOT getting something we deserve

Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!

** The opinions and statements above are entirely my own and not those of my
employer or clients **


> 1. You do not open the database to users until AFTER you do a 
> backup (hot or
> cold, dosen't mater) at point t2.
> 
> 2. There is a method of recovering a database (8i +) after 
> RESETLOGS has
> been
> issued with archived redo logs. I discussed it in my DBA 

> > > * You *have* to take a COLD backup of the database after using 
> > resetlogs.
> > > (Not required - a Hot backup and archive logs is 
> adequate. All hot 
> > backups /
> > > archive logs prior to that are invalid, though...)
> > 
> > Consider the following:
> > 
> > Time:
> > 
> > t0: database restored
> > t1: database opened with RESETLOGS
> > t2: hot backup started ( database in archive log mode )
> > t3: users input very important transactions
> > t4: database crashes, and must be restored
> > 
> > How will you recover the transactions from time t3?
> 
> As long as the online redologs are available, this should be 
> no problem. I
> have successfully recovered databases where a log switch did 
> not occur and
> recovery had to use an online redo log. (I am assuming that the lost
> datafiles will be restored from this hot backup fresh off the tapes)
> 
> On the other hand, if the online redolog is hosed you have lost the
> transactions anyway, _regardless_ of the fact that a Cold 
> backup was taken.
> Then you will have to go back to the _previous_ incarnation 
> and redo the
> restore and then perform a ccf/resetlogs (i.e. back to square 
> one). If you
> have a Cold backup, you restore the cold backup and go on 
> with life. I.e. in
> both cases (availability of cold or hot backup, lost online 
> redo log), you
> have lost transactions... 
> 
> Additionally, with a Hot backup and depending on what was 
> lost, you can at
> least perform tablespace/datafile recovery . With a cold 
> backup, you will
> have to restore the whole database
> 
> The point I was trying to make was that a Cold backup after a 
> RESETLOGS does
> not serve anything. Maybe there is still a gotcha I have not 
> been able to
> figure out, so Backup/restore Gurus: take a bash at this 
> logic! I would love
> to be corrected.
> 
> (Btw, the previous recovery scenario was on 7.3.4 - things could have
> changed since, and I have not been able to test that out...)
> 
> 
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
> 
> Grace - Getting something we don't deserve
> Mercy - NOT getting something we deserve
> 
> Click on 'http://www.needhim.org' for Grace and Mercy that is freely
> available!
> 
> ** The opinions and statements above are entirely my own and 
> not those of my
> employer or clients **
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: John Kanagaraj
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Freeman, Robert 
>   INET: [EM

Re: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELOG mo

2002-03-18 Thread Big Planet


but isn't cold backup is possible only if ur running in noarchieve mode else
you have to go for hot backup.
BigP

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 18, 2002 7:41 AM


> Ok maybe you will think this is a silly thread, but I've wondered
> about this before...
>
> We (DBA's) use the terms hot and cold backups all the time. I wonder
though,
> when we talk about cold backups if the terminology should not include the
> mode of the backup:
>
> cold archivelog mode backup
> cold noarchivelog mode backup
>
> When we say "cold" backup, do we just assume it's NOARCHIVELOG mode...and
> enjoy the fact that we don't have to type or say as much...or should we be
> more specific to help the junior DBA's (or perhaps even those out there
who
> have never really considered that there is a distinction between the two)
> out there? When books are written, I notice that they mostly just talk
about
> hot and cold backups, assuming that the cold backup is in NOARCHIVELOG
> mode...
>
> what about the junior DBA who does a cold backup in ARCHIVELOG mode and
> follows the standard cold backup procedure (backing up control files and
> redo logs) assuming that he can just recover them(granted, anyone
should
> test
> their backup and recovery strategy, but this is a Jr. DBA!)
>
> Just thinking aloud... is it a silly question?
>
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
>
> The Cigarette Smoking Man: Anyone who can appease a man's conscience can
> take his freedom away from him.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Freeman, Robert
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Big Planet
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE:

2002-03-18 Thread David Ehresmann


When I start the OUI I can see the jrew.exe process running.  Outside of
that I don't see a jre or jrew process running.  I can run the OUI but not
the dbca or dbastudio.

thanks.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Seefelt,
> Beth
> Sent: Monday, March 18, 2002 9:00 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE:
>
>
>
> If you close all the gui applications, is there a jre or jrew process
> still running?  You might try killing those completely (that may cause
> your oracle management server to abort and it will have to be restarted
> manually) and then restarting DBCA.  I don't know about DBCA, but I've
> seen similar problems with the other Oracle GUIs and the java runtime
> environment.
>
> HTH,
>
> Beth
>
> -Original Message-
> Sent: Monday, March 18, 2002 9:23 AM
> To: Multiple recipients of list ORACLE-L
> Subject:
>
>
> I was trying to user the DBCA on the server this weekend and it won't
> start. The hourglass comes up and then just disappears.  It has worked
> in the past. It throws no error messages, no trace files, writes nothing
> to the alert log.  I have 2 instances on this NT4.0 box and everything
> appears to be just fine with them and the users.  I am running 8i
> 8.1.6.0.0.  Does anybody have any idea why it would not start?
>
>
>
> David Ehresmann
> Oracle DBA 8i OCP
> MCI Worldcom
> [EMAIL PROTECTED]
> 972.656.1015
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: David Ehresmann
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Seefelt, Beth
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Ehresmann
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Oracle hangs...Oracle 8.1.7.3 and Solaris 2.7

2002-03-18 Thread Grabowy, Chris


We have a particular database that hangs on a regular basis.  Here are the
stats and symptoms.

Oracle stats
--
8.1.7.3 (highest patch level applied)
Solaris 2.7
UTF8 character set

Symptoms
--
Random hanging.
 Hanging meaning SQL processing stops.
 New connections "hang".
No traces files.
No messages in the alert log.
Killing the Oracle processes is the only way to recover from the problem.

This problem has been reported to Oracle Support, they are now escalating it
up.

I just wanted to PING the list to see if anyone else has encountered this.

TIA!!!

Chris
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grabowy, Chris
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELOG mo

2002-03-18 Thread bill thater

[EMAIL PROTECTED] wrote:

> but isn't cold backup is possible only if ur running in noarchieve mode else
> you have to go for hot backup.
> BigP

OK let's get the definitions down first.  AFAIK:

cold backup := database shut down and an OS copy of all the necessary files.

hot backup := place TS in backup mode, the do an OS copy of the files 
for that TS.

first can be done to any database, second only to databases in 
archivelog mode.

-- 
--
Bill "Shrek" Thater  ORACLE DBA
 [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

I used to have a life, then I got v32bis!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: bill thater
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend... Hot vs Cold


John,

Yes, and I could kick myself for not thinking of this, mirrors can be a most
excellent alternative to backups both production and after a recovery. Of 
course, it can be an expensive alternative as it requires you to have
2x disk space... :-)

But disk is cheap, right...?

Or is that yet another Urban Legend???

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Monday, March 18, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L


Hi all,

Notice the renamed heading - this thread has really taken off!

Coming back to the issue: While I agree that you should not open the
database until after you backup (hot or cold), I am still rooting for a hot
backup. If you know the application well enough, you can perform 'selective
hot backup' of a required set of tablespaces that you know will be changed,
and continue hot backup of the others after the database is opened up. In a
cold backup situation, the whole database is down for backup (including
large TEMP tablespaces - 13Gb out of 130 Gb on one of my Production Apps
databases!) for a longer duration than is necessary, which does not look too
good on your availability reports. (And also remember to switch logfiles so
that archivelogs are generated prior to release to users).

Having said all that, a soft mirror that can be used exclusively for backup
is invaluable. The whole database can be put in backup mode for a short
time, the mirror 'broken' and the database backup ended. The mirror can then
be used for backup to tape. In addition to this, you also have an online
backup available (until the resilver starts) and you work off this disk
backup for producting clones. Let me say that again - Invaluable!

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Grace - Getting something we don't deserve
Mercy - NOT getting something we deserve

Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!

** The opinions and statements above are entirely my own and not those of my
employer or clients **


> 1. You do not open the database to users until AFTER you do a 
> backup (hot or
> cold, dosen't mater) at point t2.
> 
> 2. There is a method of recovering a database (8i +) after 
> RESETLOGS has
> been
> issued with archived redo logs. I discussed it in my DBA 

> > > * You *have* to take a COLD backup of the database after using 
> > resetlogs.
> > > (Not required - a Hot backup and archive logs is 
> adequate. All hot 
> > backups /
> > > archive logs prior to that are invalid, though...)
> > 
> > Consider the following:
> > 
> > Time:
> > 
> > t0: database restored
> > t1: database opened with RESETLOGS
> > t2: hot backup started ( database in archive log mode )
> > t3: users input very important transactions
> > t4: database crashes, and must be restored
> > 
> > How will you recover the transactions from time t3?
> 
> As long as the online redologs are available, this should be 
> no problem. I
> have successfully recovered databases where a log switch did 
> not occur and
> recovery had to use an online redo log. (I am assuming that the lost
> datafiles will be restored from this hot backup fresh off the tapes)
> 
> On the other hand, if the online redolog is hosed you have lost the
> transactions anyway, _regardless_ of the fact that a Cold 
> backup was taken.
> Then you will have to go back to the _previous_ incarnation 
> and redo the
> restore and then perform a ccf/resetlogs (i.e. back to square 
> one). If you
> have a Cold backup, you restore the cold backup and go on 
> with life. I.e. in
> both cases (availability of cold or hot backup, lost online 
> redo log), you
> have lost transactions... 
> 
> Additionally, with a Hot backup and depending on what was 
> lost, you can at
> least perform tablespace/datafile recovery . With a cold 
> backup, you will
> have to restore the whole database
> 
> The point I was trying to make was that a Cold backup after a 
> RESETLOGS does
> not serve anything. Maybe there is still a gotcha I have not 
> been able to
> figure out, so Backup/restore Gurus: take a bash at this 
> logic! I would love
> to be corrected.
> 
> (Btw, the previous recovery scenario was on 7.3.4 - things could have
> changed since, and I have not been able to test that out...)
> 
> 
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
> 
> Grace - Getting something we don't deserve
> Mercy - NOT getting something we deserve
> 
> Click on 'http://www.needhim.org' for Grace and Mercy that is freely
> available!
> 
> ** The opinions and statements above are entirely my own and 
> not those of my
> employer or clients **
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: John Kanagaraj
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services

RE: Fav. Urban Legend... NOBACKUP!!

2002-03-18 Thread K Gopalakrishnan


John !!

Notice the change in subject again !!

WARNING**
ORACLE WILL NOT SUPPORT THIS KIND OF RECOVERY.
*


I don't agree with you about the MANDATORY backup. You can still
recover the database COMPLETELY if you have all the archives from your
old backup (before RESETLOGS) and the NEW ARCHIVES (after RESETLOGS) as
long as if you have both (pre/post resetlogs) control files undamaged
and your database version is 7.3.3 and above.

I have once recovered a 8.0.5 database on Solaris using the backup (pre
RESETLOGS) and the archive logs of pre and post resetlogs. THis recovery
is based on SCN and Log Sequence has no role here.

THis is two part recovery (I have given the outline in a private mail)
and Oracle will not support this kind of recovery...


For the arguement sake I can tell YOU DON:T NEED ANY BACKUP AFTER RESETLOGS.
But since
this is an unsupported I strongly suggest Jared' point..
A COMPLETE COLD BACKUP AFTER RESETLOGS.






Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Kanagaraj
Sent: Monday, March 18, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L


Hi all,

Notice the renamed heading - this thread has really taken off!

Coming back to the issue: While I agree that you should not open the
database until after you backup (hot or cold), I am still rooting for a hot
backup. If you know the application well enough, you can perform 'selective
hot backup' of a required set of tablespaces that you know will be changed,
and continue hot backup of the others after the database is opened up. In a
cold backup situation, the whole database is down for backup (including
large TEMP tablespaces - 13Gb out of 130 Gb on one of my Production Apps
databases!) for a longer duration than is necessary, which does not look too
good on your availability reports. (And also remember to switch logfiles so
that archivelogs are generated prior to release to users).

Having said all that, a soft mirror that can be used exclusively for backup
is invaluable. The whole database can be put in backup mode for a short
time, the mirror 'broken' and the database backup ended. The mirror can then
be used for backup to tape. In addition to this, you also have an online
backup available (until the resilver starts) and you work off this disk
backup for producting clones. Let me say that again - Invaluable!

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Grace - Getting something we don't deserve
Mercy - NOT getting something we deserve

Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!

** The opinions and statements above are entirely my own and not those of my
employer or clients **


> 1. You do not open the database to users until AFTER you do a
> backup (hot or
> cold, dosen't mater) at point t2.
>
> 2. There is a method of recovering a database (8i +) after
> RESETLOGS has
> been
> issued with archived redo logs. I discussed it in my DBA

> > > * You *have* to take a COLD backup of the database after using
> > resetlogs.
> > > (Not required - a Hot backup and archive logs is
> adequate. All hot
> > backups /
> > > archive logs prior to that are invalid, though...)
> >
> > Consider the following:
> >
> > Time:
> >
> > t0: database restored
> > t1: database opened with RESETLOGS
> > t2: hot backup started ( database in archive log mode )
> > t3: users input very important transactions
> > t4: database crashes, and must be restored
> >
> > How will you recover the transactions from time t3?
>
> As long as the online redologs are available, this should be
> no problem. I
> have successfully recovered databases where a log switch did
> not occur and
> recovery had to use an online redo log. (I am assuming that the lost
> datafiles will be restored from this hot backup fresh off the tapes)
>
> On the other hand, if the online redolog is hosed you have lost the
> transactions anyway, _regardless_ of the fact that a Cold
> backup was taken.
> Then you will have to go back to the _previous_ incarnation
> and redo the
> restore and then perform a ccf/resetlogs (i.e. back to square
> one). If you
> have a Cold backup, you restore the cold backup and go on
> with life. I.e. in
> both cases (availability of cold or hot backup, lost online
> redo log), you
> have lost transactions...
>
> Additionally, with a Hot backup and depending on what was
> lost, you can at
> least perform tablespace/datafile recovery . With a cold
> backup, you will
> have to restore the whole database
>
> The point I was trying to make was that a Cold backup after a
> RESETLOGS does
> not serve anything. Maybe there is still a gotcha I have not
> been able to
> figure out, so Backup/restore Gurus: take a bash at this
> logic! I would love
> to be corrected.
>
> (Btw, the previous recovery scenario was on 7.3.4 - things could have
> changed since, and I have not been able to test that out...)
>
>
>

RE: Fav. Urban Legend...


So, does the CoO (Church of Oracle) have an infallibility doctrine then???

... From the Book of Oracle, chapter 5 ...

...and the DBA did look upon his database, and he saw it was good.
His tablespace datafiles being distributed tither and fro, spread amongst
the
platters of his disks. And he did complete that which was called
documentation,
and then he rested from his labors, and drank Mountain Dew Code Red...


:-)

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Monday, March 18, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L



Hey, you're an author!

I expect perfection, grace and infallibility.  ;)

Jared

On Monday 18 March 2002 07:33, Freeman, Robert  wrote:
> And hey, it was Sunday morning at 0700 something... what do you
> expect from me anyways??? :-)))
>
> RF
>
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
>
> The Cigarette Smoking Man: Anyone who can appease a man's conscience can
> take his freedom away from him.
>
>
>
> -Original Message-
> Sent: Sunday, March 17, 2002 6:43 PM
> To: Multiple recipients of list ORACLE-L
>
> On Sunday 17 March 2002 07:53, Freeman, Robert  wrote:
> > 1. You do not open the database to users until AFTER you do a backup
(hot
> > or cold, dosen't mater) at point t2.
>
> Well, yeah, that was the point.  It doesn't have to be a cold backup, but
> since you can't do any work, it may as well be a cold backup.
>
> Jared
>
> > 2. There is a method of recovering a database (8i +) after RESETLOGS has
> > been
> > issued with archived redo logs. I discussed it in my DBA World Tour
> > backup and
> > recovery presentation. To do this, you MUST have the control file for
the
> > database from BEFORE the resetlogs operation, and backup of the control
> > file from AFTER the same operation. I've done this about 3 times in
>
> testing
>
> > and it works fine but it very very picky about the control file images.
> >
> > RF
> >
> > Robert G. Freeman - Oracle8i OCP
> > Oracle DBA Technical Lead
> > CSX Midtier Database Administration
> >
> > The Cigarette Smoking Man: Anyone who can appease a man's conscience can
> > take his freedom away from him.
> >
> >
> >
> > -Original Message-
> > Sent: Friday, March 15, 2002 7:28 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi Jared,
> >
> > > > * You *have* to take a COLD backup of the database after using
> > >
> > > resetlogs.
> > >
> > > > (Not required - a Hot backup and archive logs is adequate. All hot
> > >
> > > backups /
> > >
> > > > archive logs prior to that are invalid, though...)
> > >
> > > Consider the following:
> > >
> > > Time:
> > >
> > > t0: database restored
> > > t1: database opened with RESETLOGS
> > > t2: hot backup started ( database in archive log mode )
> > > t3: users input very important transactions
> > > t4: database crashes, and must be restored
> > >
> > > How will you recover the transactions from time t3?
> >
> > As long as the online redologs are available, this should be no problem.
> > I have successfully recovered databases where a log switch did not occur
> > and recovery had to use an online redo log. (I am assuming that the lost
> > datafiles will be restored from this hot backup fresh off the tapes)
> >
> > On the other hand, if the online redolog is hosed you have lost the
> > transactions anyway, _regardless_ of the fact that a Cold backup was
>
> taken.
>
> > Then you will have to go back to the _previous_ incarnation and redo the
> > restore and then perform a ccf/resetlogs (i.e. back to square one). If
> > you have a Cold backup, you restore the cold backup and go on with life.
> > I.e. in both cases (availability of cold or hot backup, lost online redo
> > log), you have lost transactions...
> >
> > Additionally, with a Hot backup and depending on what was lost, you can
> > at least perform tablespace/datafile recovery . With a cold backup, you
> > will have to restore the whole database
> >
> > The point I was trying to make was that a Cold backup after a RESETLOGS
> > does not serve anything. Maybe there is still a gotcha I have not been
>
> able
>
> > to figure out, so Backup/restore Gurus: take a bash at this logic! I
> > would love to be corrected.
> >
> > (Btw, the previous recovery scenario was on 7.3.4 - things could have
> > changed since, and I have not been able to test that out...)
> >
> >
> > John Kanagaraj
> > Oracle Applications DBA
> > DBSoft Inc
> > (W): 408-970-7002
> >
> > Grace - Getting something we don't deserve
> > Mercy - NOT getting something we deserve
> >
> > Click on 'http://www.needhim.org' for Grace and Mercy that is freely
> > available!
> >
> > ** The opinions and statements above are entirely my own and not those
of
> > my employer or clients **
-- 
Please see the officia

Oracle Gold Support


Anyone else just slightly irritated with the level of customer support
offered for phone callers to Oracle now days? Used to be, that if you
were a gold customer as we are, you could almost count on instant first line
support. Last week I called and was told that a phone call would
result in at least a one hour delay in an analyst call back, whereas
an iTar (lie tars I call em) will get me about 30 minute response.
The representative was rude and snarly to me at the same time.
Is this how Larry wants to save that second billion, crappy customer
service?

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO


I can read your question 2 ways, so let me answer it both ways...

If you are asking if you can only do a cold backup when in noarchivelog
mode, you are correct.

However, in archivelog mode you can do cold or hot backup. The procedure is
a bit different in archivelog mode, because of the recovery implications of
being in archivelog mode.

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Monday, March 18, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L
NOARCHIVELOG mo


but isn't cold backup is possible only if ur running in noarchieve mode else
you have to go for hot backup.
BigP

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 18, 2002 7:41 AM


> Ok maybe you will think this is a silly thread, but I've wondered
> about this before...
>
> We (DBA's) use the terms hot and cold backups all the time. I wonder
though,
> when we talk about cold backups if the terminology should not include the
> mode of the backup:
>
> cold archivelog mode backup
> cold noarchivelog mode backup
>
> When we say "cold" backup, do we just assume it's NOARCHIVELOG mode...and
> enjoy the fact that we don't have to type or say as much...or should we be
> more specific to help the junior DBA's (or perhaps even those out there
who
> have never really considered that there is a distinction between the two)
> out there? When books are written, I notice that they mostly just talk
about
> hot and cold backups, assuming that the cold backup is in NOARCHIVELOG
> mode...
>
> what about the junior DBA who does a cold backup in ARCHIVELOG mode and
> follows the standard cold backup procedure (backing up control files and
> redo logs) assuming that he can just recover them(granted, anyone
should
> test
> their backup and recovery strategy, but this is a Jr. DBA!)
>
> Just thinking aloud... is it a silly question?
>
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
>
> The Cigarette Smoking Man: Anyone who can appease a man's conscience can
> take his freedom away from him.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Freeman, Robert
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Big Planet
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Oracle hangs...Oracle 8.1.7.3 and Solaris 2.7

2002-03-18 Thread K Gopalakrishnan


Chris,

Just do a ORADEBUG HANGANALYZE and upload the trace file to
http://www.unal-bilisim.com 's Hanganalyzer.


Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Chris
Sent: Monday, March 18, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L


We have a particular database that hangs on a regular basis.  Here are the
stats and symptoms.

Oracle stats
--
8.1.7.3 (highest patch level applied)
Solaris 2.7
UTF8 character set

Symptoms
--
Random hanging.
 Hanging meaning SQL processing stops.
 New connections "hang".
No traces files.
No messages in the alert log.
Killing the Oracle processes is the only way to recover from the problem.

This problem has been reported to Oracle Support, they are now escalating it
up.

I just wanted to PING the list to see if anyone else has encountered this.

TIA!!!

Chris
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Grabowy, Chris
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

is Oracle really planning to desupport RBO?

2002-03-18 Thread Magaliff, Bill


Has anyone heard anthing official or semi-official on this?



Bill Magaliff
Framework, Inc.
914-631-2322

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Magaliff, Bill
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

2002-03-18 Thread Ora NT DBA

You can call them whatever you like, nothing in the world will save the

clueless person you describe below :-).

You are correct in saying it is a training issue, I personally use hot and

cold but think offline and online are just fine as well. The issue is that
the
mode "archive vs noarchivelog" of the database significantly effects the
"recovery" of the database. One of my favorite dba's instructors used to

say if you are not going to test that backup and recovery plan at
least keep an updated resume :-).

John

[EMAIL PROTECTED] wrote:

But my concern is this. Say a DBA has been doing cold, noarchivelog mode,backups for a year. Then, he gets this great idea (or direction) to put thedatabase in archivelog mode, but to still do cold (or offline) backups, soall he changes in his backup/recovery strategy is the backup of the archivedredo logs, notrealizing that there are some other considerations. He reads a book or two, and because they call them hot/cold oronline/offline, he figures that his backup really is the same and that hejust needs to also backup the archived redo logs (thus, he continues tobackup the online redo and control files). Now, he has a crash. Because ofhis mistaken ideas (with no help from what he has read really), he recoversthe control file and online redo logs as he would have for a regular coldbackup bad news, no? I'm just... concerned, that the term is nottechnically correct and could lead to issues. I guess this
is an educationalissue that I'm thinking of, less of a practical issue for seniorDBA's who clearly understand the implications of archivelog vs.noarchivelog.RFRobert G. Freeman - Oracle8i OCPOracle DBA Technical LeadCSX Midtier Database AdministrationThe Cigarette Smoking Man: Anyone who can appease a man's conscience cantake his freedom away from him.-Original Message-Sent: Monday, March 18, 2002 12:50 PMTo: Multiple recipients of list ORACLE-LNOARCHIVELOG moHi Robert,Oracle University training uses the terms online and offline and points outthat online backups can only be made to databases that are in archivelogmode. Offline backups can be made to either archivelog or noarchivelogdatabases.John[EMAIL PROTECTED] wrote:

Ok maybe you will think this is a silly thread, but I've wonderedabout this before...We (DBA's) use the terms hot and cold backups all the time. I wonder

though,

when we talk about cold backups if the terminology should not include themode of the backup:cold archivelog mode backupcold noarchivelog mode backupWhen we say "cold" backup, do we just assume it's NOARCHIVELOG mode...andenjoy the fact that we don't have to type or say as much...or should we bemore specific to help the junior DBA's (or perhaps even those out there whohave never really considered that there is a distinction between the two)out there? When books are written, I notice that they mostly just talk

about

hot and cold backups, assuming that the cold backup is in NOARCHIVELOGmode... what about the junior DBA who does a cold backup in ARCHIVELOG mode andfollows the standard cold backup procedure (backing up control files andredo logs) assuming that he can just recover them(granted, anyone

should

testtheir backup and recovery strategy, but this is a Jr. DBA!)Just thinking aloud... is it a silly question?Robert G. Freeman - Oracle8i OCPOracle DBA Technical LeadCSX Midtier Database AdministrationThe Cigarette Smoking Man: Anyone who can appease a man's conscience cantake his freedom away from him.

RE:


Memory availability?? DBCA does require a great deal of it. Check your
overall available memory (real and virtual).

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Monday, March 18, 2002 1:38 PM
To: Multiple recipients of list ORACLE-L


When I start the OUI I can see the jrew.exe process running.  Outside of
that I don't see a jre or jrew process running.  I can run the OUI but not
the dbca or dbastudio.

thanks.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Seefelt,
> Beth
> Sent: Monday, March 18, 2002 9:00 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE:
>
>
>
> If you close all the gui applications, is there a jre or jrew process
> still running?  You might try killing those completely (that may cause
> your oracle management server to abort and it will have to be restarted
> manually) and then restarting DBCA.  I don't know about DBCA, but I've
> seen similar problems with the other Oracle GUIs and the java runtime
> environment.
>
> HTH,
>
> Beth
>
> -Original Message-
> Sent: Monday, March 18, 2002 9:23 AM
> To: Multiple recipients of list ORACLE-L
> Subject:
>
>
> I was trying to user the DBCA on the server this weekend and it won't
> start. The hourglass comes up and then just disappears.  It has worked
> in the past. It throws no error messages, no trace files, writes nothing
> to the alert log.  I have 2 instances on this NT4.0 box and everything
> appears to be just fine with them and the users.  I am running 8i
> 8.1.6.0.0.  Does anybody have any idea why it would not start?
>
>
>
> David Ehresmann
> Oracle DBA 8i OCP
> MCI Worldcom
> [EMAIL PROTECTED]
> 972.656.1015
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: David Ehresmann
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Seefelt, Beth
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Ehresmann
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

But my concern is this. Say a DBA has been doing cold, noarchivelog mode,
backups for a year. Then, he gets this great idea (or direction) to put the
database in archivelog mode, but to still do cold (or offline) backups, so
all he changes in his backup/recovery strategy is the backup of the archived
redo logs, not
realizing that there are some other considerations. 

He reads a book or two, and because they call them hot/cold or
online/offline, he figures that his backup really is the same and that he
just needs to also backup the archived redo logs (thus, he continues to
backup the online redo and control files). Now, he has a crash. Because of
his mistaken ideas (with no help from what he has read really), he recovers
the control file and online redo logs as he would have for a regular cold
backup bad news, no? I'm just... concerned, that the term is not
technically correct and could lead to issues. I guess this is an educational
issue that I'm thinking of, less of a practical issue for senior
DBA's who clearly understand the implications of archivelog vs.
noarchivelog.

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.

-Original Message-
Sent: Monday, March 18, 2002 12:50 PM
To: Multiple recipients of list ORACLE-L
NOARCHIVELOG mo

Hi Robert,

Oracle University training uses the terms online and offline and points out
that online backups can only be made to databases that are in archivelog
mode.  Offline backups can be made to either archivelog or noarchivelog
databases.

John

[EMAIL PROTECTED] wrote:

>Ok maybe you will think this is a silly thread, but I've wondered
>about this before...
>
>We (DBA's) use the terms hot and cold backups all the time. I wonder
though,
>when we talk about cold backups if the terminology should not include the
>mode of the backup:
>
>cold archivelog mode backup
>cold noarchivelog mode backup
>
>When we say "cold" backup, do we just assume it's NOARCHIVELOG mode...and
>enjoy the fact that we don't have to type or say as much...or should we be
>more specific to help the junior DBA's (or perhaps even those out there who
>have never really considered that there is a distinction between the two)
>out there? When books are written, I notice that they mostly just talk
about
>hot and cold backups, assuming that the cold backup is in NOARCHIVELOG
>mode... 
>
>what about the junior DBA who does a cold backup in ARCHIVELOG mode and
>follows the standard cold backup procedure (backing up control files and
>redo logs) assuming that he can just recover them(granted, anyone
should
>test
>their backup and recovery strategy, but this is a Jr. DBA!)
>
>Just thinking aloud... is it a silly question?
>
>Robert G. Freeman - Oracle8i OCP
>Oracle DBA Technical Lead
>CSX Midtier Database Administration
>
>The Cigarette Smoking Man: Anyone who can appease a man's conscience can
>take his freedom away from him.
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ora NT DBA
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Fav. Urban Legend...

2002-03-18 Thread bill thater

[EMAIL PROTECTED] wrote:

> platters of his disks. And he did complete that which was called
> documentation,
> and then he rested from his labors, and drank Mountain Dew Code Red...

nope he drank single malt scotch, neat.;-)

-- 
--
Bill "Shrek" Thater  ORACLE DBA
 [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

I used to have a life, then I got v32bis!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: bill thater
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Disk is cheap?

2002-03-18 Thread Stahlke, Mark

Robert G. Freeman - Oracle8i OCP  wrote:
>  
> But disk is cheap, right...?
> Or is that yet another Urban Legend???

Yes, that's another Urban Legend.

Disk DRIVES are cheap, disk SPACE is not so cheap.

Consider this example: I have a disk cabinet with 24 slots and 23
disks. The 24th disk is cheap, but how much does the 25th disk cost? In
addition to the disk drive we need a cabinet, controllers, cache, host
adapters, cables, floor space, environmental controls, installation,
configuration, management, maintenance contract, and on and on.

Mark Stahlke
Oracle DuhBA
Denver Newspaper Agency
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stahlke, Mark
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: cannot delete jobs in OEM ???

2002-03-18 Thread traci . l . rebman



Leslie,

You might want to check that the agent is running on the DB server that the
jobs are scheduled, and refresh the node in OEM.  If that doesn't work, you
could stop the agent, remove the node in OEM, and clean up the *.q files
for that agent ($ORACLE_HOME/network/agent), then re-discover the node.  I
believe when you remove the node, it will force those jobs to be deleted in
OEM.

Traci L. Rebman
Oracle Database Administrator
R.R. Donnelley & Sons



   

  Leslie Lu

 
  o.com>   cc: 

  Sent by: Subject:  cannot delete jobs in OEM ??? 

  [EMAIL PROTECTED] 

   

   

  03/18/2002 12:29 

  PM   

  Please respond to

  ORACLE-L 

   

   





Hi all,

I'm using OEM 9.0.1 on Win2000.  On Jobs' Active tab,
after I highlighted some jobs and click Remove Jobs,
the jobs are still there, and the status shows
Deleting, but they are never actually deleted.

The agent, ManagementServer are running.  Preference
Credential user is set with Log on as a batch job
rights.  Looks like command never sent to the agent!
What's going on?  Thank you.

Leslie

__
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Oracle Gold Support

2002-03-18 Thread Stephane Faroult


"Freeman, Robert" wrote:
> 
> Anyone else just slightly irritated with the level of customer support
> offered for phone callers to Oracle now days? Used to be, that if you
> were a gold customer as we are, you could almost count on instant first line
> support. Last week I called and was told that a phone call would
> result in at least a one hour delay in an analyst call back, whereas
> an iTar (lie tars I call em) will get me about 30 minute response.
> The representative was rude and snarly to me at the same time.
> Is this how Larry wants to save that second billion, crappy customer
> service?
> 
> RF
> 

Just a novel manner to sell oracle.com CRM services.

-- 
Regards,

Stephane Faroult
Oriole Ltd
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Learn from my mistakes! Or "Helpful DBA hint of the day"

2002-03-18 Thread Jesse, Rich


In 9.0.1, when you create a DB, you would "connect / as sysdba".  However,
if you also run "catalog" and "catproc" while connected like this, Oracle
Advanced Symmetric Replication WILL NOT WORK.  You *MUST* be connected as
"SYS as sysdba".

It's taken me forever to find this.  The biggest clue I had was a number of
ORA-06550 errors in the create logs that point to a character set mismatch.
Of course, I found an article on Metaclink that said this may be normal, so
I ignored them at first.  (I can't find that article again!)

I know I've sent out at least one other message like this, but these little
things can really come back and haunt a person.  And maybe the next time I
have this and send a message to the list, someone with a real memory can
help me!

Enjoy!  :)

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend... Hot vs Cold

2002-03-18 Thread Ball, Terry


Well, if you ask many damagement types, they would say it's a myth.  :)

-Original Message-
Sent: Monday, March 18, 2002 12:58 PM
To: Multiple recipients of list ORACLE-L


John,

Yes, and I could kick myself for not thinking of this, mirrors can be a most
excellent alternative to backups both production and after a recovery. Of 
course, it can be an expensive alternative as it requires you to have
2x disk space... :-)

But disk is cheap, right...?

Or is that yet another Urban Legend???

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Monday, March 18, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L


Hi all,

Notice the renamed heading - this thread has really taken off!

Coming back to the issue: While I agree that you should not open the
database until after you backup (hot or cold), I am still rooting for a hot
backup. If you know the application well enough, you can perform 'selective
hot backup' of a required set of tablespaces that you know will be changed,
and continue hot backup of the others after the database is opened up. In a
cold backup situation, the whole database is down for backup (including
large TEMP tablespaces - 13Gb out of 130 Gb on one of my Production Apps
databases!) for a longer duration than is necessary, which does not look too
good on your availability reports. (And also remember to switch logfiles so
that archivelogs are generated prior to release to users).

Having said all that, a soft mirror that can be used exclusively for backup
is invaluable. The whole database can be put in backup mode for a short
time, the mirror 'broken' and the database backup ended. The mirror can then
be used for backup to tape. In addition to this, you also have an online
backup available (until the resilver starts) and you work off this disk
backup for producting clones. Let me say that again - Invaluable!

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Grace - Getting something we don't deserve
Mercy - NOT getting something we deserve

Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!

** The opinions and statements above are entirely my own and not those of my
employer or clients **


> 1. You do not open the database to users until AFTER you do a 
> backup (hot or
> cold, dosen't mater) at point t2.
> 
> 2. There is a method of recovering a database (8i +) after 
> RESETLOGS has
> been
> issued with archived redo logs. I discussed it in my DBA 

> > > * You *have* to take a COLD backup of the database after using 
> > resetlogs.
> > > (Not required - a Hot backup and archive logs is 
> adequate. All hot 
> > backups /
> > > archive logs prior to that are invalid, though...)
> > 
> > Consider the following:
> > 
> > Time:
> > 
> > t0: database restored
> > t1: database opened with RESETLOGS
> > t2: hot backup started ( database in archive log mode )
> > t3: users input very important transactions
> > t4: database crashes, and must be restored
> > 
> > How will you recover the transactions from time t3?
> 
> As long as the online redologs are available, this should be 
> no problem. I
> have successfully recovered databases where a log switch did 
> not occur and
> recovery had to use an online redo log. (I am assuming that the lost
> datafiles will be restored from this hot backup fresh off the tapes)
> 
> On the other hand, if the online redolog is hosed you have lost the
> transactions anyway, _regardless_ of the fact that a Cold 
> backup was taken.
> Then you will have to go back to the _previous_ incarnation 
> and redo the
> restore and then perform a ccf/resetlogs (i.e. back to square 
> one). If you
> have a Cold backup, you restore the cold backup and go on 
> with life. I.e. in
> both cases (availability of cold or hot backup, lost online 
> redo log), you
> have lost transactions... 
> 
> Additionally, with a Hot backup and depending on what was 
> lost, you can at
> least perform tablespace/datafile recovery . With a cold 
> backup, you will
> have to restore the whole database
> 
> The point I was trying to make was that a Cold backup after a 
> RESETLOGS does
> not serve anything. Maybe there is still a gotcha I have not 
> been able to
> figure out, so Backup/restore Gurus: take a bash at this 
> logic! I would love
> to be corrected.
> 
> (Btw, the previous recovery scenario was on 7.3.4 - things could have
> changed since, and I have not been able to test that out...)
> 
> 
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
> 
> Grace - Getting something we don't deserve
> Mercy - NOT getting something we deserve
> 
> Click on 'http://www.needhim.org' for Grace and Mercy that is freely
> available!
> 
> ** The opinions and statements above are entirely my own and 
> not those of my
> employer

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

I agree with your definitionsbut the cold backup in archivelog mode is
fundamentally different from one done in noarchivelog more (with respect to
online redo logs and control files) if you are in archivelog mode and want
to be able to do point in time recovery.

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.

-Original Message-
Sent: Monday, March 18, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
NOARCHIVELOG mo

[EMAIL PROTECTED] wrote:

> but isn't cold backup is possible only if ur running in noarchieve mode
else
> you have to go for hot backup.
> BigP

OK let's get the definitions down first.  AFAIK:

cold backup := database shut down and an OS copy of all the necessary files.

hot backup := place TS in backup mode, the do an OS copy of the files 
for that TS.

first can be done to any database, second only to databases in 
archivelog mode.

-- 
--
Bill "Shrek" Thater  ORACLE DBA
 [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

I used to have a life, then I got v32bis!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: bill thater
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend... NOBACKUP!!

2002-03-18 Thread Jeremiah Wilton

Gopal,

Would you mind posting the procedure for recovering past resetlogs?

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Mon, 18 Mar 2002, K Gopalakrishnan wrote:

> I have once recovered a 8.0.5 database on Solaris using the backup (pre
> RESETLOGS) and the archive logs of pre and post resetlogs. THis recovery
> is based on SCN and Log Sequence has no role here.
> 
> THis is two part recovery (I have given the outline in a private mail)
> and Oracle will not support this kind of recovery...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend... NOBACKUP!!


As I said earlier, I agree 100% with KG. Recovery after RESETLOGS is
possible I've done several of these types of recoveries in preping for some
talks. KG is also right in that this is not supported by Oracle (but is
taught in their internal backup and recovery classes!!)

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Monday, March 18, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L


John !!

Notice the change in subject again !!

WARNING**
ORACLE WILL NOT SUPPORT THIS KIND OF RECOVERY.
*


I don't agree with you about the MANDATORY backup. You can still
recover the database COMPLETELY if you have all the archives from your
old backup (before RESETLOGS) and the NEW ARCHIVES (after RESETLOGS) as
long as if you have both (pre/post resetlogs) control files undamaged
and your database version is 7.3.3 and above.

I have once recovered a 8.0.5 database on Solaris using the backup (pre
RESETLOGS) and the archive logs of pre and post resetlogs. THis recovery
is based on SCN and Log Sequence has no role here.

THis is two part recovery (I have given the outline in a private mail)
and Oracle will not support this kind of recovery...


For the arguement sake I can tell YOU DON:T NEED ANY BACKUP AFTER RESETLOGS.
But since
this is an unsupported I strongly suggest Jared' point..
A COMPLETE COLD BACKUP AFTER RESETLOGS.






Best Regards,
K Gopalakrishnan
Bangalore, INDIA



-Original Message-
Kanagaraj
Sent: Monday, March 18, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L


Hi all,

Notice the renamed heading - this thread has really taken off!

Coming back to the issue: While I agree that you should not open the
database until after you backup (hot or cold), I am still rooting for a hot
backup. If you know the application well enough, you can perform 'selective
hot backup' of a required set of tablespaces that you know will be changed,
and continue hot backup of the others after the database is opened up. In a
cold backup situation, the whole database is down for backup (including
large TEMP tablespaces - 13Gb out of 130 Gb on one of my Production Apps
databases!) for a longer duration than is necessary, which does not look too
good on your availability reports. (And also remember to switch logfiles so
that archivelogs are generated prior to release to users).

Having said all that, a soft mirror that can be used exclusively for backup
is invaluable. The whole database can be put in backup mode for a short
time, the mirror 'broken' and the database backup ended. The mirror can then
be used for backup to tape. In addition to this, you also have an online
backup available (until the resilver starts) and you work off this disk
backup for producting clones. Let me say that again - Invaluable!

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Grace - Getting something we don't deserve
Mercy - NOT getting something we deserve

Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!

** The opinions and statements above are entirely my own and not those of my
employer or clients **


> 1. You do not open the database to users until AFTER you do a
> backup (hot or
> cold, dosen't mater) at point t2.
>
> 2. There is a method of recovering a database (8i +) after
> RESETLOGS has
> been
> issued with archived redo logs. I discussed it in my DBA

> > > * You *have* to take a COLD backup of the database after using
> > resetlogs.
> > > (Not required - a Hot backup and archive logs is
> adequate. All hot
> > backups /
> > > archive logs prior to that are invalid, though...)
> >
> > Consider the following:
> >
> > Time:
> >
> > t0: database restored
> > t1: database opened with RESETLOGS
> > t2: hot backup started ( database in archive log mode )
> > t3: users input very important transactions
> > t4: database crashes, and must be restored
> >
> > How will you recover the transactions from time t3?
>
> As long as the online redologs are available, this should be
> no problem. I
> have successfully recovered databases where a log switch did
> not occur and
> recovery had to use an online redo log. (I am assuming that the lost
> datafiles will be restored from this hot backup fresh off the tapes)
>
> On the other hand, if the online redolog is hosed you have lost the
> transactions anyway, _regardless_ of the fact that a Cold
> backup was taken.
> Then you will have to go back to the _previous_ incarnation
> and redo the
> restore and then perform a ccf/resetlogs (i.e. back to square
> one). If you
> have a Cold backup, you restore the cold backup and go on
> with life. I.e. in
> both cases (availability of cold or hot backup, lost online
> redo log), you
> have lost transactions...
>
> Additional

Electronic Laser Forms - Any recommendations?

2002-03-18 Thread DBarbour



Can anybody recommend a printing package for Oracle?  We have a number of
forms that need to be populated with Oracle data.  Examples are Report
Cards, Progress Reports, Immunization Letters.  The format of these
changes, so we need to have the ability to modify the ELF in-house.  The
platform is UNIX (HP-UX), and the printers are HPs(9000).

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Oracle Gold Support

2002-03-18 Thread JoJo Al-Zawawi


They made me purchase customer support before they would even tell me the
system requirements for 9i (which I had already purchased, including a
personal 2-year license).  It turns out that I need to buy more memory and
can't install the product.  That tee'd me off !  I couldn't get a
salesperson anywhere to tell me the requirements, and it definitely wasn't
on the product info pages on their site.

--JoJo


-Original Message-
Robert 
Sent: Monday, March 18, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L


Anyone else just slightly irritated with the level of customer support
offered for phone callers to Oracle now days? Used to be, that if you
were a gold customer as we are, you could almost count on instant first line
support. Last week I called and was told that a phone call would
result in at least a one hour delay in an analyst call back, whereas
an iTar (lie tars I call em) will get me about 30 minute response.
The representative was rude and snarly to me at the same time.
Is this how Larry wants to save that second billion, crappy customer
service?

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: JoJo Al-Zawawi
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Locally Managed Tablespaces


And the hot tip is that SYSTEM will be locally managed
(by default) from 9i.2, which (I hope) will render
dictionary managed tspaces to the dustbin.

Cheers
Connor

 --- "Jack C. Applewhite" <[EMAIL PROTECTED]>
wrote: > Antonio,
> 
> We use LMTs for all tablespaces - except for System,
> of course.  No issues,
> problems, etc.  We're happy.
> 
> 8.1.7.2.5 on Win2k; ~340GB in 29 tablespaces.
> 
> Jack
> 
> 
> Jack C. Applewhite
> Database Administrator/Developer
> OCP Oracle8 DBA
> iNetProfit, Inc.
> Austin, Texas
> www.iNetProfit.com
> [EMAIL PROTECTED]
> (512)327-9068
> 
> 
> -Original Message-
> [EMAIL PROTECTED]
> Sent: Monday, March 18, 2002 7:28 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Hi,
> 
> Anyone using LMT for rollback segments ? Any issues
> , suggestions , ... ?
> 
> TIA,
> Antonio Belloni
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Jack C. Applewhite
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO


Just to add to the controversy, I often make the
argument to developers/users/managers/etc that
noarchivelog does not exist.  

In my opinion, 'noarchivelog' is like waving a flag
saying "I stand an excellent chance of losing a whole
lot of data one day".

Some years ago at a place I worked, some idiot came up
with some piece of nonsense along the lines of "We
don't make any changes, we do a cold backup each
night, and we can easily reapply the flat files that
are sqlldr'd into the db each morning"... and thus
went for a noarchivelog strategy.

When it did go belly up, this "simple" option turned
into a nightmarish exercise...

Even worse, the idiot happened to be me at the time
:-)

 --- "Freeman, Robert " <[EMAIL PROTECTED]>
wrote: > I can read your question 2 ways, so let me
answer it
> both ways...
> 
> If you are asking if you can only do a cold backup
> when in noarchivelog
> mode, you are correct.
> 
> However, in archivelog mode you can do cold or hot
> backup. The procedure is
> a bit different in archivelog mode, because of the
> recovery implications of
> being in archivelog mode.
> 
> RF
> 
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
> 
> The Cigarette Smoking Man: Anyone who can appease a
> man's conscience can
> take his freedom away from him.
> 
> 
> 
> -Original Message-
> Sent: Monday, March 18, 2002 1:28 PM
> To: Multiple recipients of list ORACLE-L
> NOARCHIVELOG mo
> 
> 
> but isn't cold backup is possible only if ur running
> in noarchieve mode else
> you have to go for hot backup.
> BigP
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Monday, March 18, 2002 7:41 AM
> 
> 
> > Ok maybe you will think this is a silly
> thread, but I've wondered
> > about this before...
> >
> > We (DBA's) use the terms hot and cold backups all
> the time. I wonder
> though,
> > when we talk about cold backups if the terminology
> should not include the
> > mode of the backup:
> >
> > cold archivelog mode backup
> > cold noarchivelog mode backup
> >
> > When we say "cold" backup, do we just assume it's
> NOARCHIVELOG mode...and
> > enjoy the fact that we don't have to type or say
> as much...or should we be
> > more specific to help the junior DBA's (or perhaps
> even those out there
> who
> > have never really considered that there is a
> distinction between the two)
> > out there? When books are written, I notice that
> they mostly just talk
> about
> > hot and cold backups, assuming that the cold
> backup is in NOARCHIVELOG
> > mode...
> >
> > what about the junior DBA who does a cold backup
> in ARCHIVELOG mode and
> > follows the standard cold backup procedure
> (backing up control files and
> > redo logs) assuming that he can just recover
> them(granted, anyone
> should
> > test
> > their backup and recovery strategy, but this is a
> Jr. DBA!)
> >
> > Just thinking aloud... is it a silly question?
> >
> > Robert G. Freeman - Oracle8i OCP
> > Oracle DBA Technical Lead
> > CSX Midtier Database Administration
> >
> > The Cigarette Smoking Man: Anyone who can appease
> a man's conscience can
> > take his freedom away from him.
> >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Freeman, Robert
> >   INET: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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).
> >
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Big Planet
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Freeman, Robert 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

2002-03-18 Thread Alexander . Feinstein

Title: RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

Robert,

Let me disagree with you.
Cold *backup* is the same in archivelog mode and in noarchivelog mode.
The *recovery* is (could be) different.

Consider the following. I make a cold backup of a production DB, and restore into another server to build a test DB. What is wrong with this approach?

Alex.

-Original Message-
From: Freeman, Robert [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 11:48 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Should we say COLD or HOT backup OR ARCHIVELOG or
NOARCHIVELO

I agree with your definitionsbut the cold backup in archivelog mode is
fundamentally different from one done in noarchivelog more (with respect to
online redo logs and control files) if you are in archivelog mode and want
to be able to do point in time recovery.

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.

-Original Message-
Sent: Monday, March 18, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
NOARCHIVELOG mo

[EMAIL PROTECTED] wrote:

> but isn't cold backup is possible only if ur running in noarchieve mode
else
> you have to go for hot backup.
> BigP

OK let's get the definitions down first.  AFAIK:

cold backup := database shut down and an OS copy of all the necessary files.

hot backup := place TS in backup mode, the do an OS copy of the files 
for that TS.

first can be done to any database, second only to databases in 
archivelog mode.

-- 
--
Bill "Shrek" Thater  ORACLE DBA
 [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

I used to have a life, then I got v32bis!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: bill thater
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

process last non-idle time

2002-03-18 Thread DBarbour



>From v$sesstat - is this in seconds since the epoch?

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: CRONTAB JOB

2002-03-18 Thread Alexander Ordonez


try add the environment varriables into  the script file!


@L£K

  Lic. Alexander Ordóñez Arroyo 
  Caja Costarricense del Seguro Social 
  Soporte Técnico - División de Informática 
  Telefono: 295-2004, San José, Costa Rica
  [EMAIL PROTECTED]Icq# 30173325


The true is out there in WWW

> -Mensaje original-
> De:   Kevin Lange [SMTP:[EMAIL PROTECTED]]
> Enviado el:   Lunes 18 de Marzo de 2002 11:04 AM
> Para: Multiple recipients of list ORACLE-L
> Asunto:   RE: CRONTAB JOB
> 
> Also ... are there other cron jobs for that ID that already work ??  It
> could be that your sysop needs to give privledges for that ID to run a
> cron
> job.   Also, if the job is actually starting, check to make sure the
> environment is set right for it to find sqlplus.  We have to run a small
> script at the begining of our jobs to setup the correct paths.  As Suzy
> said, check mail to see if there are any outputs there that can help you
> debug.
> 
> -Original Message-
> Sent: Monday, March 18, 2002 10:45 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Cron has a log file, generally /var/cron/log (requires root privs to
> read it).  Also check for mail of the user executing the cron job for
> errors.
> 
> Hamid Alavi wrote:
> > 
> > Hi All,
> > 
> > I have a crontab job but this job never started, I have no idea what's
> > wrong, actualy i am not a unix person, here is the job:
> > cron job name is :  qqad.cron
> > 04 17 * * 1-5  /opt/qqad/sql/QQAD_backupscript.sh
> > and here is the QQAD_backupscript.sh (in /opt/qqad/sql)
> > 
> > sqlplus system/manager@QQAD @COLD_BAKUP_FOR_QQADha.SQL;
> cold_back.sql
> is
> > generated by COLD_BAKUP_FOR_QQADha.SQL
> > 
> > @/opt/qqad/sql/cold_back.sql;
> > 
> > If I run the job manualy it is going OK but crontab never start.
> > Any Idea??
> > 
> > Hamid Alavi
> > Office 818 737-0526
> > Cell818 402-1987
> > 
> > The information contained in this message and any attachments is
> intended
> > only for the use of the individual or entity to which it is addressed,
> and
> > may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
> > disclosure under applicable law. If you have received this message in
> error,
> > you are prohibited from copying, distributing, or using the information.
> > Please contact the sender immediately by return e-mail and delete the
> > original message from your system.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Hamid Alavi
> >   INET: [EMAIL PROTECTED]
> > 
> > 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: [EMAIL PROTECTED] (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).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Suzy Vordos
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kevin Lange
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexander Ordonez
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To R

Re: Oracle Gold Support

2002-03-18 Thread Brian McGraw


Robert -

I had the same experience a few months back.  I griped about it to the person on
the other end of the line, and eventually found out that the person I was
speaking with wasn't even an analyst with Oracle.  Just someone taking incoming
phone calls, similar to a messaging service.  Apparently the only way to get a
real analyst was to log a severity-1 issue.

Just my $.02...

Brian

"Freeman, Robert" wrote:

> Anyone else just slightly irritated with the level of customer support
> offered for phone callers to Oracle now days? Used to be, that if you
> were a gold customer as we are, you could almost count on instant first line
> support. Last week I called and was told that a phone call would
> result in at least a one hour delay in an analyst call back, whereas
> an iTar (lie tars I call em) will get me about 30 minute response.
> The representative was rude and snarly to me at the same time.
> Is this how Larry wants to save that second billion, crappy customer
> service?
>
> RF
>
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
>
> The Cigarette Smoking Man: Anyone who can appease a man's conscience can
> take his freedom away from him.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Freeman, Robert
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).

--
--
| Brian McGraw /* DBA */  Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brian McGraw
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Disk is cheap?

I think that with higher priced systems, this does become
an urban legend for just the reasons you cite. We run into 
this problem all the time.

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.

-Original Message-
Sent: Monday, March 18, 2002 3:33 PM
To: Multiple recipients of list ORACLE-L

Robert G. Freeman - Oracle8i OCP  wrote:
>  
> But disk is cheap, right...?
> Or is that yet another Urban Legend???

Yes, that's another Urban Legend.

Disk DRIVES are cheap, disk SPACE is not so cheap.

Consider this example: I have a disk cabinet with 24 slots and 23
disks. The 24th disk is cheap, but how much does the 25th disk cost? In
addition to the disk drive we need a cabinet, controllers, cache, host
adapters, cables, floor space, environmental controls, installation,
configuration, management, maintenance contract, and on and on.

Mark Stahlke
Oracle DuhBA
Denver Newspaper Agency
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stahlke, Mark
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Need a delete trigger that tracks deletes.

2002-03-18 Thread Browett, Darren


We need to be able to track what records have been deleted from a table.

Our current thinking is 
1. A "before delete" trigger, that stores a unique ID of the all the data in
the table.
2. A "after delete" trigger, which gets the records left in the table.
3. Subtract the two lists to find the records that have been deleted.

This appears to be cumbersome, is there anyway to do this with one trigger ?

Thanks

Darren



--
Darren Browett P.EngThis message
was transmitted
Data Administrator  using 100%
recycled electrons 
Information and Communication Technology
City of Coquitlam 
P:(604)927 - 3614 
E:[EMAIL PROTECTED] 

--- 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Browett, Darren
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

I agree... cold can be the same, but recovery is different.

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 4:23 PM
To: Multiple recipients of list ORACLE-L

Robert, 

Let me disagree with you. 
Cold *backup* is the same in archivelog mode and in noarchivelog mode. 
The *recovery* is (could be) different. 

Consider the following. I make a cold backup of a production DB, and restore
into another server to build a test DB. What is wrong with this approach?

Alex. 

-Original Message- 
 ] 
Sent: Monday, March 18, 2002 11:48 AM 
To: Multiple recipients of list ORACLE-L 
NOARCHIVELO 

I agree with your definitionsbut the cold backup in archivelog mode is 
fundamentally different from one done in noarchivelog more (with respect to 
online redo logs and control files) if you are in archivelog mode and want 
to be able to do point in time recovery. 

Robert G. Freeman - Oracle8i OCP 
Oracle DBA Technical Lead 
CSX Midtier Database Administration 

The Cigarette Smoking Man: Anyone who can appease a man's conscience can 
take his freedom away from him. 

-Original Message- 
Sent: Monday, March 18, 2002 2:04 PM 
To: Multiple recipients of list ORACLE-L 
NOARCHIVELOG mo 

[EMAIL PROTECTED] wrote: 

> but isn't cold backup is possible only if ur running in noarchieve mode 
else 
> you have to go for hot backup. 
> BigP 

OK let's get the definitions down first.  AFAIK: 

cold backup := database shut down and an OS copy of all the necessary files.

hot backup := place TS in backup mode, the do an OS copy of the files 
for that TS. 

first can be done to any database, second only to databases in 
archivelog mode. 

-- 
-- 
Bill "Shrek" Thater  ORACLE DBA 
 [EMAIL PROTECTED] 

You gotta program like you don't need the money, 
You gotta compile like you'll never get hurt, 
You gotta run like there's nobody watching, 
It's gotta come from the heart if you want it to work. 

I used to have a life, then I got v32bis! 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
Author: bill thater 
  INET: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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). 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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). 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

2002-03-18 Thread Jesse, Rich


Unless you're database is being used exclusively for Oracle Internet
Directory, in which case Oracle Corp says that traditional methods of DB
backup and recovery are not applicable in most cases.

And since we're running Oracle ASR, I plan on keeping the RDS in
NOARCHIVELOG mode.  We're already backing up the DB three times (once with
ASR, once DB-wise, and the other LDAP-wise), so no need for this (in our
case).  It'll just add overhead.

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA


-Original Message-
Sent: Monday, March 18, 2002 3:28 PM
To: Multiple recipients of list ORACLE-L
NOARCHIVELO


Just to add to the controversy, I often make the
argument to developers/users/managers/etc that
noarchivelog does not exist.  

In my opinion, 'noarchivelog' is like waving a flag
saying "I stand an excellent chance of losing a whole
lot of data one day".

Some years ago at a place I worked, some idiot came up
with some piece of nonsense along the lines of "We
don't make any changes, we do a cold backup each
night, and we can easily reapply the flat files that
are sqlldr'd into the db each morning"... and thus
went for a noarchivelog strategy.

When it did go belly up, this "simple" option turned
into a nightmarish exercise...

Even worse, the idiot happened to be me at the time
:-)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Oracle Gold Support


I don't understand this the product (the RDBMS) can be downloaded
for FREE from oracle.com.the doc's are free to look at at 
technet.oracle.com, including specific platform install guides which
contain product requirements (as seen here)

http://otn.oracle.com/docs/products/oracle9i/doc_library/90111install/reqs.h
tm#1195223

All the requirements are freely available. While I think it was terrible
that your sales folks didn't know what these requirements were, I think
it is inaccurate to say that you were made to purchase anything. All the
info is freely available... in fact a google search for 
"Oracle9i Memory requirements" found me plenty of information. I think you
bear some responsibility in this as well.
 

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Monday, March 18, 2002 4:33 PM
To: Multiple recipients of list ORACLE-L


They made me purchase customer support before they would even tell me the
system requirements for 9i (which I had already purchased, including a
personal 2-year license).  It turns out that I need to buy more memory and
can't install the product.  That tee'd me off !  I couldn't get a
salesperson anywhere to tell me the requirements, and it definitely wasn't
on the product info pages on their site.

--JoJo


-Original Message-
Robert 
Sent: Monday, March 18, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L


Anyone else just slightly irritated with the level of customer support
offered for phone callers to Oracle now days? Used to be, that if you
were a gold customer as we are, you could almost count on instant first line
support. Last week I called and was told that a phone call would
result in at least a one hour delay in an analyst call back, whereas
an iTar (lie tars I call em) will get me about 30 minute response.
The representative was rude and snarly to me at the same time.
Is this how Larry wants to save that second billion, crappy customer
service?

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: JoJo Al-Zawawi
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Learn from my mistakes! Or "Helpful DBA hint of the day"

2002-03-18 Thread Khedr, Waleed


I do not see a difference between connecting / as sysdba or sys as sysdba
the final result is connecting as SYS.

I do not think this has anything to do with the errors you had.

Regards,

Waleed

-Original Message-
Sent: Monday, March 18, 2002 3:43 PM
To: Multiple recipients of list ORACLE-L


In 9.0.1, when you create a DB, you would "connect / as sysdba".  However,
if you also run "catalog" and "catproc" while connected like this, Oracle
Advanced Symmetric Replication WILL NOT WORK.  You *MUST* be connected as
"SYS as sysdba".

It's taken me forever to find this.  The biggest clue I had was a number of
ORA-06550 errors in the create logs that point to a character set mismatch.
Of course, I found an article on Metaclink that said this may be normal, so
I ignored them at first.  (I can't find that article again!)

I know I've sent out at least one other message like this, but these little
things can really come back and haunt a person.  And maybe the next time I
have this and send a message to the list, someone with a real memory can
help me!

Enjoy!  :)

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Need a delete trigger that tracks deletes.

2002-03-18 Thread Kevin Lange


Why not simply a Before Delete trigger that copies the row about to be
deleted over to a duplicate table.  This way you can know exactly what the
data was before it was deleted.   Of course, if you only care about a
certain field or group of fields you can always just copy those fields
instead of all fields.

-Original Message-
Sent: Monday, March 18, 2002 4:18 PM
To: Multiple recipients of list ORACLE-L


We need to be able to track what records have been deleted from a table.

Our current thinking is 
1. A "before delete" trigger, that stores a unique ID of the all the data in
the table.
2. A "after delete" trigger, which gets the records left in the table.
3. Subtract the two lists to find the records that have been deleted.

This appears to be cumbersome, is there anyway to do this with one trigger ?

Thanks

Darren



--
Darren Browett P.EngThis message
was transmitted
Data Administrator  using 100%
recycled electrons 
Information and Communication Technology
City of Coquitlam 
P:(604)927 - 3614 
E:[EMAIL PROTECTED] 

--- 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Browett, Darren
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Fav. Urban Legend...

2002-03-18 Thread Joseph S Testa


init.ora parm:  _MAKE_SQL_RUN_FASTER=

valid values:

8.0 = true/false
8.1 = x where x is a number between 1 and 100
9.0 = x or unlimited <-- this gives you the ultimate speed in queries

joe



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S Testa
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend... Hot vs Cold

2002-03-18 Thread Sakthi , Raj


Bob,
Yes... For Business Continuance (HP) or SRDF (EMC)
kinda solutions it is becoming an urban Legend. I will
give you an example...
1.2 TB usable disk spsce by HP's XP disk solution
costs us almost 800 K USD , that too after all kinds
of discounts.

Like John said, considering it saves a whole lot of
trouble and kinda fun to have around, it is
invaluable...provided you can persuade damagement to
part with that kinda money..;)

Cheers,
RS

--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote:
> John,
> 
> Yes, and I could kick myself for not thinking of
> this, mirrors can be a most
> excellent alternative to backups both production and
> after a recovery. Of 
> course, it can be an expensive alternative as it
> requires you to have
> 2x disk space... :-)
> 
> But disk is cheap, right...?
> 
> Or is that yet another Urban Legend???
> 
> RF
> 
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
> 
> The Cigarette Smoking Man: Anyone who can appease a
> man's conscience can
> take his freedom away from him.
> 
> 
> 
> -Original Message-
> Sent: Monday, March 18, 2002 1:18 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi all,
> 
> Notice the renamed heading - this thread has really
> taken off!
> 
> Coming back to the issue: While I agree that you
> should not open the
> database until after you backup (hot or cold), I am
> still rooting for a hot
> backup. If you know the application well enough, you
> can perform 'selective
> hot backup' of a required set of tablespaces that
> you know will be changed,
> and continue hot backup of the others after the
> database is opened up. In a
> cold backup situation, the whole database is down
> for backup (including
> large TEMP tablespaces - 13Gb out of 130 Gb on one
> of my Production Apps
> databases!) for a longer duration than is necessary,
> which does not look too
> good on your availability reports. (And also
> remember to switch logfiles so
> that archivelogs are generated prior to release to
> users).
> 
> Having said all that, a soft mirror that can be used
> exclusively for backup
> is invaluable. The whole database can be put in
> backup mode for a short
> time, the mirror 'broken' and the database backup
> ended. The mirror can then
> be used for backup to tape. In addition to this, you
> also have an online
> backup available (until the resilver starts) and you
> work off this disk
> backup for producting clones. Let me say that again
> - Invaluable!
> 
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
> 
> Grace - Getting something we don't deserve
> Mercy - NOT getting something we deserve
> 
> Click on 'http://www.needhim.org' for Grace and
> Mercy that is freely
> available!
> 
> ** The opinions and statements above are entirely my
> own and not those of my
> employer or clients **
> 
> 
> > 1. You do not open the database to users until
> AFTER you do a 
> > backup (hot or
> > cold, dosen't mater) at point t2.
> > 
> > 2. There is a method of recovering a database (8i
> +) after 
> > RESETLOGS has
> > been
> > issued with archived redo logs. I discussed it in
> my DBA 
> 
> > > > * You *have* to take a COLD backup of the
> database after using 
> > > resetlogs.
> > > > (Not required - a Hot backup and archive logs
> is 
> > adequate. All hot 
> > > backups /
> > > > archive logs prior to that are invalid,
> though...)
> > > 
> > > Consider the following:
> > > 
> > > Time:
> > > 
> > > t0: database restored
> > > t1: database opened with RESETLOGS
> > > t2: hot backup started ( database in archive log
> mode )
> > > t3: users input very important transactions
> > > t4: database crashes, and must be restored
> > > 
> > > How will you recover the transactions from time
> t3?
> > 
> > As long as the online redologs are available, this
> should be 
> > no problem. I
> > have successfully recovered databases where a log
> switch did 
> > not occur and
> > recovery had to use an online redo log. (I am
> assuming that the lost
> > datafiles will be restored from this hot backup
> fresh off the tapes)
> > 
> > On the other hand, if the online redolog is hosed
> you have lost the
> > transactions anyway, _regardless_ of the fact that
> a Cold 
> > backup was taken.
> > Then you will have to go back to the _previous_
> incarnation 
> > and redo the
> > restore and then perform a ccf/resetlogs (i.e.
> back to square 
> > one). If you
> > have a Cold backup, you restore the cold backup
> and go on 
> > with life. I.e. in
> > both cases (availability of cold or hot backup,
> lost online 
> > redo log), you
> > have lost transactions... 
> > 
> > Additionally, with a Hot backup and depending on
> what was 
> > lost, you can at
> > least perform tablespace/datafile recovery . With
> a cold 
> > backup, you will
> > have to restore the whole database
> > 
> > The point I was trying to make was that a Cold
> backup after a 
> > RESETLOGS does
> > not serve anything. Maybe t

RE: Oracle Gold Support

2002-03-18 Thread Orr, Steve

Try to find a way to get turbo-charged...
http://www.macwhiz.com/articles/art-of-turboing.html

-Original Message-
Sent: Monday, March 18, 2002 2:18 PM
To: Multiple recipients of list ORACLE-L

Robert -

I had the same experience a few months back.  I griped about it to the
person on
the other end of the line, and eventually found out that the person I was
speaking with wasn't even an analyst with Oracle.  Just someone taking
incoming
phone calls, similar to a messaging service.  Apparently the only way to get
a
real analyst was to log a severity-1 issue.

Just my $.02...

Brian

"Freeman, Robert" wrote:

> Anyone else just slightly irritated with the level of customer support
> offered for phone callers to Oracle now days? Used to be, that if you
> were a gold customer as we are, you could almost count on instant first
line
> support. Last week I called and was told that a phone call would
> result in at least a one hour delay in an analyst call back, whereas
> an iTar (lie tars I call em) will get me about 30 minute response.
> The representative was rude and snarly to me at the same time.
> Is this how Larry wants to save that second billion, crappy customer
> service?
>
> RF
>
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: Oracle Gold Support

2002-03-18 Thread Brian_P_MacLean









Don't blame the support tech. person, I'm sure they are more stressed that
we are.

Oracle support has been going into http://www.theshitter.com for some 2
years now.  Remember when you could get a 1-off patch  Now all I hear
is upgrade to the current release, or it's fixed in the next release that
is scheduled for released in a few weeks, or (and I luv this one) it's
fixed in Oracle9i.  And every time I upgrade it breaks something else
and/or introduces a new bug that starts the support/upgrade loop all over.

I think Oracle's development motto has become "Quality was release 7.3.4".

Sorry for the rant.


Brian P. MacLean
Oracle DBA, OCP8i



   
   
"Freeman,  
   
Robert " To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>  
   Subject: Oracle Gold Support  
   
Sent by:   
   
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
03/18/02 12:43 
   
PM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Anyone else just slightly irritated with the level of customer support
offered for phone callers to Oracle now days? Used to be, that if you
were a gold customer as we are, you could almost count on instant first
line
support. Last week I called and was told that a phone call would
result in at least a one hour delay in an analyst call back, whereas
an iTar (lie tars I call em) will get me about 30 minute response.
The representative was rude and snarly to me at the same time.
Is this how Larry wants to save that second billion, crappy customer
service?

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).






--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Fav. Urban Legend...


Robert - So THAT is the title of your next book. I'm primed to buy it
already.
I just recalled a legend, maybe. "Disk is 10,000 times slower than memory,
so memory access times are infinitesimal compared to disk access". Cary
Millsap covers this in his Hotsos Clinic. He has run tests that prove "ain't
so". The point is that you can't just use ratios to tune Oracle, but need to
look at wait times.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, March 18, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L


So, does the CoO (Church of Oracle) have an infallibility doctrine then???

... From the Book of Oracle, chapter 5 ...

...and the DBA did look upon his database, and he saw it was good.
His tablespace datafiles being distributed tither and fro, spread amongst
the
platters of his disks. And he did complete that which was called
documentation,
and then he rested from his labors, and drank Mountain Dew Code Red...


:-)

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Monday, March 18, 2002 12:25 PM
To: Multiple recipients of list ORACLE-L



Hey, you're an author!

I expect perfection, grace and infallibility.  ;)

Jared

On Monday 18 March 2002 07:33, Freeman, Robert  wrote:
> And hey, it was Sunday morning at 0700 something... what do you
> expect from me anyways??? :-)))
>
> RF
>
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
>
> The Cigarette Smoking Man: Anyone who can appease a man's conscience can
> take his freedom away from him.
>
>
>
> -Original Message-
> Sent: Sunday, March 17, 2002 6:43 PM
> To: Multiple recipients of list ORACLE-L
>
> On Sunday 17 March 2002 07:53, Freeman, Robert  wrote:
> > 1. You do not open the database to users until AFTER you do a backup
(hot
> > or cold, dosen't mater) at point t2.
>
> Well, yeah, that was the point.  It doesn't have to be a cold backup, but
> since you can't do any work, it may as well be a cold backup.
>
> Jared
>
> > 2. There is a method of recovering a database (8i +) after RESETLOGS has
> > been
> > issued with archived redo logs. I discussed it in my DBA World Tour
> > backup and
> > recovery presentation. To do this, you MUST have the control file for
the
> > database from BEFORE the resetlogs operation, and backup of the control
> > file from AFTER the same operation. I've done this about 3 times in
>
> testing
>
> > and it works fine but it very very picky about the control file images.
> >
> > RF
> >
> > Robert G. Freeman - Oracle8i OCP
> > Oracle DBA Technical Lead
> > CSX Midtier Database Administration
> >
> > The Cigarette Smoking Man: Anyone who can appease a man's conscience can
> > take his freedom away from him.
> >
> >
> >
> > -Original Message-
> > Sent: Friday, March 15, 2002 7:28 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi Jared,
> >
> > > > * You *have* to take a COLD backup of the database after using
> > >
> > > resetlogs.
> > >
> > > > (Not required - a Hot backup and archive logs is adequate. All hot
> > >
> > > backups /
> > >
> > > > archive logs prior to that are invalid, though...)
> > >
> > > Consider the following:
> > >
> > > Time:
> > >
> > > t0: database restored
> > > t1: database opened with RESETLOGS
> > > t2: hot backup started ( database in archive log mode )
> > > t3: users input very important transactions
> > > t4: database crashes, and must be restored
> > >
> > > How will you recover the transactions from time t3?
> >
> > As long as the online redologs are available, this should be no problem.
> > I have successfully recovered databases where a log switch did not occur
> > and recovery had to use an online redo log. (I am assuming that the lost
> > datafiles will be restored from this hot backup fresh off the tapes)
> >
> > On the other hand, if the online redolog is hosed you have lost the
> > transactions anyway, _regardless_ of the fact that a Cold backup was
>
> taken.
>
> > Then you will have to go back to the _previous_ incarnation and redo the
> > restore and then perform a ccf/resetlogs (i.e. back to square one). If
> > you have a Cold backup, you restore the cold backup and go on with life.
> > I.e. in both cases (availability of cold or hot backup, lost online redo
> > log), you have lost transactions...
> >
> > Additionally, with a Hot backup and depending on what was lost, you can
> > at least perform tablespace/datafile recovery . With a cold backup, you
> > will have to restore the whole database
> >
> > The point I was trying to make was that a Cold backup after a RESETLOGS
> > does not serve anything. Maybe there is still a gotcha I have not been
>
> able
>
> > to figure out, so Backup/restore Gurus: take a bash at this logic! I
> > would love to be corrected

Re: Need a delete trigger that tracks deletes.

2002-03-18 Thread Paul Baumgartel


Sure.  Create a journal table whose structure is the same as the table
of interest, with the addition of "user", "timestamp", and whatever
else you're interested in tracking.  In your "before delete" trigger,
just write the about-to-be-deleted row to the journal table, with the
additional columns populated appropriately.

Paul Baumgartel

-- "Browett, Darren" <[EMAIL PROTECTED]> wrote:
> We need to be able to track what records have been deleted from a
> table.
> 
> Our current thinking is 
> 1. A "before delete" trigger, that stores a unique ID of the all the
> data in
> the table.
> 2. A "after delete" trigger, which gets the records left in the
> table.
> 3. Subtract the two lists to find the records that have been deleted.
> 
> This appears to be cumbersome, is there anyway to do this with one
> trigger ?
> 
> Thanks
> 
> Darren
> 
> 
>

> --
> Darren Browett P.Eng  This message
> was transmitted
> Data Administratorusing 100%
> recycled electrons 
> Information and Communication Technology
> City of Coquitlam 
> P:(604)927 - 3614 
> E:[EMAIL PROTECTED] 
>

> --- 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Browett, Darren
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).


__
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Oracle Gold Support


Oracle is shunting everyone to METALINK support. Fundamental
misunderstanding on their part. They think because we administer computers
that we LIKE to use computers.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, March 18, 2002 1:43 PM
To: Multiple recipients of list ORACLE-L


Anyone else just slightly irritated with the level of customer support
offered for phone callers to Oracle now days? Used to be, that if you
were a gold customer as we are, you could almost count on instant first line
support. Last week I called and was told that a phone call would
result in at least a one hour delay in an analyst call back, whereas
an iTar (lie tars I call em) will get me about 30 minute response.
The representative was rude and snarly to me at the same time.
Is this how Larry wants to save that second billion, crappy customer
service?

RF

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO