RE: No Talk, Only Do

  • From: Thomas Day <tday6@xxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 5 Aug 2004 15:47:25 -0400

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
-----------------------------------------------------------------

Other related posts: