Regarding Mount Points for Oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Regarding Mount Points for Oracle

  1. #1
    Join Date
    Feb 2001
    Posts
    40
    Hi,
    I will explain the situation i am into first. I am going to install Oracle 815 On Sun Solaris. This is a development environment. So they have provided with only two disks of 18G. The installation hasent started yet. But Upon Installing Solaris mount points are to be created. I have two databases to be created. One database i have to create it now. The question is,

    How many mount points should i ask my Unix admin to create. In the Installation Doc i read that for OFA compliant database it needs four mount points. But i dont think that i will be creating the database as OFA compilant. So advice me on this. I am new to Unix. I have done Admin in NT.

    Thanks in Advance
    Karthi

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    How many mount points you need is directly related to how many physical devices you have. If you only have two physical devices, I would only create two mount points.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2000
    Posts
    89
    Before you install you must consider "mirroring" as it is the standard for production env databases. This would mean using Suns software or buying the Veritas software which is easier to use. This eliminates one of your biggest weaknesses of lossing a disk.

    Then you have to choose how many disks will be mirrored. It is important to consider how you will "multiplex" the control and redo files- that means that they are written to 2 locations to protect you if the first one blows.

    Basically the main install can be on:
    /U00
    The main tablespace *.dbf files can be on:
    /u01
    The backups and exports + multiplexed redos & controll
    /u02

    That means your talking about at least 6 SCSI disks as these 3 disks should be mirrored. People could argue for hours specifically where everthing should be put- just try to think logically about "if" this disk goes and has the control(or redo) --- where wil the other one be.

    -Roger

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width