This forum is currently locked. You can't register or post questions at this time. (read more)

Multiplexing a Redo log between Disk group and Physical File

Questions relating to Oracle Real Application Clusters (RAC) and Clusterware.

Moderator: Tim...

sunilmenon82
Member
Posts: 9
Joined: Sun Jan 01, 2012 6:15 pm

Multiplexing a Redo log between Disk group and Physical File

Postby sunilmenon82 » Wed Feb 27, 2013 7:25 am

Wanted to check whether I can do a redo log member multiplexing between a disk group and a File system i.e. One of my redo group member should come from the ASM disk group and the other member of the same redo group should be available in a physical mounted File system .

Do any one have some documentation available for the same( If feasible)

--Sunil

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Multiplexing a Redo log between Disk group and Physical

Postby Tim... » Wed Feb 27, 2013 8:31 am

Hi.

Oracle is totally happy with a mix of ASM and file system. You don't need any docs for this. Just create the member in the file system of your choice.

Just remember, the redo log files need to be on shared storage. All nodes must have access to see it.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

sunilmenon82
Member
Posts: 9
Joined: Sun Jan 01, 2012 6:15 pm

Re: Multiplexing a Redo log between Disk group and Physical

Postby sunilmenon82 » Wed Feb 27, 2013 9:08 am

Thanks Tim ...

What happens if one that member is unavailable . Will my DB work with out any disruption

Regards

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Multiplexing a Redo log between Disk group and Physical

Postby Tim... » Wed Feb 27, 2013 12:17 pm

Hi.

Yes. read the section called "Responding to Redo Log Failure" here:

http://docs.oracle.com/cd/E11882_01/ser ... m#i1006249

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle RAC and Clusterware”

Who is online

Users browsing this forum: No registered users and 3 guests