RE: Identification of tables NOT being used in the System.
Title: RE: Identification of tables NOT being used in the System.
There was a note previously on a similar theme which I have posted below.
The dba_tab_modifications does not show when a table has been selected from which could be a problem for reference data type table which can easily be overlooked.
+ Previous notes
Tony is thinking along the same lines I was. Go ahead and capture the
outlines and then querying the DD where the indexes aren't found in the
OL$HINTS.HINT_TEXT column could tell you what indices haven't been used.
Something like:
select i.owner, i.table_name, i.index_name
from dba_indexes i, outln.OL$HINTS h
where index_name not like ('%'||hint_text||'%')
and owner not in ('SYS','SYSTEM','PORTAL30','DES6I')
Just add the schema's to exclude. Only as good as the code coverage from
your collection timeframe but still seems like a pretty solid approach.
Anyone tried this? I've kicked it around but have never actually tried it in
anything other than a test environment.
Regards,
Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781
-Original Message-
Sent: Monday, February 04, 2002 4:31 PM
To: Multiple recipients of list ORACLE-L
Another option you have if your Oracle version is high enough is to use
Stored Outlines. Enable automatic generation of stored outlines for a full
processing cycle as defined by the application (full month, Qtr, etc.) Then
extract all of the indexes used during that cycle from OL$HINTS.HINT_TEXT
(i.e.. WHERE HINT_TEXT LIKE 'INDEX%'). If all of your application code has
been traversed in the cycle then this list will be pretty darn close to real
usage. Even if you can't wait until year-end processing, you can eliminate
the bulk of code to be mined for embedded SQL and focus on those once-a-year
programs.
HTH
Tony Aponte
-Original Message-
Sent: Monday, February 04, 2002 12:55 PM
To: Multiple recipients of list ORACLE-L
Hi
I there any view which can tell us which indexes are not in use?
Thx
-Seema
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent: 15 March 2002 21:49
To: Multiple recipients of list ORACLE-L
Subject: RE: Identification of tables NOT being used in the System.
ALTER TABLE tablename MONITORING;
Every three hours or so, the SYS.DBA_TAB_MODIFICATIONS view gets updated
with the tables UPDATEs, DELETEs, and INSERTs, as well as wether or not the
table has been TRUNCATEd since the last time it was DBMS_STATS'd. The view
also gets updated on a SHUTDOWN, except for SHUTDOWN ABORT. I believe that
if there's no activity on the table you set for MONITORING, that there will
not be a row for it in this view.
And if you use CBO, you'll want to save the rows from DBA_TAB_MODIFICATIONS
to your own table before using DBMS_STATS. It will zero the counters in the
view for the tables it's run against.
Also, there's very little overhead, at least according to Oracle.
HTH! You might want to look this up in Metalink or the Oracle docs, too.
Enjoy! :)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Friday, March 15, 2002 3:08 PM
To: Multiple recipients of list ORACLE-L
In our production database environment, I have a list of about 1000 tables
,for which we want to find if these tables are being used by anyone. How it
can be done. One of the ideas is that we start database auditing on these
tables for a considerable period of time say one month. Then for those
tables for which there is nothing in database audit, we assume that tables
are not being used. For this option I would like to know if we put auditing
on these 1000 tables, how much extra burden it is add onto the system (CPU,
Memory etc). We are using Oracle 8.1.6 on HP-UX 11.00.
If there are some other alternatives, please let me know.
Thanks.
--
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).
=
This electronic message contains information from the mmO2 plc Group
which may be privileged or confidential. The information is intended to be
for the use of the individual(s) or entity named above. If you are not the
intended recipient be aware that any disclosure, copying, distribution or
use of the contents of this information is prohibited. If you have received
this electronic message in error, please notify us by
dbms_jobs and redo activity
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).
Re: dbms_jobs and redo activity
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
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
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
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
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
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
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,
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
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:
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
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 SDGE 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 message BODY,
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, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also
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 ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
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
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
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
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
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
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
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 possible?
Re: Excel to Oracle
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
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
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
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
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
Hi... Here we use a text file .css generated in Excel and then we use sqlloader... it's very fast.. bye ATT 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: Installs and Extra Cost Options
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 To REMOVE yourself from this mailing
Re: Fav. Urban Legend...
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 ???
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
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
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
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
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
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: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--
Re: Should we say COLD or HOT backup OR ARCHIVELOG or 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).
RE:
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
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
[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-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing
RE: Fav. Urban Legend... NOBACKUP!!
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...) John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace -
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
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?
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
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...
[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?
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 ???
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 leslie_y_lu@yahoTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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
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
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
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 or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
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!!
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... Additionally, with a Hot backup and depending on what was lost, you can at
Electronic Laser Forms - Any recommendations?
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
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 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
RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO
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
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
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 REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
Re: Oracle Gold Support
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.
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- mailto:[EMAIL PROTECTED] ] 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 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 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
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
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.
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...
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
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 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
RE: Oracle Gold Support
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
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] Robert_Freema cc: [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. (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):
Re: Need a delete trigger that tracks deletes.
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
Connor - Good points, but obviously there are exceptions. We have a data warehouse that we keep in NOARCHIVELOG mode. After the weekly load we do a cold backup. However, lately there has been talk of some updates during the week, so that may have to change. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -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 :-) --- 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
RE: Need a delete trigger that tracks deletes.
Another idea is to mark the record deleted instead of physically deleting it. Regards, Waleed -Original Message- Sent: Monday, March 18, 2002 5: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: 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: Oracle Gold Support
Microsoft used to give out memory requirements for their software, and it seems to me almost every time they underestimated the minimum requirements. I myself prefer no information to misleading information. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, March 18, 2002 5:33 PM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle Gold Support 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: Boivin, Patrice J 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
At the time, I was brand-spankin' new to Oracle, and didn't even know technet existed. I was looking at the product info pages where you purchase products (which usually at least show system requirements when you click on the more info button type of thing). Since I couldn't find the data there, I called Sales, who could not help me... they assured me that they were sure my system was up to snuff (with 192 megs RAM). When I tried to install, it bombed repeatedly and had to be manually uninstalled each time. I couldn't get any help whatsoever at all unless I purchased service, at which time they told me simply that I needed more memory (256 megs). Even buying service was a pain in the behind -- apparently it's a new thing that you can buy service after buying the license, and the service sales dept didn't know about this. Don't forget that they also entered 2 separate invoices for the license and charged my credit card twice (at several hundred bucks a pop). That was a whole other story, getting that fixed up. With 40,000 employees, I found that dealing with Oracle was like dealing with a small country. --JoJo -Original Message- Robert Sent: Monday, March 18, 2002 2:29 PM To: Multiple recipients of list ORACLE-L 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:
RE: is Oracle really planning to desupport RBO?
All I know is that the RBO doesn't take advantage of new features as they are added in newer versions. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Monday, March 18, 2002 3:23 PM To: Multiple recipients of list ORACLE-L Subject:is Oracle really planning to desupport RBO? 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: Electronic Laser Forms - Any recommendations?
Oracle reports? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Monday, March 18, 2002 4:18 PM To: Multiple recipients of list ORACLE-L Subject:Electronic Laser Forms - Any recommendations? 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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
Having some data would have been far better than no data for me -- would have saved me several hundred dollars. I would have purchased 8i instead. I'm learning Oracle -- the classes aren't even for 9i anyway. They're for 8i. As it is, I wasted several hundred dollars. Cheers, JoJo -Original Message- Patrice J Sent: Monday, March 18, 2002 3:43 PM To: Multiple recipients of list ORACLE-L Microsoft used to give out memory requirements for their software, and it seems to me almost every time they underestimated the minimum requirements. I myself prefer no information to misleading information. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, March 18, 2002 5:33 PM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle Gold Support 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: Boivin, Patrice J 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
RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO
Here is en exception: I happen to administer a couple of data mart databases, that are loaded once or twice a month. Both run in noarchive log mode. This is how these have been set up when we started back in 1998. We take cold backups after the data load, table/partition analyze. It takes 5 hours max on a Sunday. No other changes are made to any of the data till the next data load. We have yet to see a reason for these databases to be running in archivelog mode. In the worst case, the recovery of the largest db (80GB) is about 8 hours from backups (Yes, we do DRP drills). And that type of downtime is perfectly alright with the business and end users. - Kirti -Original Message- Sent: Monday, March 18, 2002 4:59 PM To: Multiple recipients of list ORACLE-L NOARCHIVELO Connor - Good points, but obviously there are exceptions. We have a data warehouse that we keep in NOARCHIVELOG mode. After the weekly load we do a cold backup. However, lately there has been talk of some updates during the week, so that may have to change. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -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 :-) --- 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).
RE: Fav. Urban Legend...
And here I am trying to make things so complicated ;-) And for repeat billings, create an invisible DBMS_JOB (_invisible_jobs = TRUE) that calls a routine that resets the value to 1. Schedule to run 6 months once your contract ends. Sure to get a call. Larry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Joseph S Testa Sent: Monday, March 18, 2002 4:38 PM To: Multiple recipients of list ORACLE-L Subject: Re: Fav. Urban Legend... 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: Larry Elkins 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
Hi, Pardon me if I am wrong, I thought the only reason for the database to be in archive log mode is so that I can recover the database up to the time when the database crushes. For example, we do cold backup nitely. If the database were to crush etc at 2pm, I would be able to recover my database up to 2pm by using the cold backup and the archive log generated until 2 pm. However, if my database has no archivelog, I can only recover my database using the backup last nite. In my opinion, database in archive log mode is very important if I need to be able to recover the database up to the point of failure. Please correct me if I am wrong. Thanks. Regds, New Bee -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 8:13 AM To: Multiple recipients of list ORACLE-L Subject:RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO Here is en exception: I happen to administer a couple of data mart databases, that are loaded once or twice a month. Both run in noarchive log mode. This is how these have been set up when we started back in 1998. We take cold backups after the data load, table/partition analyze. It takes 5 hours max on a Sunday. No other changes are made to any of the data till the next data load. We have yet to see a reason for these databases to be running in archivelog mode. In the worst case, the recovery of the largest db (80GB) is about 8 hours from backups (Yes, we do DRP drills). And that type of downtime is perfectly alright with the business and end users. - Kirti -Original Message- Sent: Monday, March 18, 2002 4:59 PM To: Multiple recipients of list ORACLE-L NOARCHIVELO Connor - Good points, but obviously there are exceptions. We have a data warehouse that we keep in NOARCHIVELOG mode. After the weekly load we do a cold backup. However, lately there has been talk of some updates during the week, so that may have to change. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -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 :-) --- 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
EDI Translator
Hi Friends : Does anyone use EDI Translator ? Is it a toool of Oracle's ERP ? Does anyone use translation from EDIFACT using pl/sql ? What resource is used for it ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta 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
No no.. You are correct. In my case, since no changes are made to the database other than the data loads, and there are no issues about recovering from the last cold backup the downtime involved, we can live with noarchivelog mode. That's all. Cold backups with noarchivelog mode are useless if point-in-time recovery is desired. It all depends on the requirements. - Kirti -Original Message- Sent: Monday, March 18, 2002 7:03 PM To: Multiple recipients of list ORACLE-L NOARCHIVELO Hi, Pardon me if I am wrong, I thought the only reason for the database to be in archive log mode is so that I can recover the database up to the time when the database crushes. For example, we do cold backup nitely. If the database were to crush etc at 2pm, I would be able to recover my database up to 2pm by using the cold backup and the archive log generated until 2 pm. However, if my database has no archivelog, I can only recover my database using the backup last nite. In my opinion, database in archive log mode is very important if I need to be able to recover the database up to the point of failure. Please correct me if I am wrong. Thanks. Regds, New Bee -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 8:13 AM To: Multiple recipients of list ORACLE-L Subject:RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO Here is en exception: I happen to administer a couple of data mart databases, that are loaded once or twice a month. Both run in noarchive log mode. This is how these have been set up when we started back in 1998. We take cold backups after the data load, table/partition analyze. It takes 5 hours max on a Sunday. No other changes are made to any of the data till the next data load. We have yet to see a reason for these databases to be running in archivelog mode. In the worst case, the recovery of the largest db (80GB) is about 8 hours from backups (Yes, we do DRP drills). And that type of downtime is perfectly alright with the business and end users. - Kirti -Original Message- Sent: Monday, March 18, 2002 4:59 PM To: Multiple recipients of list ORACLE-L NOARCHIVELO Connor - Good points, but obviously there are exceptions. We have a data warehouse that we keep in NOARCHIVELOG mode. After the weekly load we do a cold backup. However, lately there has been talk of some updates during the week, so that may have to change. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -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 :-) --- 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:
RE: Fav. Urban Legend...
We'll remember that Jared when your book comes out;-) -Original Message- Sent: Monday, March 18, 2002 9:25 AM 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 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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
RE: is Oracle really planning to desupport RBO?
They have been saying that for years. First they must rewrite their own system. -Original Message- Bill Sent: Monday, March 18, 2002 11:23 AM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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
Report the rude dude. However, I have gotten really good response from using Metalink (also Gold support) for level 1 tars. The good thing is, since you are putting it in it gets in correctly. I actually think Oracle has greatly improved their support. Are they perfect? No, but I do believe they are working on it. Complaining to us though will get you no where (other then venting:-) Complain to those who can do something about it even if you think they won't. They may just surprise you someday. -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: Kimberly Smith 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?
touché -Original Message- Mark Sent: Monday, March 18, 2002 12: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: Kimberly Smith 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).
