Asm

[bhattnirav]

I am new to 10g and testing my existing application on 10g(presently on 9i).

I have server for testing which has 2 CPU and 5 SCSI HDDs.

O/S : RHEL 4.

I want to configure ASM.


I want to put all datafiles,archive logs,flash recovery area etc. on ASM.


I need guidance reagarding how many diskgroups... or other advisable configuration,

Should I put datafiles on one diskgroup, and archive logs + Flash recover area on different diskgroup etc.

[hrishy]

Hi

You can have two disks groups one for +DATA and one for +FLASH_RECOVERY_AREA

Keep one copy of online logfiles,controlfiles in the flashrecovery area and also backup of archive logfiles ,and all types of backups in the flash recovery area.

regards
Hrishy

[bhattnirav]

Thanks Hrishy.

So I will create to diskgroup

in 1st group --> All the datafiles + Archive logs

2nd diskgroup --> Flash recover area + mirror copy of controlfile,redologs, Backup of Archive log and all the database backup (RMAN etc.).

[hrishy]

Hi

If you are not using standby database then archivelog should go in flash_recovery_area

regards
Hrishy

[bhattnirav]

Thanks hrishy

[hrishy]

Hi

If you are not using standby database then archivelog should go in flash_recovery_area

regards
Hrishy

I was just thinking over this critically again and my feeling is putting archivelogs in the flash recovery area isnt a good thing after all.As archivelogs are very important for recovery putting the archive logs and datafiles in the same destination does'nt make much sense.

Putting the backups of datafiles and flash reovery area in the same place is like putting the key and the backup key of your house in the same place which i dont think so is very sensible.

Would love to hear other peoples opinion also.

[bhattnirav]

Please give your valuable suggetions / share your experience.

I am doing testing and I have configure ASM as follow

I have now total no of 6 SCSI. Out of that 5 is of 74 GB and 1 is of 146 GB.

I have install RHEL 4 and Oracle software i.e 10g in 1st HDD.

My database is small around 60GB

I have created two disk group say DATA and ARCH. Eash has two HDDs. So eash Disk group have 148 GB.

Each diskgroup contains following files.

DATA --> Datafiles, Control files and Redolog files ( 2 HDDs) -
to getting benigits of file stripings

ARCH --> Archive logs and Mirror copy of Redologs and controlfile. RMAN
Backup. ( 2 HDDs)


Additionaly 146 HDD is that i have not used.

Actuly my database is small against I got HDDs storage. But I got the test server comming with minium 74 GB hdds.

[hrishy]

Hi

Install the ASM lib from oracle's website and follow this

http://www.oracle-base.com/articles/...agement10g.php

Read my previous posts i am not very comfortable in keeping

a)Archive logs under ASM
b)Some companies wouldnt like to keep backups under ASM.

regards
Hrishy

[bhattnirav]

Thanks for your reply hrishy.

If I use raw device instead of ASM lib. ?

Because I am using RHEL 4 ES and I have checked at oracle's site they have given RPM for RHEL 4 AS. For Enterprise linux I have to run "up2date" (with some parameter) from server and that required intenet connection at my server and which is not allowed in our company.

[hrishy]

Hi

I wouldn't reccomend raw device with Linux as it has been desupprted anyway.

DirectIO provides the same functionality and performance as raw.Much better of using ASMLib rather then anything else.

My advice is
Two disk groups
a)One for data
b)one for keeping backups in the flash recovery area

Also keep copies of archivelogs separately.
Regulary backup your flash recovery area to disks.

search this forum there is a link to ASM best practices document.

regards
Hrishy