RE: No Talk, Only Do

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_at_csc.com 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_at_freelists.org'" <oracle-l_at_freelists.org>                  
         
                      @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_at_aetvn.com 
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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------