RE: copying datafile nt4-w2k

[GKor]

i saw this document on Metalink, it is possible to copy everything even
without creating the controlfiles!!

*   goal: How to copy an Oracle database to another machine 
*   fact: Oracle Server - Enterprise Edition 
fix: Pre-requisites: The copy is between 2 machines, both have to be on the
same OS and have to have exactly the same database version installed. 1.
Make sure the database you want to copy was closed with a SHUTDOWN
IMMEDIATE, SHUTDOWN NORMAL or SHUTDOWN TRANSACTIONAL. 2. Copy init.ora and
control files to create instance and be able to go in mount mode. Check the
init.ora for the locations where the controlfiles have to be, if those
locations are not valid on the machine put the control files on different
places and adjust the init.ora accordingly. 3.a. Copy the datafiles (all of
them). b. Copy the redo-logfiles (all of them). 4.a. (Unix only) Set the
environment variables: ORACLE_SID - set to the database name you wish to
create ORACLE_HOME - set to full pathname of the Oracle system home
directory PATH - needs to include $ORACLE_HOME/bin b. (NT/2000 only) Do 'set
ORACLE_SID=' Use oradim to create the service for the instance. For
more information on oradim please refer to (the part that refers to creating
a new instance): Note:68720.1 Creating a new 7.3, 8.0, 8.1 Instance/Database
5. Use
servermanager (check the name to use for your version of oracle) or sqlplus
(version 9i and above) to startup the database in mount mode. Do CONNECT
INTERNAL/ then STARTUP MOUNT Then do a rename of the copied
datafiles if they are not in the same path as on the other machine. For all
the files that are in the result of the query: SELECT NAME FROM V$DATAFILE;
do ALTER DATABASE RENAME FILE '\' to <
newfullpath>\'; 6. Query the datadictionary for the old location
of the redolog files using: SELECT MEMBER FROM V$LOGFILE; If the new place
is not the same as the old do: ALTER DATABASE RENAME FILE
'\' to & lt;newfullpath>\';
7. Now open the database: ALTER DATBASE OPEN; 


 <> 
--- Begin Message ---

Yes, the database is down while doing this.

Opening the database and creating a controlfile works,
but I really didn't expect recovery on an 8.0 database 
to work with 8i executables.

Jared

On Friday 28 March 2003 11:38, Jeffrey Beckstrom wrote:
> Presuming this is a cold backup. I recall trying it about a year or so ago
> with a hot backup and had a problem with recovery not knowing when to stop
> - it kept wanting more log files.
>
> >>> [EMAIL PROTECTED] 3/28/03 1:43:41 PM >>>
>
> Certainly possible.
>
> I'm currently copying 8.0 files on NT to Win2k servers with
> 8.1.7 installed.  Rebuild the controlfile, open the database
> and upgrade.  Works great.
>
> Jared
>
> On Friday 28 March 2003 03:28, [EMAIL PROTECTED] wrote:
> > hi all
> >
> > We are planning an upgrade from NT4 to W2K.
> > I am considering to create a new instance on another server with W2K
> > installed and copying the datafiles
> > from the server with NT4 on it.
> > Is this possible ? Or do i have to use the exp/imp strategy ?
> >
> > thanks
> >
> > vr.gr.
> > Geo Kor
> > Sr. System Engineer I&DM Db
> > RDW Voertuiginformatie en -toelating
> > Holland


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--- End Message ---

Re: startup hangs, 8.1.7 on win2000 Pentium 4

[Jared Still]

MetaLink document 61552.1 is a good place to start.

Jared


On Sunday 30 March 2003 21:23, rahul wrote:
> list, this started occuring since 2 days ago..when we try to startup the
> instance using svrmgrl, after listing the SGA, the machine will just
> lock !!! no cursor , no keys.. just total lock.. the alert log show
> "alter database mount" as the last entry..
>
> i have searched metalink on this.. but cannot find anything related to
> hanging issue on windows..
>
> has someone else encountered this ?
>
> TIA
> Rahul
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 query

[sudhakar Reddy]

hi,

i have a table with indent number and quantity with 10 rows
ex ind_no qty
 1  10
 1  12
 1  30
 1  15
 1  30

 2  12
 2  30
 2  15
 2  30
 2  25

 2
I have to dispay it as rows
like
   1  10   12   30   15   30
   2  12   30   15   30   25

please help,

regds,
Sudhakar

___
Odomos - the only  mosquito protection outside 4 walls -
Click here to know more!
http://r.rediff.com/r?http://clients.rediff.com/odomos/Odomos.htm&&odomos&&wn

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

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

startup hangs, 8.1.7 on win2000 Pentium 4

[rahul]

list, this started occuring since 2 days ago..when we try to startup the 
instance using svrmgrl, after listing the SGA, the machine will just 
lock !!! no cursor , no keys.. just total lock.. the alert log show 
"alter database mount" as the last entry.. 

i have searched metalink on this.. but cannot find anything related to 
hanging issue on windows..

has someone else encountered this ? 

TIA
Rahul


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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Configuring Oracle with RAID and OFA

[Rachel Carmichael]

Craig,

yeah it was easier when I worked for a dot-com :)  These days, I work
for an international company (you may have heard of them, it's Sony).
Very rigid in who does what and who has input. Of course, it didn't
help that I started here partway into the process and they had already
decided on equipment. I screamed, they listened politely, told me that
"it doesn't matter, we are on a SAN" and basically ignored me.

Rachel


--- Craig Munday <[EMAIL PROTECTED]> wrote:
> Rachel,
> 
> I guess it is much simplier in may situation because I do not have
> the
> challenges of working for a "very large company".
> 
> Good luck!! :-)
> 
> Cheers,
> Craig.
> 
> 
> -Original Message-
> Sent: Monday, 31 March 2003 9:59 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Craig,
> 
> I envy you your company. When you work for a very large company,
> which
> tries to save money via economy of scale, when you are not part of
> the
> production group but can only make suggestions, you don't get to make
> the decisions. It's not like I haven't tried to influence the
> decisions, but you need to have power or a position of authority from
> which to fight. I have no desire in the economy that exists in the US
> right now to say "do it my way or I'll quit". I'd rather repeat and
> document my recommendations and then be able to say "you'll need to
> change it to this as I told you before" (I'm not above saying I told
> you so)
> 
> Can you tell me exactly how you ensure you are part of the purchasing
> decisions? I'd love to find some new ways to be heard.
> 
> 
> Rachel
> --- Craig Munday <[EMAIL PROTECTED]> wrote:
> > Rachel,
> > 
> > There seems to be something inherently wrong with a DBA not getting
> > to
> > determine the layout of their disks.
> > 
> > I too have experienced this problem in the past and have found that
> > it is
> > difficult to achieve change once large sums on money have already
> > been
> > committed.  These days I ensure that I am involved in the
> purchasing
> > decision from the out set - its easier to get what I want that way.
> > 
> > I use this technique with developers as well.  If I am lucky enough
> > to see
> > the beginning of a development project, I ensure that I set
> standards
> > for
> > database development when the developers are setting other coding
> > standards
> > for themself.  It helps developers understand what I expect of them
> > and also
> > gets their buy-in.  I've found that developers like standards more
> > than me
> > trying to tell them what is wrong with their code after they have
> > puts
> > months of work. - developers tend to get emotionally attached to
> what
> > they
> > create :-)  It is also a little unfair to impose standards
> > retrospectively
> > which threaten their deadlines.
> > 
> > I'm sure other DBAs have experienced the similar things, and I'd be
> > interested in how they have tried to solve their problems.
> > 
> > Cheers,
> > Craig.
> > 
> > 
> > -Original Message-
> > Sent: Friday, 28 March 2003 1:54 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Dennis,
> > 
> > Sometimes you don't have the option to decide if you are using a
> > single
> > RAID set or not. At my last job I was told "hey, we have 375GB of
> > space
> > for you -- and it's RAID-5". I was not asked if I wanted it
> > configured
> > that way, I was not listened to when I protested. So the
> alternatives
> > I
> > faced were a) run my database on RAID-5 and do the best I can or b)
> > quit because I refused to run a database on RAID-5
> > 
> > Option b seemed a little extreme.   You really can't make
> > pronouncements like "you shouldn't run a production database on a
> > single RAID set" because sometimes you have to.
> > 
> > Oh yeah -- the database ran fine, we had no performance problems
> and
> > we
> > DID have good backups.
> > 
> > Rachel
> > 
> > --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> > > Dwayne
> > >So you have a single RAID set, or 5 separate devices? You
> might
> > > have a
> > > test database on a single RAID set, but you shouldn't do that in
> > > production.
> > > First, multiple control files on separate devices. Redo should
> > write
> > > to a
> > > non-RAID device since it continuously writes. Past that it
> depends
> > on
> > > how
> > > much performance this system requires.
> > >Gaja and Kirti explain this nicely in Oracle Performance
> Tuning
> > > 101.
> > > 
> > > Dennis Williams
> > > DBA, 40%OCP, 100% DBA
> > > Lifetouch, Inc.
> > > [EMAIL PROTECTED] 
> > > 
> > > -Original Message-
> > > Sent: Thursday, March 27, 2003 6:59 AM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > Hi all,
> > > 
> > > I am configuring a system for use with Oracle and am confused on
> > the
> > > concepts 
> > > of RAID and OFA, specifically how they work together.
> > > 
> > > I inherited a system that is a RAID 5 utilizing 5 disks. 
> Oracle8i
> > > (8.1.7)
> > > is 
> > > currently running on 

RE: Configuring Oracle with RAID and OFA

[Craig Munday]

Rachel,

I guess it is much simplier in may situation because I do not have the
challenges of working for a "very large company".

Good luck!! :-)

Cheers,
Craig.


-Original Message-
Sent: Monday, 31 March 2003 9:59 AM
To: Multiple recipients of list ORACLE-L


Craig,

I envy you your company. When you work for a very large company, which
tries to save money via economy of scale, when you are not part of the
production group but can only make suggestions, you don't get to make
the decisions. It's not like I haven't tried to influence the
decisions, but you need to have power or a position of authority from
which to fight. I have no desire in the economy that exists in the US
right now to say "do it my way or I'll quit". I'd rather repeat and
document my recommendations and then be able to say "you'll need to
change it to this as I told you before" (I'm not above saying I told
you so)

Can you tell me exactly how you ensure you are part of the purchasing
decisions? I'd love to find some new ways to be heard.


Rachel
--- Craig Munday <[EMAIL PROTECTED]> wrote:
> Rachel,
> 
> There seems to be something inherently wrong with a DBA not getting
> to
> determine the layout of their disks.
> 
> I too have experienced this problem in the past and have found that
> it is
> difficult to achieve change once large sums on money have already
> been
> committed.  These days I ensure that I am involved in the purchasing
> decision from the out set - its easier to get what I want that way.
> 
> I use this technique with developers as well.  If I am lucky enough
> to see
> the beginning of a development project, I ensure that I set standards
> for
> database development when the developers are setting other coding
> standards
> for themself.  It helps developers understand what I expect of them
> and also
> gets their buy-in.  I've found that developers like standards more
> than me
> trying to tell them what is wrong with their code after they have
> puts
> months of work. - developers tend to get emotionally attached to what
> they
> create :-)  It is also a little unfair to impose standards
> retrospectively
> which threaten their deadlines.
> 
> I'm sure other DBAs have experienced the similar things, and I'd be
> interested in how they have tried to solve their problems.
> 
> Cheers,
> Craig.
> 
> 
> -Original Message-
> Sent: Friday, 28 March 2003 1:54 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Dennis,
> 
> Sometimes you don't have the option to decide if you are using a
> single
> RAID set or not. At my last job I was told "hey, we have 375GB of
> space
> for you -- and it's RAID-5". I was not asked if I wanted it
> configured
> that way, I was not listened to when I protested. So the alternatives
> I
> faced were a) run my database on RAID-5 and do the best I can or b)
> quit because I refused to run a database on RAID-5
> 
> Option b seemed a little extreme.   You really can't make
> pronouncements like "you shouldn't run a production database on a
> single RAID set" because sometimes you have to.
> 
> Oh yeah -- the database ran fine, we had no performance problems and
> we
> DID have good backups.
> 
> Rachel
> 
> --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> > Dwayne
> >So you have a single RAID set, or 5 separate devices? You might
> > have a
> > test database on a single RAID set, but you shouldn't do that in
> > production.
> > First, multiple control files on separate devices. Redo should
> write
> > to a
> > non-RAID device since it continuously writes. Past that it depends
> on
> > how
> > much performance this system requires.
> >Gaja and Kirti explain this nicely in Oracle Performance Tuning
> > 101.
> > 
> > Dennis Williams
> > DBA, 40%OCP, 100% DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED] 
> > 
> > -Original Message-
> > Sent: Thursday, March 27, 2003 6:59 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hi all,
> > 
> > I am configuring a system for use with Oracle and am confused on
> the
> > concepts 
> > of RAID and OFA, specifically how they work together.
> > 
> > I inherited a system that is a RAID 5 utilizing 5 disks.  Oracle8i
> > (8.1.7)
> > is 
> > currently running on it.  The database is setup on one disk (data
> > files, 
> > control files, redo logs, etc.).
> > 
> > I understand that striping spreads the info out across all the
> disks.
> >  That 
> > being true, is it necessary to put the redo logs, rollback
> segments,
> > etc on 
> > sepaparte disks ala OFA?
> > 
> > Since the database is not in production yet, I have time to make
> > these
> > changes 
> > (not to mention we are planning to redo the setup with Red Hat
> > Advanced 
> > Server and upgrade to Oracle9i).
> > 
> > Thanks in advance for your help.  Feel free to point me to
> additional
> > reading 
> > materials that will clarify this for me.
> > 
> > Dwayne
> > 
> > -- 
> > Dwayne Cox
> > Corporate Database Administrator
> > Info Tech, Inc.
> > 5700 SW 34th S

RE: Configuring Oracle with RAID and OFA

[Rachel Carmichael]

Craig,

I envy you your company. When you work for a very large company, which
tries to save money via economy of scale, when you are not part of the
production group but can only make suggestions, you don't get to make
the decisions. It's not like I haven't tried to influence the
decisions, but you need to have power or a position of authority from
which to fight. I have no desire in the economy that exists in the US
right now to say "do it my way or I'll quit". I'd rather repeat and
document my recommendations and then be able to say "you'll need to
change it to this as I told you before" (I'm not above saying I told
you so)

Can you tell me exactly how you ensure you are part of the purchasing
decisions? I'd love to find some new ways to be heard.


Rachel
--- Craig Munday <[EMAIL PROTECTED]> wrote:
> Rachel,
> 
> There seems to be something inherently wrong with a DBA not getting
> to
> determine the layout of their disks.
> 
> I too have experienced this problem in the past and have found that
> it is
> difficult to achieve change once large sums on money have already
> been
> committed.  These days I ensure that I am involved in the purchasing
> decision from the out set - its easier to get what I want that way.
> 
> I use this technique with developers as well.  If I am lucky enough
> to see
> the beginning of a development project, I ensure that I set standards
> for
> database development when the developers are setting other coding
> standards
> for themself.  It helps developers understand what I expect of them
> and also
> gets their buy-in.  I've found that developers like standards more
> than me
> trying to tell them what is wrong with their code after they have
> puts
> months of work. - developers tend to get emotionally attached to what
> they
> create :-)  It is also a little unfair to impose standards
> retrospectively
> which threaten their deadlines.
> 
> I'm sure other DBAs have experienced the similar things, and I'd be
> interested in how they have tried to solve their problems.
> 
> Cheers,
> Craig.
> 
> 
> -Original Message-
> Sent: Friday, 28 March 2003 1:54 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Dennis,
> 
> Sometimes you don't have the option to decide if you are using a
> single
> RAID set or not. At my last job I was told "hey, we have 375GB of
> space
> for you -- and it's RAID-5". I was not asked if I wanted it
> configured
> that way, I was not listened to when I protested. So the alternatives
> I
> faced were a) run my database on RAID-5 and do the best I can or b)
> quit because I refused to run a database on RAID-5
> 
> Option b seemed a little extreme.   You really can't make
> pronouncements like "you shouldn't run a production database on a
> single RAID set" because sometimes you have to.
> 
> Oh yeah -- the database ran fine, we had no performance problems and
> we
> DID have good backups.
> 
> Rachel
> 
> --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> > Dwayne
> >So you have a single RAID set, or 5 separate devices? You might
> > have a
> > test database on a single RAID set, but you shouldn't do that in
> > production.
> > First, multiple control files on separate devices. Redo should
> write
> > to a
> > non-RAID device since it continuously writes. Past that it depends
> on
> > how
> > much performance this system requires.
> >Gaja and Kirti explain this nicely in Oracle Performance Tuning
> > 101.
> > 
> > Dennis Williams
> > DBA, 40%OCP, 100% DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED] 
> > 
> > -Original Message-
> > Sent: Thursday, March 27, 2003 6:59 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hi all,
> > 
> > I am configuring a system for use with Oracle and am confused on
> the
> > concepts 
> > of RAID and OFA, specifically how they work together.
> > 
> > I inherited a system that is a RAID 5 utilizing 5 disks.  Oracle8i
> > (8.1.7)
> > is 
> > currently running on it.  The database is setup on one disk (data
> > files, 
> > control files, redo logs, etc.).
> > 
> > I understand that striping spreads the info out across all the
> disks.
> >  That 
> > being true, is it necessary to put the redo logs, rollback
> segments,
> > etc on 
> > sepaparte disks ala OFA?
> > 
> > Since the database is not in production yet, I have time to make
> > these
> > changes 
> > (not to mention we are planning to redo the setup with Red Hat
> > Advanced 
> > Server and upgrade to Oracle9i).
> > 
> > Thanks in advance for your help.  Feel free to point me to
> additional
> > reading 
> > materials that will clarify this for me.
> > 
> > Dwayne
> > 
> > -- 
> > Dwayne Cox
> > Corporate Database Administrator
> > Info Tech, Inc.
> > 5700 SW 34th Street, Suite 1235
> > Gainesville, FL  32608
> > 
> > email: [EMAIL PROTECTED]
> > phone: 352.381.4521 fax: 352.381.
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Dwayne Cox
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat

RE: Configuring Oracle with RAID and OFA

[Craig Munday]

Is there a large cache on the SAN - perhaps it was memory that was written
to and not disk?  Did you consider not striping the redo on the internal
disk?

Cheers,
Craig.


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


Stephane Paquette wrote:
> Same here, the SAN (Hitachi) is configured raid 5 (with 128K strippes i
> think) and it's good for everything : Oracle, Sql Server, Novell, Windows,
> AIX and maybe the mainframes if they live long enough.
> 
> So I would not be wellcomed if I asked how about putting those redo logs
on
> raid 0+1 ?
> 
> 
> Stephane
> 


The funny thing is, we just got a Hitachi san raid 5 and I decided to 
put the redo logs on 5 striped internal disk on the host(sun V880) 
because I didn't want them on the raid 5 disk on the sam do to the heavy 
writes. Well, those internal disks were a huge bottleneck during some 
load tests for our datawarehouse(they are fibre channel on the new sun 
fire v880's), so we moved them to the SAN and it tripled the 
performance. Go figure.


-Brian

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

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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.net
-- 
Author: Craig Munday
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Configuring Oracle with RAID and OFA

[Craig Munday]

Rachel,

There seems to be something inherently wrong with a DBA not getting to
determine the layout of their disks.

I too have experienced this problem in the past and have found that it is
difficult to achieve change once large sums on money have already been
committed.  These days I ensure that I am involved in the purchasing
decision from the out set - its easier to get what I want that way.

I use this technique with developers as well.  If I am lucky enough to see
the beginning of a development project, I ensure that I set standards for
database development when the developers are setting other coding standards
for themself.  It helps developers understand what I expect of them and also
gets their buy-in.  I've found that developers like standards more than me
trying to tell them what is wrong with their code after they have puts
months of work. - developers tend to get emotionally attached to what they
create :-)  It is also a little unfair to impose standards retrospectively
which threaten their deadlines.

I'm sure other DBAs have experienced the similar things, and I'd be
interested in how they have tried to solve their problems.

Cheers,
Craig.


-Original Message-
Sent: Friday, 28 March 2003 1:54 AM
To: Multiple recipients of list ORACLE-L


Dennis,

Sometimes you don't have the option to decide if you are using a single
RAID set or not. At my last job I was told "hey, we have 375GB of space
for you -- and it's RAID-5". I was not asked if I wanted it configured
that way, I was not listened to when I protested. So the alternatives I
faced were a) run my database on RAID-5 and do the best I can or b)
quit because I refused to run a database on RAID-5

Option b seemed a little extreme.   You really can't make
pronouncements like "you shouldn't run a production database on a
single RAID set" because sometimes you have to.

Oh yeah -- the database ran fine, we had no performance problems and we
DID have good backups.

Rachel

--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Dwayne
>So you have a single RAID set, or 5 separate devices? You might
> have a
> test database on a single RAID set, but you shouldn't do that in
> production.
> First, multiple control files on separate devices. Redo should write
> to a
> non-RAID device since it continuously writes. Past that it depends on
> how
> much performance this system requires.
>Gaja and Kirti explain this nicely in Oracle Performance Tuning
> 101.
> 
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED] 
> 
> -Original Message-
> Sent: Thursday, March 27, 2003 6:59 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hi all,
> 
> I am configuring a system for use with Oracle and am confused on the
> concepts 
> of RAID and OFA, specifically how they work together.
> 
> I inherited a system that is a RAID 5 utilizing 5 disks.  Oracle8i
> (8.1.7)
> is 
> currently running on it.  The database is setup on one disk (data
> files, 
> control files, redo logs, etc.).
> 
> I understand that striping spreads the info out across all the disks.
>  That 
> being true, is it necessary to put the redo logs, rollback segments,
> etc on 
> sepaparte disks ala OFA?
> 
> Since the database is not in production yet, I have time to make
> these
> changes 
> (not to mention we are planning to redo the setup with Red Hat
> Advanced 
> Server and upgrade to Oracle9i).
> 
> Thanks in advance for your help.  Feel free to point me to additional
> reading 
> materials that will clarify this for me.
> 
> Dwayne
> 
> -- 
> Dwayne Cox
> Corporate Database Administrator
> Info Tech, Inc.
> 5700 SW 34th Street, Suite 1235
> Gainesville, FL  32608
> 
> email: [EMAIL PROTECTED]
> phone: 352.381.4521 fax: 352.381.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Dwayne Cox
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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.net
> -- 
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail 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: Where's my trace file?

[Jonathan Lewis]

Another option (from about 8.1.6) is to
alter session set tracefile_identifier = 'my_text';

The trace file name will then hold 'my_text'.
Moreover, every time you issue the command
with a new bit of text, the session will open a
new text file (and the last line of the old text
file will also reference it)

The current 'traceid' appears in v$process - though there
seem to be a couple of bugs with it in earlier versions.

This doesn't work for multi-threaded server, unfortunately,
although trying it on a 9.2. system I found that the s000
trace migrated from the bdump directory to the udump
directory as a side-effect.


Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

UK___April 8th
UK___April 22nd
Denmark__May 21-23rd
USA_(FL)_May 2nd

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
UK_(Manchester)_May
Estonia___June (provisional)
USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: 30 March 2003 02:48


> Tired of wading through the long list of trace files to find yours?
Here
> is a quick script to find your sessions process id, which is part of
the
> trace file name.
>
>   select s.sid, s.serial#, s.username, s.osuser, p.spid
>   from v$session s, v$process p
>   where s.sid = (select sid from v$mystat where rownum = 1)
> and p.addr = s.paddr;
>
>SIDSERIAL# USERNAME
> OSUSER SPID
> -- -- --
> -- 
>  9 72 BCAdwfink
>  2628
>
> Now, go out to 'user_dump_dest' and you can find the file with
'2628' in
> the name and there is your trace file.
>
> --
> Daniel W. Fink
> http://www.optimaldba.com
>


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

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