Home » RDBMS Server » Server Utilities » Oracle Redo log Multiplexing
Oracle Redo log Multiplexing [message #239746] Wed, 23 May 2007 04:15 Go to next message
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




Re: Oracle Redo log Multiplexing [message #239748 is a reply to message #239746] Wed, 23 May 2007 04:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
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
Re: Oracle Redo log Multiplexing [message #239827 is a reply to message #239748] Wed, 23 May 2007 06:56 Go to previous messageGo to next message
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.




Re: Oracle Redo log Multiplexing [message #239834 is a reply to message #239827] Wed, 23 May 2007 07:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not possible.

Regards
Michel
Re: Oracle Redo log Multiplexing [message #239911 is a reply to message #239834] Wed, 23 May 2007 11:18 Go to previous messageGo to next message
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.
Re: Oracle Redo log Multiplexing [message #239915 is a reply to message #239746] Wed, 23 May 2007 11:35 Go to previous messageGo to next message
BlackSwan
Messages: 25045
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 Go to previous message
Michel Cadot
Messages: 64132
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
Previous Topic: Import Database (Merged)
Next Topic: IMP-00002: error
Goto Forum:
  


Current Time: Wed Dec 07 16:21:06 CST 2016

Total time taken to generate the page: 0.08193 seconds