Topic: Database Administration >> What is the best way to create database in SAN env?
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: What is the best way to create database in SAN env? |
| vikhardba |
Posted: Jan 23, 2008 12:36:44 PM |
Total Post: 85
Joined: Apr, 2007
|
D:\ Oracle software is installed.
E:\ Database is created and C/R/D files are also in E:\
Before creating database, we were having only E:\ ( SAN storage which is configured as RAID 5 )
What is the best way to create database in SAN env? For example, do we have to have C/R/D files in different disc? If so, what is the use?
SAN storage drives are very big in size ( appr 600 GB) and the database C/R/D files are stored on SAN disc. So, i would like to know, is it better to make copy of C/R/D files on another drive. If so, how do i create another SAN drive?
Regards,
Vikhar |
|
|
 MOH_DBA |
| Posted: Jan 24, 2008 02:39:30 PM |  |
|
Total Post: 124
Joined: Nov, 2007
|
Sizing and tuning the hardware for Oracle is a big discussion.
and for your questions:
>>do we have to have C/R/D files in different disc? If so, what is the use?
>>is it better to make copy of C/R/D files on another drive. If so, how do >>i create another SAN drive?
my questions to you are:
why you want to copy your database?if you want to have aviability you can use, data gaurd or oracle replication.
and if you afraid of losing data you know that RAID 5 already provid fault-tolerance, but only tolerate the loss of one disk drive and have worst write penalty.
but i can give these guidelines:
SAN performance depends on the RAID Configuration.
Vendor based support is cruicial.
Storage protocols.(SCSI, fibre channel, iscsi, s-ata, using block-based storage, linux I/O scheduling, NAS)
Storage Fundamentals.(Disk Drive performance)
and if You are using RAC then RAC I/O characteristics.
Hope this help.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 242 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
