RE: Increase size of REDO log

2002-07-08 Thread Taylor, Shirley

Look on Metalink for Note # 30910.1
It's an excellent guide for recreating redo logs as well as other objects.
Shirley

 -Original Message-
Sent:   Monday, July 08, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Increase size of REDO log

"Nguyen, David M" wrote:
> 
> How do I increase size of redo logs and how do I create additional redo
> logs?
> 
> Thanks,
> David
> --

ALTER DATABASE

You must drop and recreate log files to change their size, which will
bring you to force a log switch. 
-- 
Regards,

Stephane Faroult
Oriole Software
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Taylor, Shirley
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Appending date to export file name in NT

2002-05-21 Thread Taylor, Shirley



Hi Everyone,
I can easily append the date to my export file names in unix. Can anyone
tell me how to do on NT.  An example would be great!  I've had very little
NT experience. Thanks for any help.
Shirley :-)

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Compressing Export Dumps / WinZip

2002-05-16 Thread Taylor, Shirley

Doesn't it mean that all rows are compressed into 1 extent?


 -Original Message-
Sent:   Thursday, May 16, 2002 12:08 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Compressing Export Dumps / WinZip

I don't know whether this is a tangent, but I notice that on the windows
platform, "compressed" exports can still get 85% compression when zipping
them with WinZip.

Obviously Oracle "compressed=y" doesn't mean "compress the export file", it
just means that it places all the segments contiguously in the export file.

Right?

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]
-- 
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: Taylor, Shirley
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Good DBA vs. Bad DBA

2002-05-07 Thread Taylor, Shirley

Any replies?
:-)



 -Original Message-
Sent:   Monday, May 06, 2002 10:58 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Good DBA vs. Bad DBA

Dare I ask... do you have a Good Manager vs. Bad Manager list?

;o)

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
Sent: Monday, May 06, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L


I posted my list of Good DBA vs. Bad DBA on the DBA Pipeline
(www.revealnet.com),
and it was suggested I share it here, which I am doing comments most
welcome.
(If you saw this list on Revealnet, I've made some minor adjustments...)

Roberts Rules of Good DBA vs. Bad DBA 

Good DBA - Proactive
Bad DBA - Reactive
Good DBA - Knows how to RTFM
Bad DBA - Has never cracked the FM
Good DBA - Analyzes and comments
Bad DBA - Just comments
Good DBA - Not always right and admits it
Bad DBA - Rarely right and denies it.
Good DBA - Never Ever Ever content
Bad DBA - More worried about his retirement in 2011 than Oracle RDBMS
version 11.
Good DBA - Considers, plans and executes
Bad DBA - executes and hopes he can recover, after the failure.
Good DBA - Knows how to listen, is intuitive and offers value.
Bad DBA - Jumps in, Shares all he knows and offers nothing of value.
Good DBA - Is SURE he is right before he acts, but is not afraid to call
support if he has the least
little doubt (or if it's a major problem).
Bad DBA - Thinks he has to act and doesn't want to call support for fear of
being labeled bad dba.
Good DBA - Asks questions before doing
Bad DBA - Does and asks questions only if the doing doesn't do it.
Good DBA - Knows the answer or how to find it (e.g. Coming here and asking
the question).
Bad DBA - Knows where the good DBA is at all times, because the good DBA
will know the answer and it's
easier than figuring it out himself.


-- 
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: 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: Taylor, Shirley
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: AUDIT_ACTIONS

2002-04-25 Thread Taylor, Shirley

Charlie,
I believe this may refer to the ORA- error generated by the attempt. 
Shirley
Systems Admin & Operations | Admin. et Exploit. des systèms
Technology Services | Services technologiques
Informatics Branch  | Direction de l'informatique 
Maritimes Region, DFO   | Région des Maritimes, MPO
(506) 529 5911
[EMAIL PROTECTED]


 -Original Message-
Sent:   Thursday, April 25, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L
Subject:AUDIT_ACTIONS

103 SESSION REC

I see entries in one of my AUD$ tables with a ACTION = 103
I'd like to know exactly what this action references.
I've searched my 8i online doc set but got no hits.

I'm willing to RTFM is somebody will point me at which FM
I should use in this case.

TIA & HAND!

-- 
Charlie Mengler   Maintenance Warehouse  
[EMAIL PROTECTED]  10641 Scripps Summit Ct.
858-831-2229  San Diego, CA 92131
Am I sure? Of course I'm sure. I could be wrong, but I'm sure for now!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Taylor, Shirley
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Remote DB Installation

2002-03-22 Thread Taylor, Shirley



I have 
successfully done this several times using Exceed, a product of Hummingbird 
Communications Ltd.
 

  -Original Message-From: Sujatha Madan 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, March 22, 2002 
  1:13 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Remote DB Installation
  Sorry I was too quick in sending.
   
  With 
  the telnet, you need some sort of X windows application - liek Reflection X or 
  XWin or something like that.
   
  The 
  Oracle Installator will work via this.
   
   
  
-Original Message-From: Sujatha Madan 
[mailto:[EMAIL PROTECTED]]Sent: Friday, 22 March 2002 
3:08 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Remote DB Installation
You need to establish a telnet or ssh connection to the remote 
server. That's all you need.
 

  -Original Message-From: KENNETH JANUSZ 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, 22 March 2002 2:33 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Remote DB Installation
  I have a possible opportunity to install an Oracle DB 
  (8i or 9i) for a company located in Central America.  I am 
  located in the Minneapolis / St. Paul, MN area.  What tools would I 
  need to install this remotely from MN?  The server would probably be 
  Sun or HP unix.
   
  Thanks,
  Ken Janusz, 
CPIM


RE: Import placing data into wrong tablespace

2002-02-28 Thread Taylor, Shirley

I seem to recall something like this from the past. I believe that I ended
up having to grant quota of 0 on the other tablespaces to force Oracle to
populate the correct tablespace.
Systems Admin & Operations | Admin. et Exploit. des systèms
Technology Services | Services technologiques
Informatics Branch  | Direction de l'informatique 
Maritimes Region, DFO   | Région des Maritimes, MPO
(506) 529 5911
[EMAIL PROTECTED]


 -Original Message-
Sent:   Wednesday, February 27, 2002 4:18 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Import placing data into wrong tablespace

ENVTST doesn't need unlimited tablespace, because SYSTEM has unlimited
tablespace


--- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote:
> ENVTST with unlimited tablespace, quota on DATA ??? 
> 
> - Kirti 
> 
> -Original Message-
> Sent: Wednesday, February 27, 2002 12:20 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I have a user ENVTST with a default tablespace ENVTST_DATA.
> 
> I have a user ENVTPA with a default tablespace DATA.
> 
> I export user ENVTPA as SYSTEM, and then try to import into ENVTST
> schema,
> also as SYSTEM.  Data is going into DATA tablespace, not ENVTST_DATA
> tablespace.
> 
> Any ideas?
> 
> Thanks
> 
> 
> -- 
> 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: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Taylor, Shirley
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Message about character sets on EXPORT - should I worry?

2002-02-13 Thread Taylor, Shirley

FYI, recently we upgraded our satabases from 7.3.4.5 to 8.1.7. I forgot to
specify WE8ISO8859P1 when I created a new database so it was created as
US7ASCII. I loaded that database with an import that had been done from a
WE8ISO8859P1 database. Oracle had me trash that db and start over from the
beginning. They said the data would be corrupted doing an import from a
WE8etc. database into US7ASCII.

 -Original Message-
Sent:   Wednesday, February 13, 2002 9:58 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Message about character sets on EXPORT - should I worry?

Actually you won't have to do a characterset conversion because WE8ISO8859P1
is a superset of US7ASCII.  But this message is just telling you that it
might do a conversion .  Set the characterset to WE8ISO8859P1 on the server
at the command line prompt and everything should go OK.

HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, February 13, 2002 4:38 AM


> Hi folks,
>
> since a 3rd-party application vendor came in to upgrade their app., and
also
> to upgrade the version of Oracle from 7.3.4 to 8i, I've noticed the
> following messages whenever I export or import tables on the database:
>
> On EXPORT:
>
> Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
> Export done in US7ASCII character set and WE8ISO8859P1 NCHAR character set
> server uses WE8ISO8859P1 character set (possible charset conversion)
>
> On IMPORT:
>
> Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
> Export file created by EXPORT:V08.01.07 via conventional path
> import done in US7ASCII character set and WE8ISO8859P1 NCHAR character set
> import server uses WE8ISO8859P1 character set (possible charset
conversion)
>
> So what I'd like to know is whether these messages about possible charset
> conversion are anything to worry about? If not, then are there any
> performance issues arising from these charset conversions? I ask because
the
> imports seem to run really slowly compared with imports on some of our
other
> servers, and if character sets are being converted for every imported row,
I
> guess that might account for it! So are there any "gotchas" I should be
> aware of here?
>
> Thanks - hope somebody can offer some insights!
>
> Paul
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Paul Vincent
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Ruth Gramolini
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Taylor, Shirley
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Reports generated from OEM Change Management Pack 2.2

2001-12-12 Thread Taylor, Shirley

Hi all,
I've been looking on Metalink and in the docs but cannot find any reference
to the 'state' that is mentioned in the html output of the comparison
report. In my report there are only states 5 and 6 mentioned but can anyone
point me at some docs to tell me what they mean.
Thanks heaps,
Shirley
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Taylor, Shirley
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Altering Indexes

2001-11-27 Thread Taylor, Shirley

Wonderful idea, Mark. We have scores of users who create their own tables,
indexes etc since we are a scientific research institution. It's hard to get
users to put in that extra code to place the index in it's own tablespace.
Shirley

-Original Message-
From:   Mark Leith [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, November 27, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Altering Indexes

Just a question off the wall here - kind of related:

Does anybody know why Oracle does NOT give the option to have a
DEFAULT
INDEX TABLESPACE along with TEMPORARY and DEFAULT (for Tables for
example)..
I know, I know it's just another thing to add to your syntax - but
it would
be a FAR better way of doing things wouldn't it?

I would much prefer to say:

create user mark identified by beer
default table tablespace USER_DATA
quota 100 M on USER_DATA
default index tablespace USER_IDXS
quota 100 M on USER_IDXS
temporary tablespace TEMP;

as this totally takes away the nightmare of having them all created
in one
single tablespace..

Anyone with an "in" with Oracle know the answer? Anyone care to
speculate?
:>

Cheers

Mark

-Original Message-
Sent: 27 November 2001 15:20
To: Multiple recipients of list ORACLE-L


You can't do it en-mass.  Why not write a script to do this.
select 'alter index '||index_name||' rebuild ;'
from user_indexes;
or somthing similar.

Terry

-Original Message-
Sent: Tuesday, November 27, 2001 8:25 AM
To: Multiple recipients of list ORACLE-L


I have this large DB (approx. 250 tables) that has the tables and
indexes in
the same tablespace (not my design).  Is there a way I can move all
of the
indexes to a separate tablespace en-mass?  I know I can move them
one at a
time with the alter index command, but that would be rather time
consuming.

Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Ball, Terry
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Taylor, Shirley
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mail

RE: Enterprise backup product

2001-09-07 Thread Taylor, Shirley

Ruth, 
Is RMAN a purchased option? Does it come with the OEM management packs? I
thought it did but have installed those and don't see RMAN.
Thanks,
Shirley
Systems Admin & Operations | Admin. et Exploit. des systèms
Technology Services | Services technologiques
Informatics Branch  | Direction de l'informatique 
Maritimes Region, DFO   | Région des Maritimes, MPO
(506) 529 5911
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 



-Original Message-
From:   Ruth Gramolini [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, September 07, 2001 9:46 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Enterprise backup product

We use rman for all production database backups (except backing up
the
database which hold the recovery catalog).  We do a leve 0 every
morning
before  users get on and a level 1 incremental each evening before
batch
processing.  These are online backups.  We do a backup of our
archivelogs
each time and delete them.

We backup to disc and then put the backups on tape using the OS
backup and
recovery utility.

For other non-production databases we also use rman.

Regards,
Ruth


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 06, 2001 5:18 PM


>  Just wondering what product(s) organizations are using for
enterprise
>  backup, and how easy or difficult it was to set up the Oracle
>  component to interface with RMAN and perform hot backups.
>
>  We're implementing Tivoli Storage Manager/Data Protection for
Oracle
>  and our systems people want to ensure they've chosen a widely
utilized
>  solution.
>
>  Thanks for your input.
>
>  Kim Thompson
>  City and County of San Francisco
> --
> 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: Ruth Gramolini
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Taylor, Shirley
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: what to check in alert.log

2001-09-05 Thread Taylor, Shirley

I check for these strings:
ORA-
TNS-
trc
cannot
exceeded

That works well for me.
Systems Admin & Operations | Admin. et Exploit. des systèms
Technology Services | Services technologiques
Informatics Branch  | Direction de l'informatique 
Maritimes Region, DFO   | Région des Maritimes, MPO
(506) 529 5911
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 



-Original Message-
From:   Hillman, Alex [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, September 05, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L
Subject:what to check in alert.log

Any suggestions what to check for in alert.log besides ORA-  ?

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).