OraFAQ Forum: Server Administration » Datafile

Home » RDBMS Server » Server Administration » Datafile - archivelog destination? (Oracle DB, 10g, Server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Datafile - archivelog destination? [message #509549]

Sun, 29 May 2011 14:35

Nikoline
Messages: 2
Registered: May 2011
Location: aaaa

Junior Member

I have two logical disks,

D RAID 5
Oracle_home, two of tree redolog groups, two of tree control files, TEMP, UNDO, SYSAUX datafiles.

E RAID 1
My tablespace datafiles production datafiles

Only these drives have free space for creating new datafile (My tablespace datafile) and for second Archivelog destination. Where to create datafile and where to set second archivelog destination? In any of these disks is no space for datafile and for archivelog files.

Thanks!

Report message to a moderator

Re: Datafile - archivelog destination? [message #509550 is a reply to message #509549]

Sun, 29 May 2011 14:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://forums.oracle.com/forums/thread.jspa?threadID=2230101&tstart=0

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

[Updated on: Sun, 29 May 2011 14:46]

Report message to a moderator

Re: Datafile - archivelog destination? [message #509552 is a reply to message #509550]

Sun, 29 May 2011 14:54

Nikoline
Messages: 2
Registered: May 2011
Location: aaaa

Junior Member

Аpologize,

јust wanted to get opinions from more places

Report message to a moderator

Re: Datafile - archivelog destination? [message #509553 is a reply to message #509552]

Sun, 29 May 2011 14:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

REDO should never reside on RAID-5 which incurs 100% write overhead.
RAID-5 must write XOR block for every data block written.

Report message to a moderator

Re: Datafile - archivelog destination? [message #509568 is a reply to message #509553]

Mon, 30 May 2011 00:41

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Your undo tablespace datafiles and your controlfiles are "critical" files: if any are damaged, your database will fail immediately. You should consider moving them to RAID1.

Report message to a moderator

Previous Topic:	redo log buffer using
Next Topic:	Automatic Diagnostic Repository

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 06:37:44 CST 2024