Message-ID: <BLU179-W781DE8C766BB17E6A98461EBDF0@phx.gbl>
Content-Type: multipart/related;
 boundary="_21e24519-7462-48c8-8a74-3104856e8247_"
From: Iggy Fernandez <iggy_fernandez@hotmail.com>
To: "dedba@tpg.com.au" <dedba@tpg.com.au>, "pete.sharman@oracle.com"
 <pete.sharman@oracle.com>, Seth Miller <sethmiller.sm@gmail.com>
CC: Oracle Discussion List <oracle-l@freelists.org>
Subject: RE: Anyone with experience with the Oracle Data Appliance/ODA?
Date: Tue, 2 Feb 2016 10:36:14 -0800
In-Reply-To: <56B092B7.3020702@tpg.com.au>
References:
 <0D8F4CAC0F9D3C4AACC63F50FD9957F75457CBF0@PRDCTWPEMLMB31.prod-am.ameritrade.com>
 <9AC8C8EE-7604-4A76-B047-52646E10BD2B@gmail.com>
 <56ABCDD6.3090502@gmail.com>	<56AC3F1B.7050604@tpg.com.au>
 <CAEueRAVkqWaVo419BvvD5vYXg1RTomjMAq0c0yMO55Z_QRdaFQ@mail.gmail.com>
 <56AE996B.7040207@tpg.com.au>
 <2c01b202-429c-4a58-a988-b28393b52e01@default>,<56B092B7.3020702@tpg.com.au>
MIME-Version: 1.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: iggy_fernandez@hotmail.com
--_21e24519-7462-48c8-8a74-3104856e8247_
Content-Type: multipart/alternative;
 boundary="_c56f0b72-24f6-4257-95c8-2ddc8ff91225_"
--_c56f0b72-24f6-4257-95c8-2ddc8ff91225_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

The ODA documentation implies that thin cloning functionality is available =
on the ODA.
https://docs.oracle.com/cd/E22693_01/doc.12/e55580/dbadmin.htm#BAJIJABFCrea=
ting Snapshot DatabasesAn Oracle snapshot database is created by taking a s=
napshot of the ACFS file system where the source datafiles reside. The sour=
ce database can be single instance=2C Oracle RAC=2C or Oracle RAC One Node.=
 Compared to other methods of creating copies of databases=2C snapshot data=
bases require less time and storage space and involve no downtime of the so=
urce database. Additionally=2C you can create any database type and class f=
rom any other type and class. For example=2C you can create an Oracle RAC d=
atabase from an Oracle RAC One Node database. Similarly=2C you can create a=
 database that is different in size than the source database.On Oracle Data=
base Appliance=2C you can create snapshot databases from any Oracle Databas=
e stored on Oracle ASM Cluster File Systems (ACFS). Beginning with Oracle D=
atabase Appliance Release 12.1.2.0.0=2C this includes any Oracle Database R=
elease 11.2.0.4 or later database created or upgraded on the system. Additi=
onal requirements for a database to be used as the source for a snapshot da=
tabase include:must not be a standby or container database
must not be running in read-only mode=2C or in restricted mode=2C or in onl=
ine backup mode
must be in ARCHIVELOG mode
must have all defined datafiles available and onlineAlso=2C ensure that the=
 system clocks on the two Oracle Database Appliance nodes are synchronized =
before creating a snapshot database. To create a snapshot database=2C use t=
heoakcli create snapshotdb command=2C as shown in the following example=2C =
which creates a snapshot database named snapprod from the database named pr=
od.oakcli create snapshotdb -db snapprod -from prodBefore issuing the comma=
nd=2C ensure that the system clocks on the two Oracle Database Appliance no=
des are synchronized. If the clocks are sufficiently different=2C the comma=
nd may fail.


Date: Tue=2C 2 Feb 2016 21:27:51 +1000
From: dedba@tpg.com.au
To: pete.sharman@oracle.com=3B sethmiller.sm@gmail.com
CC: oracle-l@freelists.org
Subject: Re: Anyone with experience with the Oracle Data Appliance/ODA?

=0A=
  =0A=
    =0A=
  =0A=
  =0A=
    Thanks Pete.
=0A=
   =20
=0A=
    I've now seen the ODA. The database is version 11.2.0.4. The data=0A=
    files are stored in ASM disk groups=2C not on ACFS mounts. I am not=0A=
    sure if it is still possible to create snapshots with oakcli in this=0A=
    situation?
=0A=
   =20
=0A=
    Is the snap clone functionality in EM/Cloud Control licensed with=0A=
    any optional pack? It sounds promising.. there is not much disk=0A=
    space left on the array=2C so a thin clone is preferable  =3B-)=20
=0A=
   =20
=0A=
    Cheers=2C
=0A=
    Tony
=0A=
   =20
=0A=
    On 2/02/2016 12:45 pm=2C Peter Sharman=0A=
      wrote:
=0A=
    =0A=
    =0A=
      =0A=
      =0A=
      =0A=
      =0A=
      =0A=
        Tony=0A=
         =0A=
        I=0A=
            don=92t think I saw anything about database versions in the=0A=
            thread=2C so there are a couple of other options you could use=
=0A=
            depending on the version:=0A=
         =0A=
        =B7         If=0A=
            the DB is 12c=2C there is snapshotting capability built into=0A=
            the database itself=0A=
        =B7         From=0A=
            DB 10g onwards you could look at using Enterprise Manager=92s=
=0A=
            Snap Clone functionality which uses copy on write technology=0A=
            to build thin clones=2C optionally including masking as well. =
=0A=
            This may make it easier for you to do the snapshotting as=0A=
            its built into the product=2C which makes it less error prone=
=0A=
            than a manual snapshotting process.=0A=
         =0A=
        Let=0A=
            me know if you need any more details on that.=0A=
         =0A=
        =0A=
          Pete=0A=
          =0A=
          Pete=0A=
              Sharman
=0A=
              Database Architect=2C DBaaS / DBLM
=0A=
              Enterprise Manager Product Suite
=0A=
              33 Benson Crescent CALWELL ACT 2905 AUSTRALIA=0A=
          Phone:=0A=
              +61262924095 | |=0A=
              Mobile: +61414443449=20
=0A=
            Email:=0A=
              pete.sharman@oracle.com =0A=
              Twitter: @SharmanPete  LinkedIn: au.linkedin.com/in/petesharm=
an
=0A=
            Website:=0A=
              petewhodidnottweet.com=0A=
          =0A=
              =0A=
          "Controlling=0A=
              developers is like herding cats."=0A=
          Kevin=0A=
              Loney=2C Oracle DBA Handbook=0A=
           =0A=
          "Oh=0A=
              no=2C it's not=2C it's much harder than that!"=0A=
          Bruce=0A=
              Pihlamae=2C long term Oracle DBA=0A=
          =0A=
              =0A=
        =0A=
         =0A=
        =0A=
          =0A=
            From: De DBA [mailto:dedba@tpg.com.au]=20
=0A=
                Sent: Monday=2C February 1=2C 2016 10:32 AM
=0A=
                To: Seth Miller <sethmiller.sm@gmail.com>
=0A=
                Cc: Oracle Discussion List=0A=
                <oracle-l@freelists.org>
=0A=
                Subject: Re: Anyone with experience with the=0A=
                Oracle Data Appliance/ODA?=0A=
          =0A=
        =0A=
         =0A=
        Seth=2C
=0A=
         =20
=0A=
          Thanks for that. I haven't got access to the systems yet=2C just=
=0A=
          reading up and preparing for the shock..=0A=
        =0A=
          You=0A=
              will not find OCFS on the ODA. It uses ACFS for the=0A=
              cluster file system as well as the database files.=0A=
        =0A=
        =0A=
           =0A=
        =0A=
        Ah=2C yes=2C of course=2C it's on ASM... I=0A=
          understand that oakcli will create & manage fs=0A=
          automatically=2C but I'm not going to have RAC. One node is=0A=
          supposed to be production=2C whereas the other node will run=0A=
          dev=2C test and UAT. I will need to refresh the dev & test=0A=
          databases from production=2C and wonder whether I can create a=0A=
          snapshot=2C do the masking etc. and then mount the copy on the=0A=
          other node where it will then be used as the gold copy for the=0A=
          refreshes.
=0A=
         =20
=0A=
          get yourself a couple of=0A=
            excellent books. =0A=
        =0A=
          Practical=0A=
                Oracle Database Appliance=0A=
        =0A=
        =0A=
          Oracle=0A=
              Database Appliance: A Hands-On Guide=0A=
        =0A=
       =20
=0A=
          I did look at the first one=2C which has some famous names=0A=
          amongst the authors. One of the reviews that I saw mentions=0A=
          that it is somewhat dated? Is it still worthwhile getting even=0A=
          if you work with the latest hard/software?
=0A=
         =20
=0A=
          Cheers=2C
=0A=
          Tony=0A=
        =0A=
          On 31/01/2016 2:45 pm=2C Seth Miller wrote:=0A=
        =0A=
        =0A=
          =0A=
            Tony=2C =0A=
            =0A=
               =0A=
            =0A=
            =0A=
              The=0A=
                  ODAs apparently are each set up as two stand-alone=0A=
                  servers with shared storage. I understand that one=0A=
                  needs to use oakcli to create databases and that this=0A=
                  tool hides pretty much all functionality that we are=0A=
                  used to through dbca etc.=0A=
            =0A=
            =0A=
              Yes=2C oakcli is the=0A=
                  magic behind ODA but it does not preclude you from=0A=
                  using DBCA. If you need to create a database that does=0A=
                  not fall into one of the oakcli templates=2C feel free=0A=
                  to use DBCA or any other classic method.=0A=
            =0A=
            =0A=
               =0A=
            =0A=
            =0A=
              But=0A=
                  what does it do exactly?=0A=
            =0A=
            =0A=
              Oakcli is nothing=0A=
                  more than a bunch of very well written perl and shell=0A=
                  scripts that wrap the classic tools included with the=0A=
                  Oracle database software. They are easy to find and=0A=
                  read if you really want to know what they are doing.=0A=
            =0A=
            =0A=
               =0A=
            =0A=
            =0A=
              How=0A=
                  does one manage the OCFS?=0A=
            =0A=
            =0A=
              You will not find=0A=
                  OCFS on the ODA. It uses ACFS for the cluster file=0A=
                  system as well as the database files.=0A=
            =0A=
            =0A=
               =0A=
            =0A=
            =0A=
              Can a=0A=
                  file system be mounted on both nodes=2C or just on one?=
=0A=
                  Is this automatic?=0A=
            =0A=
            =0A=
              Oakcli will take=0A=
                  care of this for you.=0A=
            =0A=
            =0A=
               =0A=
            =0A=
            =0A=
              Given a=0A=
                  complete backup (... which is a problem all of its=0A=
                  own...)=2C how does one restore a database?=0A=
            =0A=
            =0A=
              Use RMAN or=0A=
                  Enterprise Manager for this. There will be little=0A=
                  difference from a standard RAC database in how you=0A=
                  backup and restore a database.=0A=
            =0A=
            =0A=
               =0A=
            =0A=
            =0A=
              Don't=0A=
                  use centralised wallets with TDE=2C otherwise problems=0A=
                  will arise -- but what does that even mean?=0A=
            =0A=
            =0A=
              This isn't specific=0A=
                  to the ODA. There are a number of reasons to have=0A=
                  local wallets in RAC -- one of the most important=0A=
                  being that you can't have a local only autologin=0A=
                  wallet if it is shared with multiple nodes.=0A=
            =0A=
            =0A=
               =0A=
            =0A=
            =0A=
              You=0A=
                  will find little argument that the documentation for=0A=
                  ODA is mediocre at best. This is why a number of=0A=
                  training companies (including the one I teach for)=0A=
                  have developed their own content for the ODA. I think=0A=
                  your best course of action=2C though=2C is to get yoursel=
f=0A=
                  a couple of excellent books.=0A=
            =0A=
            =0A=
              Practical=0A=
                    Oracle Database Appliance=0A=
            =0A=
            =0A=
              Oracle=0A=
                  Database Appliance: A Hands-On Guide=0A=
            =0A=
            =0A=
               =0A=
            =0A=
            =0A=
              Seth=0A=
                  Miller=0A=
            =0A=
          =0A=
          =0A=
             =0A=
            =0A=
              On Fri=2C Jan 29=2C 2016 at 10:42 PM=2C De=0A=
                DBA <dedba@tpg.com.au>=0A=
                wrote:=0A=
              =0A=
                 =0A=
                =0A=
                  I've=0A=
                    just read through that documentation=2C as I will=0A=
                    shortly get the responsibility for 2 ODA's. I would=0A=
                    not classify the 3 software manuals and 2 hw manuals=0A=
                    as good documentation. After reading all of it=2C I've=
=0A=
                    got more questions than what I started out with...=20
=0A=
                   =20
=0A=
                    The ODAs apparently are each set up as two=0A=
                    stand-alone servers with shared storage. I=0A=
                    understand that one needs to use oakcli to create=0A=
                    databases and that this tool hides pretty much all=0A=
                    functionality that we are used to through dbca etc.=0A=
                    But what does it do exactly? How does one manage the=0A=
                    OCFS? Can a file system be mounted on both nodes=2C or=
=0A=
                    just on one? Is this automatic? Given a complete=0A=
                    backup (... which is a problem all of its own...)=2C=0A=
                    how does one restore a database? Don't use=0A=
                    centralised wallets with TDE=2C otherwise problems=0A=
                    will arise -- but what does that even mean?=0A=
                    Questions...=20
=0A=
                   =20
=0A=
                    Pointers to more complete documentation/blogs/etc.=0A=
                    regarding managing and patching the ODA are very=0A=
                    welcome!
=0A=
                   =20
=0A=
                    Cheers=2C
=0A=
                    Tony =0A=
                  =0A=
                    On 30/01/2016 6:38 am=2C Hans=0A=
                      Forbrich wrote:=0A=
                  =0A=
                  =0A=
                    =0A=
                      Yes=2C lack of documentation=0A=
                        was a problem at one time.
=0A=
                       =20
=0A=
                        That has significantly improved.  See http://docs.o=
racle.com/en/engineered-systems/
=0A=
                       =20
=0A=
                        /Hans
=0A=
                       =20
=0A=
                        On 29/01/2016 12:54 PM=2C Andrew Kerber wrote:=0A=
                    =0A=
                    =0A=
                      =0A=
                        I have run into problem=0A=
                          with a lack of good documentation on its use.=20
=0A=
                         =20
=0A=
                          Sent from my iPad=0A=
                      =0A=
                      =0A=
                       =20
=0A=
                          On Jan 29=2C 2016=2C at 1:49 PM=2C <Jay.Miller@td=
ameritrade.com>=0A=
                          <Jay.Miller@tdameritrade.com>=0A=
                          wrote:=0A=
                      =0A=
                      =0A=
                        =0A=
                          =0A=
                            Hi=0A=
                             =0A=
                            We=0A=
                              just attended an ODA presentation and it=0A=
                              looks very promising as a solution for our=0A=
                              non-prod testing environment as it would=0A=
                              allow us to clone multiple instances of=0A=
                              the gold copy test databases easily=0A=
                              (without needing to coordinate with other=0A=
                              departments as we do now) and apply=0A=
                              patches for those environments quickly and=0A=
                              easily as well.=0A=
                             =0A=
                            Any=0A=
                              real life pros or cons that anyone has=0A=
                              experienced with the appliance? We=92d keep=
=0A=
                              our production and performance testing=0A=
                              environments off it at least for now.=0A=
                             =0A=
                             =0A=
                            Jay=0A=
                              Miller=0A=
                            Sr.=0A=
                              Oracle DBA=0A=
                            201.369.8355=0A=
                             =0A=
                          =0A=
                        =0A=
                      =0A=
                    =0A=
                     =0A=
                  =0A=
                   =0A=
                =0A=
              =0A=
            =0A=
             =0A=
          =0A=
        =0A=
         =0A=
      =0A=
    =0A=
   =20
 		 	   		  =

--_c56f0b72-24f6-4257-95c8-2ddc8ff91225_
Content-Type: text/html; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style><!--
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 12pt=3B
font-family:Calibri
}
--></style></head>
<body class=3D'hmmessage'><div dir=3D'ltr'><font size=3D"3" style=3D"font-s=
ize:12pt=3B" color=3D"#000000">The ODA documentation implies that thin clon=
ing functionality is available on the ODA.</font><div><br></div><div><a hre=
f=3D"https://docs.oracle.com/cd/E22693_01/doc.12/e55580/dbadmin.htm#BAJIJAB=
F" target=3D"_blank">https://docs.oracle.com/cd/E22693_01/doc.12/e55580/dba=
dmin.htm#BAJIJABF</a></div><blockquote style=3D"margin: 0 0 0 40px=3B borde=
r: none=3B padding: 0px=3B"><div><div><h3 class=3D"sect2" style=3D"box-sizi=
ng: border-box=3B margin: 1em 0px 8px=3B padding: 0px=3B font-weight: 500=
=3B color: rgb(37=2C 37=2C 37)=3B text-rendering: optimizeLegibility=3B lin=
e-height: 1.2=3B background-color: rgb(255=2C 255=2C 255)=3B"><font size=3D=
"3">Creating Snapshot Databases</font></h3></div></div><div><p style=3D"box=
-sizing: border-box=3B margin-bottom: 1.25rem=3B line-height: 1.4=3B text-r=
endering: optimizeLegibility=3B max-width: 90em=3B color: rgb(34=2C 34=2C 3=
4)=3B background-color: rgb(255=2C 255=2C 255)=3B"><font size=3D"3">An Orac=
le&nbsp=3B<a id=3D"sthref86" style=3D"box-sizing: border-box=3B color: rgb(=
29=2C 90=2C 171)=3B line-height: inherit=3B"></a>snapshot&nbsp=3B<a id=3D"s=
thref87" style=3D"box-sizing: border-box=3B color: rgb(29=2C 90=2C 171)=3B =
line-height: inherit=3B"></a>database is created by taking a snapshot of th=
e ACFS file system where the source datafiles reside. The source database c=
an be single instance=2C Oracle RAC=2C or Oracle RAC One Node. <b>Compared =
to other methods of creating copies of databases=2C snapshot databases requ=
ire less time and storage space and involve no downtime of the source datab=
ase.</b> Additionally=2C you can create any database type and class from an=
y other type and class. For example=2C you can create an Oracle RAC databas=
e from an Oracle RAC One Node database. Similarly=2C you can create a datab=
ase that is different in size than the source database.</font></p></div><di=
v><p style=3D"box-sizing: border-box=3B margin-bottom: 1.25rem=3B line-heig=
ht: 1.4=3B text-rendering: optimizeLegibility=3B max-width: 90em=3B color: =
rgb(34=2C 34=2C 34)=3B background-color: rgb(255=2C 255=2C 255)=3B"><font s=
ize=3D"3">On Oracle Database Appliance=2C you can create snapshot databases=
 from any Oracle Database stored on Oracle ASM Cluster File Systems (ACFS).=
 Beginning with Oracle Database Appliance Release 12.1.2.0.0=2C this includ=
es any Oracle Database Release 11.2.0.4 or later database created or upgrad=
ed on the system. Additional requirements for a database to be used as the =
source for a snapshot database include:</font></p></div><font size=3D"3">mu=
st not be a standby or container database<br></font><font size=3D"3">must n=
ot be running in read-only mode=2C or in restricted mode=2C or in online ba=
ckup mode<br></font><font size=3D"3">must be in ARCHIVELOG mode<br></font><=
font size=3D"3">must have all defined datafiles available and online</font>=
<div><p style=3D"box-sizing: border-box=3B margin-bottom: 1.25rem=3B line-h=
eight: 1.4=3B text-rendering: optimizeLegibility=3B max-width: 90em=3B colo=
r: rgb(34=2C 34=2C 34)=3B background-color: rgb(255=2C 255=2C 255)=3B"><fon=
t size=3D"3">Also=2C ensure that the system clocks on the two Oracle Databa=
se Appliance nodes are synchronized before creating a snapshot database. To=
 create a snapshot database=2C use the<code dir=3D"ltr" style=3D"box-sizing=
: border-box=3B color: rgb(0=2C 0=2C 0)=3B line-height: 1.615=3B padding: 3=
px 0px=3B">o</code><code dir=3D"ltr" style=3D"box-sizing: border-box=3B col=
or: rgb(0=2C 0=2C 0)=3B line-height: 1.615=3B padding: 3px 0px=3B">akcli cr=
eate snapshotdb</code>&nbsp=3Bcommand=2C as shown in the following example=
=2C which creates a snapshot database named&nbsp=3B<code dir=3D"ltr" style=
=3D"box-sizing: border-box=3B color: rgb(0=2C 0=2C 0)=3B line-height: 1.615=
=3B padding: 3px 0px=3B">snapprod</code>&nbsp=3Bfrom the database named&nbs=
p=3B<code dir=3D"ltr" style=3D"box-sizing: border-box=3B color: rgb(0=2C 0=
=2C 0)=3B line-height: 1.615=3B padding: 3px 0px=3B">prod</code>.</font></p=
></div><div><pre dir=3D"ltr" style=3D"box-sizing: border-box=3B line-height=
: 1.615=3B border: 1px solid rgb(217=2C 217=2C 226)=3B border-radius: 3px=
=3B padding: 5px=3B overflow: auto=3B margin-top: 0px=3B margin-bottom: 1em=
=3B word-wrap: normal !important=3B background-color: rgb(249=2C 249=2C 251=
)=3B"><font size=3D"3" face=3D"Calibri=2C sans-serif">oakcli create snapsho=
tdb -db snapprod -from prod</font></pre></div><div><p style=3D"box-sizing: =
border-box=3B margin-bottom: 1.25rem=3B line-height: 1.4=3B text-rendering:=
 optimizeLegibility=3B max-width: 90em=3B color: rgb(34=2C 34=2C 34)=3B bac=
kground-color: rgb(255=2C 255=2C 255)=3B"><font size=3D"3">Before issuing t=
he command=2C ensure that the system clocks on the two Oracle Database Appl=
iance nodes are synchronized. If the clocks are sufficiently different=2C t=
he command may fail.</font></p></div></blockquote><div><br><br><br><br><div=
><hr id=3D"stopSpelling">Date: Tue=2C 2 Feb 2016 21:27:51 +1000<br>From: de=
dba@tpg.com.au<br>To: pete.sharman@oracle.com=3B sethmiller.sm@gmail.com<br=
>CC: oracle-l@freelists.org<br>Subject: Re: Anyone with experience with the=
 Oracle Data Appliance/ODA?<br><br>=0A=
  =0A=
    =0A=
  =0A=
  =0A=
    Thanks Pete.<br>=0A=
    <br>=0A=
    I've now seen the ODA. The database is version 11.2.0.4. The data=0A=
    files are stored in ASM disk groups=2C not on ACFS mounts. I am not=0A=
    sure if it is still possible to create snapshots with oakcli in this=0A=
    situation?<br>=0A=
    <br>=0A=
    Is the snap clone functionality in EM/Cloud Control licensed with=0A=
    any optional pack? It sounds promising.. there is not much disk=0A=
    space left on the array=2C so a thin clone is preferable <span class=3D=
"ecxmoz-smiley-s3"><span> =3B-) </span></span><br>=0A=
    <br>=0A=
    Cheers=2C<br>=0A=
    Tony<br>=0A=
    <br>=0A=
    <div class=3D"ecxmoz-cite-prefix">On 2/02/2016 12:45 pm=2C Peter Sharma=
n=0A=
      wrote:<br>=0A=
    </div>=0A=
    <blockquote cite=3D"mid:2c01b202-429c-4a58-a988-b28393b52e01@default">=
=0A=
      =0A=
      =0A=
      =0A=
      <style><!--=0A=
.ExternalClass p.ecxMsoNormal=2C .ExternalClass li.ecxMsoNormal=2C .Externa=
lClass div.ecxMsoNormal {=0A=
font-size:12.0pt=3B=0A=
font-family:"Times New Roman"=2Cserif=3B=0A=
color:black=3B=0A=
}=0A=
=0A=
.ExternalClass a:link=2C .ExternalClass span.ecxMsoHyperlink {=0A=
color:blue=3B=0A=
text-decoration:underline=3B=0A=
}=0A=
=0A=
.ExternalClass span.ecxMsoHyperlinkFollowed {=0A=
color:purple=3B=0A=
text-decoration:underline=3B=0A=
}=0A=
=0A=
.ExternalClass p.ecxMsoListParagraph=2C .ExternalClass li.ecxMsoListParagra=
ph=2C .ExternalClass div.ecxMsoListParagraph {=0A=
font-size:12.0pt=3B=0A=
font-family:"Times New Roman"=2Cserif=3B=0A=
color:black=3B=0A=
}=0A=
=0A=
.ExternalClass span.ecxhoenzb {=0A=
}=0A=
=0A=
.ExternalClass span.ecxEmailStyle18 {=0A=
font-family:"Calibri"=2Csans-serif=3B=0A=
color:#1F497D=3B=0A=
}=0A=
=0A=
.ExternalClass .ecxMsoChpDefault {=0A=
font-size:10.0pt=3B=0A=
}=0A=
=0A=
.ExternalClass div.ecxWordSection1 {=0A=
}=0A=
=0A=
.ExternalClass ol {=0A=
}=0A=
=0A=
.ExternalClass ul {=0A=
}=0A=
=0A=
--></style>=0A=
      <div class=3D"ecxWordSection1">=0A=
        <p class=3D"ecxMsoNormal"><span style=3D"font-size:11.0pt=3Bfont-fa=
mily:&quot=3BCalibri&quot=3B=2Csans-serif=3Bcolor:#1F497D=3B">Tony</span></=
p>=0A=
        <p class=3D"ecxMsoNormal"><span style=3D"font-size:11.0pt=3Bfont-fa=
mily:&quot=3BCalibri&quot=3B=2Csans-serif=3Bcolor:#1F497D=3B">&nbsp=3B</spa=
n></p>=0A=
        <p class=3D"ecxMsoNormal"><span style=3D"font-size:11.0pt=3Bfont-fa=
mily:&quot=3BCalibri&quot=3B=2Csans-serif=3Bcolor:#1F497D=3B">I=0A=
            don=92t think I saw anything about database versions in the=0A=
            thread=2C so there are a couple of other options you could use=
=0A=
            depending on the version:</span></p>=0A=
        <p class=3D"ecxMsoNormal"><span style=3D"font-size:11.0pt=3Bfont-fa=
mily:&quot=3BCalibri&quot=3B=2Csans-serif=3Bcolor:#1F497D=3B">&nbsp=3B</spa=
n></p>=0A=
        <p class=3D"ecxMsoListParagraph" style=3D"text-indent:-.25in=3B"><s=
pan style=3D"font-size:11.0pt=3Bfont-family:Symbol=3Bcolor:#1F497D=3B"><spa=
n style=3D"">=B7<span style=3D"font:7.0pt &quot=3BTimes New Roman&quot=3B=
=3B">&nbsp=3B&nbsp=3B&nbsp=3B&nbsp=3B&nbsp=3B&nbsp=3B&nbsp=3B&nbsp=3B </spa=
n></span></span><span style=3D"font-size:11.0pt=3Bfont-family:&quot=3BCalib=
ri&quot=3B=2Csans-serif=3Bcolor:#1F497D=3B">If=0A=
            the DB is 12c=2C there is snapshotting capability built into=0A=
            the database itself</span></p>=0A=
        <p class=3D"ecxMsoListParagraph" style=3D"text-indent:-.25in=3B"><s=
pan style=3D"font-size:11.0pt=3Bfont-family:Symbol=3Bcolor:#1F497D=3B"><spa=
n style=3D"">=B7<span style=3D"font:7.0pt &quot=3BTimes New Roman&quot=3B=
=3B">&nbsp=3B&nbsp=3B&nbsp=3B&nbsp=3B&nbsp=3B&nbsp=3B&nbsp=3B&nbsp=3B </spa=
n></span></span><span style=3D"font-size:11.0pt=3Bfont-family:&quot=3BCalib=
ri&quot=3B=2Csans-serif=3Bcolor:#1F497D=3B">From=0A=
            DB 10g onwards you could look at using Enterprise Manager=92s=
=0A=
            Snap Clone functionality which uses copy on write technology=0A=
            to build thin clones=2C optionally including masking as well.&n=
bsp=3B=0A=
            This may make it easier for you to do the snapshotting as=0A=
            its built into the product=2C which makes it less error prone=
=0A=
            than a manual snapshotting process.</span></p>=0A=
        <p class=3D"ecxMsoNormal"><span style=3D"font-size:11.0pt=3Bfont-fa=
mily:&quot=3BCalibri&quot=3B=2Csans-serif=3Bcolor:#1F497D=3B">&nbsp=3B</spa=
n></p>=0A=
        <p class=3D"ecxMsoNormal"><span style=3D"font-size:11.0pt=3Bfont-fa=
mily:&quot=3BCalibri&quot=3B=2Csans-serif=3Bcolor:#1F497D=3B">Let=0A=
            me know if you need any more details on that.</span></p>=0A=
        <p class=3D"ecxMsoNormal"><span style=3D"font-size:11.0pt=3Bfont-fa=
mily:&quot=3BCalibri&quot=3B=2Csans-serif=3Bcolor:#1F497D=3B">&nbsp=3B</spa=
n></p>=0A=
        <div>=0A=
          <p class=3D"ecxMsoNormal"><span style=3D"font-size:10.0pt=3Bfont-=
family:&quot=3BTahoma&quot=3B=2Csans-serif=3Bcolor:#1F497D=3B">Pete</span><=
/p>=0A=
          <p class=3D"ecxMsoNormal" style=3D""><span style=3D"font-size:10.=
0pt=3Bfont-family:&quot=3BTahoma&quot=3B=2Csans-serif=3Bcolor:#1F497D=3B"><=
img id=3D"ecxPicture_x0020_1" src=3D"cid:part1.04000500.08020104@tpg.com.au=
" alt=3D"Oracle                  logo" height=3D"17" width=3D"88"></span></=
p>=0A=
          <p class=3D"ecxMsoNormal" style=3D""><span style=3D"font-size:10.=
0pt=3Bfont-family:&quot=3BTahoma&quot=3B=2Csans-serif=3Bcolor:#666666=3B">P=
ete=0A=
              Sharman<br>=0A=
              Database Architect=2C DBaaS / DBLM<br>=0A=
              Enterprise Manager Product Suite<br>=0A=
              33 Benson Crescent CALWELL ACT 2905 AUSTRALIA</span></p>=0A=
          <p class=3D"ecxMsoNormal" style=3D""><span style=3D"font-size:10.=
0pt=3Bfont-family:&quot=3BTahoma&quot=3B=2Csans-serif=3Bcolor:#666666=3B">P=
hone:=0A=
              <a target=3D"_blank"><span style=3D"color:black=3B">+61262924=
095</span></a> | |=0A=
              Mobile: </span><u><span style=3D"font-size:10.0pt=3Bfont-fami=
ly:&quot=3BTahoma&quot=3B=2Csans-serif=3Bcolor:#1F497D=3B">+61414443449</sp=
an></u><span style=3D"font-size:10.0pt=3Bfont-family:&quot=3BTahoma&quot=3B=
=2Csans-serif=3Bcolor:#1F497D=3B">&nbsp=3B<br>=0A=
            </span><span style=3D"font-size:10.0pt=3Bfont-family:&quot=3BTa=
homa&quot=3B=2Csans-serif=3Bcolor:#595959=3B">Email:=0A=
              <a href=3D"mailto:pete.sharman@oracle.com"><span style=3D"col=
or:#0563C1=3B">pete.sharman@oracle.com</span></a>&nbsp=3B=0A=
              Twitter: @SharmanPete&nbsp=3B LinkedIn: </span><span style=3D=
"font-size:10.0pt=3Bfont-family:&quot=3BArial&quot=3B=2Csans-serif=3Bcolor:=
#66696A=3Bborder:none windowtext 1.0pt=3Bpadding:0in=3Bbackground:white=3B"=
>au.linkedin.com/in/</span><span style=3D"font-size:10.0pt=3Bfont-family:&q=
uot=3BArial&quot=3B=2Csans-serif=3Bcolor:#333333=3Bborder:none windowtext 1=
.0pt=3Bpadding:0in=3Bbackground:white=3B">petesharman</span><span style=3D"=
font-size:11.0pt=3Bfont-family:&quot=3BCalibri&quot=3B=2Csans-serif=3Bcolor=
:#1F497D=3B"><br>=0A=
            </span><span style=3D"font-size:10.0pt=3Bfont-family:&quot=3BAr=
ial&quot=3B=2Csans-serif=3Bcolor:#333333=3Bborder:none windowtext 1.0pt=3Bp=
adding:0in=3Bbackground:white=3B">Website:=0A=
              petewhodidnottweet.com</span><span style=3D"font-size:10.0pt=
=3Bfont-family:&quot=3BTahoma&quot=3B=2Csans-serif=3Bcolor:#1F497D=3B"></sp=
an></p>=0A=
          <div class=3D"ecxMsoNormal" style=3D"text-align:center=3B" align=
=3D"center"><span style=3D"font-size:10.0pt=3Bfont-family:&quot=3BTahoma&qu=
ot=3B=2Csans-serif=3Bcolor:#1F497D=3B">=0A=
              <hr align=3D"center" size=3D"3" width=3D"100%"></span></div>=
=0A=
          <p class=3D"ecxMsoNormal"><span style=3D"font-size:10.0pt=3Bfont-=
family:&quot=3BTahoma&quot=3B=2Csans-serif=3Bcolor:#1F497D=3B">"Controlling=
=0A=
              developers is like herding cats."</span><span style=3D"font-s=
ize:10.0pt=3Bfont-family:&quot=3BTahoma&quot=3B=2Csans-serif=3Bcolor:#1F497=
D=3B"></span></p>=0A=
          <p class=3D"ecxMsoNormal"><span style=3D"font-size:10.0pt=3Bfont-=
family:&quot=3BTahoma&quot=3B=2Csans-serif=3Bcolor:#0070C0=3B">Kevin=0A=
              Loney=2C Oracle DBA Handbook</span></p>=0A=
          <p class=3D"ecxMsoNormal"><span style=3D"font-size:10.0pt=3Bfont-=
family:&quot=3BTahoma&quot=3B=2Csans-serif=3Bcolor:#1F497D=3B">&nbsp=3B</sp=
an></p>=0A=
          <p class=3D"ecxMsoNormal"><span style=3D"font-size:10.0pt=3Bfont-=
family:&quot=3BTahoma&quot=3B=2Csans-serif=3Bcolor:#1F497D=3B">"Oh=0A=
              no=2C it's not=2C it's much harder than that!"</span></p>=0A=
          <p class=3D"ecxMsoNormal"><span style=3D"font-size:10.0pt=3Bfont-=
family:&quot=3BTahoma&quot=3B=2Csans-serif=3Bcolor:#0070C0=3B">Bruce=0A=
              Pihlamae=2C long term Oracle DBA</span></p>=0A=
          <div class=3D"ecxMsoNormal" style=3D"text-align:center=3B" align=
=3D"center"><span style=3D"font-size:10.0pt=3Bfont-family:&quot=3BTahoma&qu=
ot=3B=2Csans-serif=3Bcolor:#1F497D=3B">=0A=
              <hr align=3D"center" size=3D"3" width=3D"100%"></span></div>=
=0A=
        </div>=0A=
        <p class=3D"ecxMsoNormal"><span style=3D"font-size:11.0pt=3Bfont-fa=
mily:&quot=3BCalibri&quot=3B=2Csans-serif=3Bcolor:#1F497D=3B">&nbsp=3B</spa=
n></p>=0A=
        <div>=0A=
          <div style=3D"border:none=3Bborder-top:solid #E1E1E1 1.0pt=3Bpadd=
ing:3.0pt 0in 0in 0in=3B">=0A=
            <p class=3D"ecxMsoNormal"><b><span style=3D"font-size:11.0pt=3B=
font-family:&quot=3BCalibri&quot=3B=2Csans-serif=3Bcolor:windowtext=3B" lan=
g=3D"EN-US">From:</span></b><span style=3D"font-size:11.0pt=3Bfont-family:&=
quot=3BCalibri&quot=3B=2Csans-serif=3Bcolor:windowtext=3B" lang=3D"EN-US"> =
De DBA [<a class=3D"ecxmoz-txt-link-freetext" href=3D"mailto:dedba@tpg.com.=
au">mailto:dedba@tpg.com.au</a>] <br>=0A=
                <b>Sent:</b> Monday=2C February 1=2C 2016 10:32 AM<br>=0A=
                <b>To:</b> Seth Miller <a class=3D"ecxmoz-txt-link-rfc2396E=
" href=3D"mailto:sethmiller.sm@gmail.com">&lt=3Bsethmiller.sm@gmail.com&gt=
=3B</a><br>=0A=
                <b>Cc:</b> Oracle Discussion List=0A=
                <a class=3D"ecxmoz-txt-link-rfc2396E" href=3D"mailto:oracle=
-l@freelists.org">&lt=3Boracle-l@freelists.org&gt=3B</a><br>=0A=
                <b>Subject:</b> Re: Anyone with experience with the=0A=
                Oracle Data Appliance/ODA?</span></p>=0A=
          </div>=0A=
        </div>=0A=
        <p class=3D"ecxMsoNormal">&nbsp=3B</p>=0A=
        <p class=3D"ecxMsoNormal" style=3D"">Seth=2C<br>=0A=
          <br>=0A=
          Thanks for that. I haven't got access to the systems yet=2C just=
=0A=
          reading up and preparing for the shock..</p>=0A=
        <div>=0A=
          <p class=3D"ecxMsoNormal"><span style=3D"font-size:9.5pt=3Bcolor:=
red=3B">You=0A=
              will not find OCFS on the ODA. It uses ACFS for the=0A=
              cluster file system as well as the database files.</span></p>=
=0A=
        </div>=0A=
        <div>=0A=
          <p class=3D"ecxMsoNormal">&nbsp=3B</p>=0A=
        </div>=0A=
        <p class=3D"ecxMsoNormal">Ah=2C yes=2C of course=2C it's on ASM... =
I=0A=
          understand that oakcli will create &amp=3B manage fs=0A=
          automatically=2C but I'm not going to have RAC. One node is=0A=
          supposed to be production=2C whereas the other node will run=0A=
          dev=2C test and UAT. I will need to refresh the dev &amp=3B test=
=0A=
          databases from production=2C and wonder whether I can create a=0A=
          snapshot=2C do the masking etc. and then mount the copy on the=0A=
          other node where it will then be used as the gold copy for the=0A=
          refreshes.<br>=0A=
          <br>=0A=
          <span style=3D"font-size:9.5pt=3B">get yourself a couple of=0A=
            excellent books.</span> </p>=0A=
        <div>=0A=
          <p class=3D"ecxMsoNormal"><span style=3D"font-size:9.5pt=3B"><a h=
ref=3D"http://www.amazon.com/Practical-Oracle-Database-Appliance-Curtis/dp/=
1430262656" target=3D"_blank">Practical=0A=
                Oracle Database Appliance</a></span></p>=0A=
        </div>=0A=
        <div>=0A=
          <p class=3D"ecxMsoNormal"><a href=3D"http://www.amazon.com/Oracle=
-Database-Appliance-Hands--Guide/dp/0071827447" target=3D"_blank">Oracle=0A=
              Database Appliance: A Hands-On Guide</a></p>=0A=
        </div>=0A=
        <p class=3D"ecxMsoNormal" style=3D""><br>=0A=
          I did look at the first one=2C which has some famous names=0A=
          amongst the authors. One of the reviews that I saw mentions=0A=
          that it is somewhat dated? Is it still worthwhile getting even=0A=
          if you work with the latest hard/software?<br>=0A=
          <br>=0A=
          Cheers=2C<br>=0A=
          Tony</p>=0A=
        <div>=0A=
          <p class=3D"ecxMsoNormal">On 31/01/2016 2:45 pm=2C Seth Miller wr=
ote:</p>=0A=
        </div>=0A=
        <blockquote style=3D"">=0A=
          <div>=0A=
            <p class=3D"ecxMsoNormal">Tony=2C </p>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal">&nbsp=3B</p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal"><span style=3D"font-size:9.5pt=3B">=
The=0A=
                  ODAs apparently are each set up as two stand-alone=0A=
                  servers with shared storage. I understand that one=0A=
                  needs to use oakcli to create databases and that this=0A=
                  tool hides pretty much all functionality that we are=0A=
                  used to through dbca etc.</span></p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal"><span style=3D"font-size:9.5pt=3Bco=
lor:red=3B">Yes=2C oakcli is the=0A=
                  magic behind ODA but it does not preclude you from=0A=
                  using DBCA. If you need to create a database that does=0A=
                  not fall into one of the oakcli templates=2C feel free=0A=
                  to use DBCA or any other classic method.</span></p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal">&nbsp=3B</p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal"><span style=3D"font-size:9.5pt=3B">=
But=0A=
                  what does it do exactly?</span></p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal"><span style=3D"font-size:9.5pt=3Bco=
lor:red=3B">Oakcli is nothing=0A=
                  more than a bunch of very well written perl and shell=0A=
                  scripts that wrap the classic tools included with the=0A=
                  Oracle database software. They are easy to find and=0A=
                  read if you really want to know what they are doing.</spa=
n></p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal">&nbsp=3B</p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal"><span style=3D"font-size:9.5pt=3B">=
How=0A=
                  does one manage the OCFS?</span></p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal"><span style=3D"font-size:9.5pt=3Bco=
lor:red=3B">You will not find=0A=
                  OCFS on the ODA. It uses ACFS for the cluster file=0A=
                  system as well as the database files.</span></p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal">&nbsp=3B</p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal"><span style=3D"font-size:9.5pt=3B">=
Can a=0A=
                  file system be mounted on both nodes=2C or just on one?=
=0A=
                  Is this automatic?</span></p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal"><span style=3D"font-size:9.5pt=3Bco=
lor:red=3B">Oakcli will take=0A=
                  care of this for you.</span></p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal">&nbsp=3B</p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal"><span style=3D"font-size:9.5pt=3B">=
Given a=0A=
                  complete backup (... which is a problem all of its=0A=
                  own...)=2C how does one restore a database?</span></p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal"><span style=3D"font-size:9.5pt=3Bco=
lor:red=3B">Use RMAN or=0A=
                  Enterprise Manager for this. There will be little=0A=
                  difference from a standard RAC database in how you=0A=
                  backup and restore a database.</span></p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal">&nbsp=3B</p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal"><span style=3D"font-size:9.5pt=3B">=
Don't=0A=
                  use centralised wallets with TDE=2C otherwise problems=0A=
                  will arise -- but what does that even mean?</span></p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal"><span style=3D"font-size:9.5pt=3Bco=
lor:red=3B">This isn't specific=0A=
                  to the ODA. There are a number of reasons to have=0A=
                  local wallets in RAC -- one of the most important=0A=
                  being that you can't have a local only autologin=0A=
                  wallet if it is shared with multiple nodes.</span></p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal">&nbsp=3B</p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal"><span style=3D"font-size:9.5pt=3B">=
You=0A=
                  will find little argument that the documentation for=0A=
                  ODA is mediocre at best. This is why a number of=0A=
                  training companies (including the one I teach for)=0A=
                  have developed their own content for the ODA. I think=0A=
                  your best course of action=2C though=2C is to get yoursel=
f=0A=
                  a couple of excellent books.</span></p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal"><span style=3D"font-size:9.5pt=3B">=
<a href=3D"http://www.amazon.com/Practical-Oracle-Database-Appliance-Curtis=
/dp/1430262656" target=3D"_blank">Practical=0A=
                    Oracle Database Appliance</a></span></p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal"><a href=3D"http://www.amazon.com/Or=
acle-Database-Appliance-Hands--Guide/dp/0071827447" target=3D"_blank">Oracl=
e=0A=
                  Database Appliance: A Hands-On Guide</a></p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal">&nbsp=3B</p>=0A=
            </div>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal"><span style=3D"font-size:9.5pt=3B">=
Seth=0A=
                  Miller</span></p>=0A=
            </div>=0A=
          </div>=0A=
          <div>=0A=
            <p class=3D"ecxMsoNormal">&nbsp=3B</p>=0A=
            <div>=0A=
              <p class=3D"ecxMsoNormal">On Fri=2C Jan 29=2C 2016 at 10:42 P=
M=2C De=0A=
                DBA &lt=3B<a href=3D"mailto:dedba@tpg.com.au" target=3D"_bl=
ank">dedba@tpg.com.au</a>&gt=3B=0A=
                wrote:</p>=0A=
              <blockquote style=3D"border:none=3Bborder-left:solid #CCCCCC =
1.0pt=3Bpadding:0in 0in 0in 6.0pt=3B">=0A=
                <p class=3D"ecxMsoNormal">&nbsp=3B</p>=0A=
                <div>=0A=
                  <p class=3D"ecxMsoNormal" style=3D"">I've=0A=
                    just read through that documentation=2C as I will=0A=
                    shortly get the responsibility for 2 ODA's. I would=0A=
                    not classify the 3 software manuals and 2 hw manuals=0A=
                    as good documentation. After reading all of it=2C I've=
=0A=
                    got more questions than what I started out with... <br>=
=0A=
                    <br>=0A=
                    The ODAs apparently are each set up as two=0A=
                    stand-alone servers with shared storage. I=0A=
                    understand that one needs to use oakcli to create=0A=
                    databases and that this tool hides pretty much all=0A=
                    functionality that we are used to through dbca etc.=0A=
                    But what does it do exactly? How does one manage the=0A=
                    OCFS? Can a file system be mounted on both nodes=2C or=
=0A=
                    just on one? Is this automatic? Given a complete=0A=
                    backup (... which is a problem all of its own...)=2C=0A=
                    how does one restore a database? Don't use=0A=
                    centralised wallets with TDE=2C otherwise problems=0A=
                    will arise -- but what does that even mean?=0A=
                    Questions... <br>=0A=
                    <br>=0A=
                    Pointers to more complete documentation/blogs/etc.=0A=
                    regarding managing and patching the ODA are very=0A=
                    welcome!<br>=0A=
                    <br>=0A=
                    Cheers=2C<br>=0A=
                    Tony </p>=0A=
                  <div>=0A=
                    <p class=3D"ecxMsoNormal">On 30/01/2016 6:38 am=2C Hans=
=0A=
                      Forbrich wrote:</p>=0A=
                  </div>=0A=
                  <blockquote style=3D"">=0A=
                    <div>=0A=
                      <p class=3D"ecxMsoNormal">Yes=2C lack of documentatio=
n=0A=
                        was a problem at one time.<br>=0A=
                        <br>=0A=
                        That has significantly improved.&nbsp=3B See <a hre=
f=3D"http://docs.oracle.com/en/engineered-systems/" target=3D"_blank">http:=
//docs.oracle.com/en/engineered-systems/</a><br>=0A=
                        <br>=0A=
                        /Hans<br>=0A=
                        <br>=0A=
                        On 29/01/2016 12:54 PM=2C Andrew Kerber wrote:</p>=
=0A=
                    </div>=0A=
                    <blockquote style=3D"">=0A=
                      <div>=0A=
                        <p class=3D"ecxMsoNormal">I have run into problem=
=0A=
                          with a lack of good documentation on its use.&nbs=
p=3B<br>=0A=
                          <br>=0A=
                          Sent from my iPad</p>=0A=
                      </div>=0A=
                      <div>=0A=
                        <p class=3D"ecxMsoNormal" style=3D""><br>=0A=
                          On Jan 29=2C 2016=2C at 1:49 PM=2C &lt=3B<a href=
=3D"mailto:Jay.Miller@tdameritrade.com" target=3D"_blank">Jay.Miller@tdamer=
itrade.com</a>&gt=3B=0A=
                          &lt=3B<a href=3D"mailto:Jay.Miller@tdameritrade.c=
om" target=3D"_blank">Jay.Miller@tdameritrade.com</a>&gt=3B=0A=
                          wrote:</p>=0A=
                      </div>=0A=
                      <blockquote style=3D"">=0A=
                        <div>=0A=
                          <div>=0A=
                            <p class=3D"ecxMsoNormal" style=3D"">Hi</p>=0A=
                            <p class=3D"ecxMsoNormal" style=3D"">&nbsp=3B</=
p>=0A=
                            <p class=3D"ecxMsoNormal" style=3D"">We=0A=
                              just attended an ODA presentation and it=0A=
                              looks very promising as a solution for our=0A=
                              non-prod testing environment as it would=0A=
                              allow us to clone multiple instances of=0A=
                              the gold copy test databases easily=0A=
                              (without needing to coordinate with other=0A=
                              departments as we do now) and apply=0A=
                              patches for those environments quickly and=0A=
                              easily as well.</p>=0A=
                            <p class=3D"ecxMsoNormal" style=3D"">&nbsp=3B</=
p>=0A=
                            <p class=3D"ecxMsoNormal" style=3D"">Any=0A=
                              real life pros or cons that anyone has=0A=
                              experienced with the appliance? We=92d keep=
=0A=
                              our production and performance testing=0A=
                              environments off it at least for now.</p>=0A=
                            <p class=3D"ecxMsoNormal" style=3D"">&nbsp=3B</=
p>=0A=
                            <p class=3D"ecxMsoNormal" style=3D"">&nbsp=3B</=
p>=0A=
                            <p class=3D"ecxMsoNormal" style=3D"">Jay=0A=
                              Miller</p>=0A=
                            <p class=3D"ecxMsoNormal" style=3D"">Sr.=0A=
                              Oracle DBA</p>=0A=
                            <p class=3D"ecxMsoNormal" style=3D"">201.369.83=
55</p>=0A=
                            <p class=3D"ecxMsoNormal" style=3D"">&nbsp=3B</=
p>=0A=
                          </div>=0A=
                        </div>=0A=
                      </blockquote>=0A=
                    </blockquote>=0A=
                    <p class=3D"ecxMsoNormal">&nbsp=3B</p>=0A=
                  </blockquote>=0A=
                  <p class=3D"ecxMsoNormal">&nbsp=3B</p>=0A=
                </div>=0A=
              </blockquote>=0A=
            </div>=0A=
            <p class=3D"ecxMsoNormal">&nbsp=3B</p>=0A=
          </div>=0A=
        </blockquote>=0A=
        <p class=3D"ecxMsoNormal">&nbsp=3B</p>=0A=
      </div>=0A=
    </blockquote>=0A=
    <br></div></div> 		 	   		  </div></body>
</html>=

--_c56f0b72-24f6-4257-95c8-2ddc8ff91225_--

--_21e24519-7462-48c8-8a74-3104856e8247_
Content-Type: image/jpeg
Content-Transfer-Encoding: base64
Content-ID: <part1.04000500.08020104@tpg.com.au>
Content-Disposition: inline; filename="ATT00001"

/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAoHBwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIf
IiEmKzcvJik0KSEiMEExNDk7Pj4+JS5ESUM8SDc9Pjv/2wBDAQoLCw4NDhwQEBw7KCIoOzs7Ozs7
Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozv/wAARCAARAFgDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwDp/D2n
ReMlu9S1ueWZ1uGiS1WQosCjpwO/vWhqPgvSbKwmurOW4sZ4UMiTrO3yEDPOTyKfqPhWK71CS600
3NjK/wDrZIJjGJD7j196qnwbM5UaheX17bg5aBrokN9R3rJRt01PYdZOXNGpyx/l/TsY1n5XiXVr
a51iCabGkiV44iQWIcjIA6561GH0e5ubb/hEYNQj1FbhQWO8Iq5+YPnjpXcW+kQQ+IV1GFDGq2Yg
VRwoUHOMVC+hp/wkK6nYF7SQjFwUOEm+q9z70chf1yF7K6VtFfT0aMzxVqI1C/i8Ox3i20JAfULj
ftEadkz6tVLTPEz6ZpGraX9pjvLrToWe0mDBvNi7E46le9b+m+HrKztr2G8t/tTXUxknaYBzL6fg
Kgu/DGlyz2sljYizkgfcXiQICpGCpHcH0p2lv1MoVaHL7Jq6X59+/l6FbSPB2lalpVtfX809/c3M
Ykedp25JGcDB4HtUWtaVZ6HcaBb2EbRI2pAtliS3ynqTTj4OkV3Om3V7Y2zMWWFLkhR9B2+lSXHh
KSbTIbae7u5LiO581JmuMsvGOvak1poi1VXtFJ1brXTtdP5aHXPwpI7DNeW2Tya89zfalouqaozT
MqiCULHCAfugZHPrXRJ4R1IOpbWNQKgjI+1nkflUl54TWe+ludNkurBpD+9MNwUWQ+uPX3pyvIjD
OlQuua7fXXT7tdfITw/otjIlwDoV7pgJXJuJsl8HOBycCitHQdDutLuJJLi9urneuAJpy4H4UU4r
Q5K9aftHyyv83+ptx9KcetFFWcz3I/X6U0ffWiikMl/5aD6Uh+830oooEOHemt0/GiiqBDu1R96K
KQRHpRRRSJe5/9k=

--_21e24519-7462-48c8-8a74-3104856e8247_--
--
http://www.freelists.org/webpage/oracle-l