RE: More than one archivelog disk

Michael,

LOG_ARCHIVE_DEST_1='LOCATION=/disk1 MANDATORY NOREOPEN ALTERNATE=LOG_ARCHIVE_DEST_2'

LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_2='LOCATION=/disk2 MANDATORY'
LOG_ARCHIVE_DEST_STATE_2=ALTERNATE 

Try the above. Myself and a couple other DBAs are debating this. We believe you might have to yank the MANDATORY options to make this work. We just can't find the time or server to test this.

BTW, the key here is "LOG_ARCHIVE_DEST_STATE_2=ALTERNATE"

Linky to the doc on this parameter:

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14237/init params101.htm#sthref426

HTH. Let me know so I can share that info with the others.

Chris

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kline.Michael
Sent: Thursday, November 16, 2006 1:50 PM To: oracle-l_at_freelists.org
Subject: More than one archivelog disk

This is 10G v2.

This is a tad different than normal.

Is it possible to have more than one archivelog disk AND fill the one, THEN fill the other, and yet RMAN knows exactly what is going on?

In other words, not looking for duplicates, but to sort of "merge" multiple disks together.

Eventually I'll get everyone NOT sharing the archivelogs with the datafiles and then losing track and the archive disk fills because it's now 80GB less than it used to be.

I'm trying to push everything to have only one archivelog disk and not shared with "other" stuff.

But if I could have 2 disks and work it pretty much the same way, that may be okay. Like 2 100GB disks instead of a 200Gb, etc.

I've asked around, and it seems this was mostly a wish list item.

Michael Kline
Database Administration
SunTrust Banks, Inc.
Mail Code TOC-7505

1030 Wilmer Avenue
Richmond, Va. 23227
Tel: 804.261.9446 Net: 643.9446

Cell: 804.744.1545
michael.kline_at_suntrust.com <mailto:michael.kline_at_suntrust.com>

Seeing beyond Money(sm)    

LEGAL DISCLAIMER
The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.  

SunTrust and Seeing beyond money are federally registered service marks of SunTrust Banks, Inc.
[ST:XCL]

--
http://www.freelists.org/webpage/oracle-l