OraFAQ Forum: Server Utilities » Oracle Redo log Multiplexing

Home » RDBMS Server » Server Utilities » Oracle Redo log Multiplexing

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

Oracle Redo log Multiplexing [message #239746]

Wed, 23 May 2007 04:15

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

Hello

I am a new forum member.This is my 1st query.How can I do multiplex redo log file in different Hosts?

Suppose I have 2 machines(A & B). I installed oracle database 10g release 2 at windows 2003 advanced server ( Machine A).I want Redo log file will be multiplex 2 machines for disaster recovery.Does it possible? How?.

Plz Help me...

Asraf

Report message to a moderator

Re: Oracle Redo log Multiplexing [message #239748 is a reply to message #239746]

Wed, 23 May 2007 04:19

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It is not possible.
All members of the log group must be on the same server.
Well, you can use NFS mount file system but it not recommended.
Moreover it will be useless in most cases.

I think you think to dispatch ARCHIVED logs. Then this can be done using several log_archive_dest_* parameters.

Regards
Michel

Report message to a moderator

Re: Oracle Redo log Multiplexing [message #239827 is a reply to message #239748]

Wed, 23 May 2007 06:56

mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA

Member

Dear Michel

Thanks ur reply,
I want Redo log file reside different Machine.
there are five locations for multiplexing redo log file
db_create_online_log_dest_1
db_create_online_log_dest_2
db_create_online_log_dest_3
db_create_online_log_dest_4
db_create_online_log_dest_5

suppose Redo log Group1 has 3 members,
member 1, db_create_online_log_dest_1=D:\
member 2, db_create_online_log_dest_2=E:\
and
member 3, reside another machine
db_create_online_log_dest_3=\\machinename\sharefolder
same case for Control file.
I want this because If disk drive fail or crash or machine totally crash,then I will get my last transaction.and no data will lose.

Report message to a moderator

Re: Oracle Redo log Multiplexing [message #239834 is a reply to message #239827]

Wed, 23 May 2007 07:04

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is not possible.

Regards
Michel

Report message to a moderator

Re: Oracle Redo log Multiplexing [message #239911 is a reply to message #239834]

Wed, 23 May 2007 11:18

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

I want this because If disk drive fail or crash or machine totally crash,then I will get my last transaction.and no data will lose.

If you dont wanna loss your single transaction put database in archivelog and set one remote location for archiving.
however you cant place your redologs to remote locations.

Report message to a moderator

Re: Oracle Redo log Multiplexing [message #239915 is a reply to message #239746]

Wed, 23 May 2007 11:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>however you cant place your redologs to remote locations.
Can you place one set of redo members on a nfs mount from a remote system?

[Updated on: Wed, 23 May 2007 11:37] by Moderator

Report message to a moderator

Re: Oracle Redo log Multiplexing [message #239920 is a reply to message #239915]

Wed, 23 May 2007 11:48

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is what I suggest in my first post.
Of course the latest NFS protocol guarantees no IO lost but it blocks the writer (maybe there are some parameters that allow an IO error instead of blocking the writer but I don't know).
Would like your database freeze because of a NFS problem?
And what about the response time to send IO accross network?
Well this is done with Data Guard in synchroneous mode.
So maybe... but I surely not do it without Oracle certifies it and many performances tests.

Regards
Michel

Report message to a moderator

Previous Topic:	Import Database (Merged)
Next Topic:	IMP-00002: error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 10:57:14 CDT 2024