RE: No Talk, Only Do

From: "Ron Rogers" <RROGERS@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 05 Aug 2004 16:03:19 -0400
OFA is nice in concept but unpracticle in some parts of the real world.
The new server I am
getting will have 3 mirrored disks and one SAN disk. rather difficult
to achieve OFA with 
that one, but I will use the spindles as wisely as I can.
On my play-test linux/10g box with 3 disks I have created a coldbackup
script that copies 
the datafiles, controlfiles, network info, etc to a backup directory so
I can archive to
tape. In case of a snaffuuuu I can copy the files from the backup to
the original
location and be up and running fast. Then I can apply the daily data
updates to
bring it up to speed .
Simple, fast, and it works.
Ron

>>> tday6@xxxxxxx 08/05/2004 3:47:25 PM >>>

I have a development instance that the developers love to play around
with
(and mess up).  I have put everything (control files, pfile, spfile,
redo
logs, tablespaces ...) under a single mount point.  Stop the database
and
copy the mount point to a backup directory.  When they need a restore
they
can stop the database and copy the backup directory back to their
mount
point.  Simplicity.

When they foul their nest, they get to clean it.

The mount point is spread across multiple spindles via the system
level
striping.  Moving the redo logs and the control files to separate
mount
points would not ensure that they were on separate spindles.

I'd spend more time making sure that they were if it was a production
system.  Since it has a limited number of users, disk I/O contention is
not
a huge issue.

I respect OFA if you're talking about physical devices.  But if you're
just
moving files around on logical devices so that it looks OFA compliant
you
may be defeating your purpose.



                                                                       
                                                               
                      "Gogala, Mladen"                                 
                                                               
                      <Mladen.Gogala           To:     
"'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>                  
         
                      @aetn.com>               cc:                     
                                                               
                      Sent by:                 Subject: RE: No Talk,
Only Do                                                           
                      oracle-l-bounce                                  
                                                               
                                                                       
                                                               
                                                                       
                                                               
                      08/05/2004 03:21                                 
                                                               
                      PM                                               
                                                               
                      Please respond                                   
                                                               
                      to oracle-l                                      
                                                               
                                                                       
                                                               
                                                                       
                                                               




Great topic! I have only one question: why do I have to have all those
silly directories? I'd like to cram all software under
/oramydatabasesoftware
and scatter the data across the filesystems named in such a way to
deceive
the
enemy. I'd also like to put all control files and all redo logs on the
same
disk. Can you, please, explain to me why would that be bad?

--
Mladen Gogala
Oracle DBA
email:mladeng@xxxxxxxxx 
Ext: 9787


> -----Original Message-----
> But the next idiot that asks me to modify a script to fit
> their inconsistently designed file system had better duck ...
>
> Thanks to everyone for listening ... I feel ever so much better. :)
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html 
-----------------------------------------------------------------




----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html 
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
RE: No Talk, Only Do

Other related posts:
