Home » RDBMS Server » Server Administration » 10g Raw disk and redo logs
10g Raw disk and redo logs [message #132792] Tue, 16 August 2005 04:31 Go to next message
oztraxed
Messages: 1
Registered: August 2005
Junior Member
Hi, we are about to instal 10g RAC on AIX box on a SAN with raw disks.

My questions concerns where to place the redo logs. I am sure we cannot put them on raw disks as I can;t see how we can move them to a file system directory for archiving?

Has others set up 10g on raw and how they have places their redo logs, was it on a file system or raw?

Thanx

Oz Tee
Re: 10g Raw disk and redo logs [message #132819 is a reply to message #132792] Tue, 16 August 2005 06:40 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Hi,

You can put all your redo logs on RAW volumes.

When Oracle archives them, they will automatically be copied to the archive log directory on a filesystem.

Best regards.

Frank
Re: 10g Raw disk and redo logs [message #132835 is a reply to message #132792] Tue, 16 August 2005 07:24 Go to previous message
mjschwenger
Messages: 137
Registered: July 2005
Location: US
Senior Member
My redo logs are on raw devices. I have made a couple of tests to put them on the file system or raw devices and it looks that I get a better performance in the second case. The same case is with the DB2 database we have - it does better if it's install on raw.
I have a lot of transactions avarage 3500/sec, but very little rollbacks - a lot of writes, much less reads.
At least this is my experience.
When archived, the files can be moved automatically for you- depend where you are going to specify your archiving directory.
good luck.mj
Previous Topic: Unable to connect thru forms 6i executable
Next Topic: hanging DDL statements
Goto Forum:
  


Current Time: Sun Jan 26 10:30:25 CST 2025