Anyone has experience with mirroring vg for Oracle Database and Application Post: 302784817

Sponsored Content

Operating Systems AIX Anyone has experience with mirroring vg for Oracle Database and Application Post 302784817 by ross.mather on Saturday 23rd of March 2013 06:17:56 AM

03-23-2013

Registered User

The vast majority of Databases that I see are hosted on SAN Disk arrays, and in that case I'd suggest that you let these arrays manage the RAID level on the disk. The only cases in those circumstances that you would mirror the disks at an AIx level would be for redundancy across disk arrays.

If ku are using local disks then you need to be careful how you lay out your volumes to avoid disks running hot. In a mirrored pair, a write is only concluded when both disks report that the write is complete, so hat can be slower than a single disk. However Reads are from any member of the mirror so can be faster.

ross.mather

View Public Profile for ross.mather

Find all posts by ross.mather

4 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

UNIX Database / Application Installation

Greetings, forgive me if this is listed in another thread somewhere, I am short on time. I am being interviewed for the position of UNIX Database and Job code installer for a consulting firm. I have never installed or worked on a native UNIX system. I have been running Linux (RH,SuSE,Slackware)...

2. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General...

3. AIX

Filesystem using Oracle and mirroring VG ?

Hello, I have a filesystem which has Oracle EBS 11.5.9 running and database 9i # df -g Filesystem GB blocks Free %Used Iused %Iused Mounted on /dev/fslv00 270.00 69.68 75% 746263 5% /oratec which is in oraclevg # lsvg oraclevg VOLUME GROUP: ...

4. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL...

LEARN ABOUT DEBIAN

sql::reservedwords::oracle

SQL::ReservedWords::Oracle(3pm) 			User Contributed Perl Documentation			   SQL::ReservedWords::Oracle(3pm)

NAME

       SQL::ReservedWords::Oracle - Reserved SQL words by Oracle

SYNOPSIS

	  if ( SQL::ReservedWords::Oracle->is_reserved( $word ) ) {
	      print "$word is a reserved Oracle word!";
	  }

DESCRIPTION

       Determine if words are reserved by Oracle Database.

METHODS

       is_reserved( $word )
	   Returns a boolean indicating if $word is reserved by either Oracle7, Oracle8i, Oracle9i or Oracle10g.

       is_reserved_by_oracle7( $word )
	   Returns a boolean indicating if $word is reserved by Oracle7.

       is_reserved_by_oracle8( $word )
	   Returns a boolean indicating if $word is reserved by Oracle8i.

       is_reserved_by_oracle9( $word )
	   Returns a boolean indicating if $word is reserved by Oracle9i.

       is_reserved_by_oracle10( $word )
	   Returns a boolean indicating if $word is reserved by Oracle10g.

       reserved_by( $word )
	   Returns a list with Oracle versions that reserves $word.

       words
	   Returns a list with all reserved words.

EXPORTS

       Nothing by default. Following subroutines can be exported:

       is_reserved
       is_reserved_by_oracle7
       is_reserved_by_oracle8
       is_reserved_by_oracle9
       is_reserved_by_oracle10
       reserved_by
       words

SEE ALSO

       SQL::ReservedWords

       <http://www.oracle.com/technology/documentation/>

AUTHOR

       Christian Hansen "chansen@cpan.org"

COPYRIGHT

       This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.8.8							    2008-03-28					   SQL::ReservedWords::Oracle(3pm)