RE: oracle-l Digest V13 #25
Date: Tue, 2 Feb 2016 12:51:47 +0000
Message-ID: <BY1PR09MB0535E49BD99561DBDC160B3289DF0_at_BY1PR09MB0535.namprd09.prod.outlook.com>
Thanks for the response Tom.
Unfortunately, I looked at SE when we moved to a lower-cost platform at this last cost cutting step, but it's not possible. I feel like I cut as much as possible, but at contract renewal the final negotiated figures were not enough.
I love Oracle, it's a solid database and great to work with. It's reliable. The move to another database platform is a huge endeavor. So huge. And I rely on MOS and all of its benefits--troubleshooting, knowledgebase, community, patching. Oracle has been my career for more than 20 years.
My input into this management decision is to define the pros, cons, risks, and impacts of dropping support at the next renewal. My next input is to prototype a reduced-cost database platform and present the same analysis, along with a thorough feasibility study. Once they make their decision, there must be a plan and project on how to get there.
Right now I'm at the research phase and beginning by asking other professionals of their experiences. This list server has many years of knowledge and experience, and I appreciate all of the responses.
Sherrie Kubis
Sr. Oracle DBA
Information Technology Bureau
Southwest Florida Water Management District 2379 Broad Street
Brooksville, FL 34604-6899
352.796.7211 x4033
sherrie.kubis_at_swfwmd.state.fl.us
Please take a moment to answer a few questions and let us how we’re doing.
IMPORTANT NOTICE
E-mails made or received in conjunction with the official business of the District are public records. All e-mails sent to and from this address are automatically archived. For more information regarding the State of Florida public records laws, please visit www.myflorida.com.
-----Original Message-----
From: FreeLists Mailing List Manager [mailto:ecartis_at_freelists.org]
Sent: Tuesday, February 02, 2016 1:05 AM
To: oracle-l digest users <oracle-l_at_freelists.org>
Subject: oracle-l Digest V13 #25
oracle-l Digest Mon, 01 Feb 2016 Volume: 13 Issue: 025
In This Issue:
Re: oracle-l Digest V13 #15 compress dbf backup files Re: compress dbf backup files Re: compress dbf backup files RE: Is legal to copy files to xe to get impdp working, in th Re: compress dbf backup files SV: OEM Cloud Control 13c - Grant access to users RE: SV: OEM Cloud Control 13c - Grant access to users RE: compress dbf backup files Re: compress dbf backup files RE: Anyone with experience with the Oracle Data Appliance/OD ----------------------------------------------------------------------
Date: Mon, 1 Feb 2016 10:00:48 +0000
Subject: Re: oracle-l Digest V13 #15
From: Tom Dale <tom.dale_at_fivium.co.uk>
I agree with Michael,
A move to Oracle Standard One, or Standard 2, can save a lot of money, and be full supported by Oracle.
The work in moving to another vendor, is normally greatly underestimated.
I have moved many databases to Oracle Standard edition, its a fantastic product for the money.
Tom
On Fri, Jan 29, 2016 at 4:40 PM, Michael Cunningham < napacunningham_at_gmail.com> wrote:
> I've had to cut costs in the past and since we were not using features
> only available in Enterprise Edition we were able to switch all
> DEV/QA/User Acceptance, etc to Standard Edition One. At the time it
> was $5,000 per socket (list price) and saved us a lot of money. In our
> case we never found a situation where we had problems in non Enterprise Edition databases.
>
> The worst problem was that new servers could not be purchased with the
> same number of cores we had on the old boxes, so we had to juggle
> things around to avoid breaking the licensing.
>
> Michael
>
> On Thu, Jan 28, 2016 at 5:18 PM, Jack van Zanen <jack_at_vanzanen.com> wrote:
>
>> I think I would rather suggest to move to a cheaper db platform than
>> to suggest dropping support for any current one.
>> Investigate SQL Server, postgress, mysql and whatever other flavour
>> has your fancy
>>
>> If you drop support and something does happen that requires oracle
>> support they can and most likely will charge you whatever you saved
>> over the time you did not have support.
>> They will get their money back I am sure, or else we would all be
>> telling our boss to ditch support until we need it
>>
>>
>>
>>
>>
>>
>>
>> Jack van Zanen
>>
>> -------------------------
>> This e-mail and any attachments may contain confidential material for
>> the sole use of the intended recipient. If you are not the intended
>> recipient, please be aware that any disclosure, copying, distribution
>> or use of this e-mail or any attachment is prohibited. If you have
>> received this e-mail in error, please contact the sender and delete all copies.
>> Thank you for your cooperation
>>
>> On Sat, Jan 23, 2016 at 4:03 AM, John Piwowar <jpiwowar_at_gmail.com> wrote:
>>
>>> I concur with Rich on the patching angle. FWIW, I usually hear
>>> about 3rd-party support in the context of older "legacy" systems
>>> where the amount of patching and updates required is minimal. Not a
>>> licensing expert, but I'd expect things to get dicey really fast in
>>> an current-release environment where there's no patch access. You'd
>>> also be stuck hoping that Oracle doesn't take your third party
>>> support entity to court (e.g. in Rimini's case:
>>>
>>> http://www.informationweek.com/software/enterprise-applications/rimi
>>> ni-street-oracle-spar-over-lawsuit-outcome/d/d-id/1322845
>>> ;-)
>>>
>>> Dropping maintenance and support seems like a huge pile of risk to
>>> take on for production systems running a recent release....
>>>
>>> On Fri, Jan 22, 2016 at 8:15 AM, Rich J
>>> <rjoralist3_at_society.servebeer.com> wrote:
>>> > On 2016/01/22 08:30, Sherrie Kubis wrote:
>>>
>>> > While I haven't seriously looked at third-party support, the one
>>> critical
>>> > piece that seems to be missing is access to software patches.
>>> > Those
>>> have
>>> > unfortunately proven to be crucial for me to be able to keep our
>>> Production
>>> > DBs afloat, and I don't even generally apply CPUs/PSUs. It also
>>> impacts
>>> > "free" Oracle software like EM12c, where the upgrade to 12.1.0.5
>>> requires
>>> > patch 11061801.
>>> --
>>> http://www.freelists.org/webpage/oracle-l
>>>
>>>
>>>
>>
>
>
> --
> Michael Cunningham
>
From: "Zelli, Brian" <Brian.Zelli_at_RoswellPark.org>
Subject: compress dbf backup files
Date: Mon, 1 Feb 2016 17:09:20 +0000
I have copies of dbf files sitting on a server. Management doesn't want me deleting them. So to garnish space, can I compress these? They are only copies of the existing readonly dbffiles...
Brian
This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
From: Howard Latham <howard.latham_at_gmail.com>
Date: Mon, 1 Feb 2016 18:28:05 +0000
Subject: Re: compress dbf backup files
ofcourse.
On 1 February 2016 at 17:09, Zelli, Brian <Brian.Zelli_at_roswellpark.org> wrote:
> I have copies of dbf files sitting on a server. Management doesn’t
> want me deleting them. So to garnish space, can I compress these?
> They are only copies of the existing readonly dbffiles…
>
>
>
>
>
> Brian
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee
> or agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately
> by e-mail and delete this email message from your computer. Thank you.
--
Howard A. Latham
Date: Mon, 1 Feb 2016 12:51:30 -0600
Subject: Re: compress dbf backup files
From: Seth Miller <sethmiller.sm_at_gmail.com>
Brian,
They won't be readable while they are compressed but yes, standard compression utilities on data files work just fine.
If you want to make the data much smaller (potentially), you might want to consider compressing the data in the database using basic or HCC. You will get higher compression of the data and you won't have to worry about having to uncompress the data files before using them again.
Seth Miller
On Mon, Feb 1, 2016 at 12:28 PM, Howard Latham <howard.latham_at_gmail.com> wrote:
> ofcourse.
>
> On 1 February 2016 at 17:09, Zelli, Brian
> <Brian.Zelli_at_roswellpark.org>
> wrote:
> > I have copies of dbf files sitting on a server. Management
> > doesn’t want
> me
> > deleting them. So to garnish space, can I compress these? They are
> > only copies of the existing readonly dbffiles…
> >
> >
> >
> >
> >
> > Brian
> >
> >
> >
> >
> > This email message may contain legally privileged and/or
> > confidential information. If you are not the intended recipient(s),
> > or the employee or agent responsible for the delivery of this
> > message to the intended recipient(s), you are hereby notified that
> > any disclosure, copying, distribution, or use of this email message
> > is prohibited. If you have received this message in error, please
> > notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
>
>
>
> --
> Howard A. Latham
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
From: "Powell, Mark" <mark.powell2_at_hpe.com> Subject: RE: Is legal to copy files to xe to get impdp working, in this two Date: Mon, 1 Feb 2016 18:51:44 +0000
b‹¢z-²Öz)ò¢êé¢Ëm…«r¢ë¬yÛa{]`{]¦ëb–+r¶‰š‘ëayìi¢»_ŠW°†'!‹¥u·šê®Š·¦z{m¡ìi¢»_®‰š†(!z»Þ®È¨žÚ–Œ ®÷«²*'ü&§Ê‹œ¢wâ®kajܨº)ßiË]‰×h¶¬üZè›ú+iÉ^þ_Û¢éÜ{÷ëyéb²Ûÿ¢¸ÿ™¨¥¶è§%{ùÿn‹§qïß祊ËlþŠàüéÁz¥|çɹ©Âj¹h±²zÃÚrœ¡'§·ôẻ k/Éj{š¯-¼ÿm5ëŸ÷ðó£ó‘ jǬüˆ(¶Ü(zºè®Ì!z{kÊ)ඈ¦¦ŠíºÈ§‚)©v—ë¢mvrÚ5Ö ^ëŒHþk.éè·ö$ŠxŸ,Ëôájy2¢ïÿ!Ê)Éø¥zÊ'—+h¶¼šØŠä×÷ë¢mu‚ËZÖ«t/ÿ¢¶œ•ì^ýªiþŠÚrWÿ¦º ¹Ëÿ×_öÿOìz»Þ¯úÝnkÿÆivýúè›] ²Ö§uªÝ ÿè§%{ÿjšÿ¢¶œ•ï鮇nrßõ×ýÿÓû ®÷«þŠÚrŠÞÿ:'z)ß¡©ÝŠÜ(®GþØ^zºè®Ì±@Èÿ}zÛ¯è¥êÚ¶*'éÞ«^tä@± ®º+ß^¶èä@ÿ}zۯ㡷hzÉèµìb²Ó‘ýýÓÎÿq©ç¢ÚÞ¶¸ž½èèn)ߢ¹š¶*'9ÿÓ®uÛöý&ü0LKðÀLÔ0ÿÿ–)Þß}º9ÿÓ®uÛöý&ü0LKðÀLÔ0ÿÿ–)Þãžu9ÿÓ®uÛö–)ÞÕ$ ýì^qÖæ³ùžµ§Zµ¯î¶)ÿ–†þËr•ë!yëlü ×[šÏæzÖjÖÿºØ¥þZwû-ÊW¬…ç³ñÿÄE‘jÙbíÿ9ÿß^´÷÷«®Šå¡§bž â•ï乩mz¿ñ²_ß®‰ŸŠW¬ÊË^™Ø«yËh¯/Âÿú+iÉ^ÅïÚ¦Ÿè§%{úk¡Ûœ·ýuÿoôþÇ«½êÿÖæ³üf—ül—ó‘ý:ç]ÿjßÒa/ÃÄÿ0DÀ ÀýDÈ/ÿåŠw¶ßÞÎDôëvý«eŠwµ
Subject: Re: compress dbf backup files
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 1 Feb 2016 16:02:48 -0500
On 02/01/2016 12:09 PM, Zelli, Brian wrote:
>
> I have copies of dbf files sitting on a server. Management doesn’t
> want me deleting them. So to garnish space, can I compress these?
> They are only copies of the existing readonly dbffiles…
>
> Brian
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee
> or agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately
> by e-mail and delete this email message from your computer. Thank you.
Hi Brian,
How old are those files? What does your management expect from having them? What is your company's backup strategy? Do you have an enterprise backup suite? How frequently do you take backup and where do you store it? How do you take backups?
Regards
--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
From: Lars Dohn <LDO_at_dst.dk>
Subject: SV: OEM Cloud Control 13c - Grant access to users
Date: Mon, 1 Feb 2016 21:12:02 +0000
#Z²Ìš›ò¢éÝ¢ëa£
h‚¶§µ§ zË-¢ë ®Ë(¶²q©ìyëaz—«~Šæjw ¥¨ ü
,ÊÉšŸ÷%‰É(žØ^u«Zm« Ê‹ÿÿùe綈"½æœqë,¶Šÿ
(±ïΧ%x6i¶¬{ÿÿý6«ëlzÛ©ÿÿÿÙ¢ž+-«h§ zËÿü(^rOÿºÇ«©žÿÿî±ïà©í¶‹ •ç-yßÿi×ÿV'°«Zm« =êߢ¹šÇ®+â•è º.§ÿÜ¢{bžçÿ
‹aŠÇèëÞ¯+¬z·èëÞ¯'Zµ¦Ú±ïÈ–) ŠÖ§vz+ÿ!Ƨr‰í®‰ZqǬ²Ú jÖ›jǬ~Šëy§ÿ¢yrºÇ«³ÿÿ"wžvÚ ¢Øb²‰þëGZµ¦Ú±ëÿÿÿÑz«vÂÚ®Àè†ÿÿÿÿÿÿÿÿÿËj»¢Î§%zÊ^r&¥ŠËRµ«b²Øœ°7§™ªäIèëÿøuíuÛ]4+ÿÛzxZ¾ÿ¶ÿ5«,É©jÈZþf¢–Úÿ«,É©›jÈZþ šŠ_Ü¢oÒzwmÿoÿ©îj½´×tÿÓŠ_Ëj»¢Âsú+iÉ^þ_ß祊ËlþŠàiÞýÿ8C–‹
‰í®‰uÝËì×gÿ ée ¶«³ÿõýجr‹Þ®)àº'‚Ö«ël!ü¨º¯y©âžËZÇ°ŠØl¢g¤Šwh}Öj
šÛ-jw[É«miÈ^w÷¦Â)e~)ݶ¬µ©Ýo(§²Ö§qëºÙèµ×¬Š·üŠ{aŠÈZ²ÚyÊ'~(.çfj{š–\›É©mz¸§‚Ø^uëZŠ[ÿœ¶\ÿ§ŠÚâyÛhv+ ¢÷«¦¸¦j¼jÖ›jǬIêïz¶§v+pŠYi®‹âu묶¬µ©Ýo'Zµ¦Ú±ë zÖ¢–Ïá¶ÚlÿÿÜ¢i®ž+rþŠÚrWÿr‰¿™ë,j ¿×~¶Û_týë
Date: Mon, 1 Feb 2016 13:47:35 -0800 (PST) From: Courtney Llamas <courtney.llamas_at_oracle.com> Subject: RE: SV: OEM Cloud Control 13c - Grant access to users
You could always create a role with these permissions  and select a group of databases that it applies to (2nd portion of the privileges screen – Target Privileges)… Â
Â
From: Lars Dohn [mailto:LDO_at_dst.dk] Sent: Monday, February 01, 2016 3:12 PM To: Nassyam Basha; oracle-l_at_freelists.org Subject: SV: OEM Cloud Control 13c - Grant access to users
Â
Hi Nassyam.
Â
I found out how to grant access to users so they can see the performance page :
Â
As sysman, click on the database you’ll need to give access too.
Â
Choose "Oracle Database" -> "Target setup" -> "Administrator access".
Check "<username>", use "grant to selected", add "View Database Performance Privilege Group", continue.
Â
Do this for every user for every database.
Â
I like it and hate it.
I can control access to databases for read-only users J
I need to do this on +60 databases. L
Â
Â
Regards
Lars Dohn
Â
Lars Dohn
Oracle specialist
Â
Statistics Denmark
Sejrøgade 11
2100 København Ø
Â
Fra: Nassyam Basha [mailto:nassyambasha_at_gmail.com]
Sendt: 29. januar 2016 10:43
Til: Lars Dohn
Cc: HYPERLINK "mailto:oracle-l_at_freelists.org"oracle-l_at_freelists.org
Emne: Re: OEM Cloud Control 13c vs 12c?
Â
Hello Lars,
Â
>Â 1) discovering wrong targets
If you have an instance with some kind of dataguard standby attached, em will find the standby instances but not desired.
Again this has to be configured manually by altering the details.Â
Â
Exactly, when i tried to discover primary databases Server and it will provide us the standby databases details.Â
https://community.oracle.com/message/13622190?et=watches.email.thread#13622190
Â
Few other issues:
https://community.oracle.com/message/13622141?et=watches.email.thread#13622141
https://community.oracle.com/message/13621696#13621696
Â
Â
Â
On Fri, Jan 29, 2016 at 2:38 PM, Lars Dohn <HYPERLINK "mailto:LDO_at_dst.dk" \nLDO_at_dst.dk> wrote:
Hi.
I'm running 12cr5 and em13c (different servers). I have both 12c and 13c agents running on productions servers. (Make sure they have different agent_base, or you'll be in deep...).
I'm seing the same "problems" as Nassyam Basha :
- discovering wrong targets If you have an instance with some kind of dataguard standby attached, em will find the standby, not the main instance.
- unable to view/open database target sysman works, but "read-only" em users can't connect to the monitored databases.
Have SR's on both...
Lars Dohn
Statistics Denmark
-----Oprindelig meddelelse-----
Fra: HYPERLINK "mailto:oracle-l-bounce_at_freelists.org"oracle-l-bounce_at_freelists.org [mailto:HYPERLINK "mailto:oracle-l-bounce_at_freelists.org"oracle-l-bounce_at_freelists.org] PÃ¥ vegne af Nassyam Basha
Sendt: 14. januar 2016 03:03
Til: HYPERLINK "mailto:oracle.unknowns_at_gmail.com"oracle.unknowns_at_gmail.com
Cc: HYPERLINK "mailto:oracle-l_at_freelists.org"oracle-l_at_freelists.org
Emne: Re: OEM Cloud Control 13c vs 12c?
Hello Chen,
I have installed EM 13c on VM and also EM12c earlier. I have not seen any issue with EM12c but for EM13c in my case until installation no issues seen but later i stuck into many things. I worked on 3 tasks and failed to do all of them. Later submitted thread at MOSC EM and submitted much information and few changes but no luck. Finally Oracle confirmed as new bugs.
- discovering wrong targets.
- unable to view/open database target(ADF_FACES PRR, #1,3,6) So on. I can share links later in few minutes.
Again for few folks it is working well, so i cannot say based on my environment not a good choice to go for 13c. I would say go for ride first if permits. The graphical view is amazing and the look wise same as HYPERLINK "http://cloud.oracle.com" \ncloud.oracle.com access dashboard. Very fast as well.
All the best.
Sent from my iPhone
> On 14-Jan-2016, at 6:42 AM, Chen Zhou <HYPERLINK "mailto:oracle.unknowns_at_gmail.com"oracle.unknowns_at_gmail.com> wrote:
>
> Hi,
> Has anyone tried Cloud Control 13c yet?
> We had been planning to install 12c. The server finally is available now, but 13c is out. I wonder if we should just go ahead to install CC 13c instead.
> The server we finally got is on VM, even though we requested for physical server.
> Does anyone have a success story with OEM on VM? That will make us feel better to go ahead with it.
> Thank you,
> Chen
--
http://www.freelists.org/webpage/oracle-l
Â
--
Nassyam Basha.
Oracle Database Consultant| HYPERLINK "http://www.pythian.com/" \nPythian HYPERLINK "https://apex.oracle.com/pls/apex/f?p297:4:::NO:4:P4_ID:13140" \n ACED Profile
HYPERLINK "http://education.oracle.com/education/otn/NassyamBasha.htm" \nOracle 11g Certified Master
Co-Author: HYPERLINK "http://www.amazon.in/Oracle-Guard-11gR2-Administration-Beginners/dp/1849687900" \nOracle Data Guard 11gR2
Co-founder of HYPERLINK "http://www.oraworld-team.com" \nOraworld-team
HYPERLINK "https://www.facebook.com/nassyambasha" \n Facebook HYPERLINK "https://twitter.com/oracle_ckpt" \nTwitter HYPERLINK "https://in.linkedin.com/in/nassyambasha" \nLinkedIn HYPERLINK "https://plus.google.com/+NassyamBasha" \nGoogle + HYPERLINK "http://www.oracle-ckpt.com/" \nCKPT Blog            Â
      Â
From: "Mark W. Farnham" <mwf_at_rsiz.com>
Subject: RE: compress dbf backup files
Date: Mon, 1 Feb 2016 18:08:56 -0500
A few things:
- Mladen's questions are directly on point.
- "They are the only copies of the existing readonly dbffiles."
- Farnham's Law: "Don't trust your career to a single piece of spinning rust or ribbon rust." (Ribbon rust is a tape. This should probably be updated to "single piece of media" but spinning rust and ribbon rust are helpful images to remember how fragile your career might be if you violate Farnham's Law.)
- I hope you mount these for a few minutes and read something from them every time you patch anything in the entire stack. Otherwise they might become the only copies of these files that run on a machine/operating system you no longer have in close enough detail. (Did I ever tell you the one about 9-track tapes and the changing hardware specifications over time of maximum drift adjustments where the new "better" tape drive simply could not be adjusted to read *some* of the tapes that had been written on the "gone" drives with a larger than average drift. Sigh. It wasn't funny at the time either..
- If space and compression is an issue then I suggest that in addition
to possibly reloading and compressing as per the methods Seth mentioned
earlier in the thread you use a reasonable protocol for tablespaces that
have become read only whether or not you leave them unmounted most of the
time. Among the features of such a protocol:
- If the tablespace to become unmounted has more than trivial free space, copy everything in the tablespace into something just big enough as compressed as you plan to keep it. Partition exchange methods might be helpful.
- Consider using direct load so you don't have any delayed cleanout issues reading things much later.
- Consider making the destination a less expensive "class" of storage than your active database files is on.
- Make another copy somewhere else that will survive independently of the campus this file is on.
There is probably more.
mwf
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Mladen Gogala
Sent: Monday, February 01, 2016 4:03 PM
To: oracle-l_at_freelists.org
Subject: Re: compress dbf backup files
On 02/01/2016 12:09 PM, Zelli, Brian wrote:
I have copies of dbf files sitting on a server. Management doesn't want me deleting them. So to garnish space, can I compress these? They are only copies of the existing readonly dbffiles.
Brian
This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
Hi Brian,
How old are those files? What does your management expect from having them?
What is your company's backup strategy? Do you have an enterprise backup
suite? How frequently do you take backup and where do you store it? How do
you take backups?
Regards
--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
Date: Mon, 1 Feb 2016 17:17:25 -0600
Subject: Re: compress dbf backup files
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Ditto on Mark's comments. Though I have used 9 track tapes, I did not run
his particular problem. I recommend two copies of the data files, and an
export of them also. Just to be safe.
On Mon, Feb 1, 2016 at 5:08 PM, Mark W. Farnham <mwf_at_rsiz.com> wrote:
> A few things:
>
>
>
> 1) Mladen’s questions are directly on point.
>
> 2) “They are the only copies of the existing readonly dbffiles…â€
>
> a. Farnham’s Law: “Don’t trust your career to a single piece of
> spinning rust or ribbon rust.†(Ribbon rust is a tape. This should probably
> be updated to “single piece of media†but spinning rust and ribbon rust are
> helpful images to remember how fragile your career might be if you violate
> Farnham’s Law.)
>
> b. I hope you mount these for a few minutes and read something from
> them every time you patch anything in the entire stack. Otherwise they
> might become the only copies of these files that run on a machine/operating
> system you no longer have in close enough detail. (Did I ever tell you the
> one about 9-track tapes and the changing hardware specifications over time
> of maximum drift adjustments where the new “better†tape drive simply could
> not be adjusted to read **some** of the tapes that had been written on
> the “gone†drives with a larger than average drift. Sigh. It wasn’t funny
> at the time either….
>
> 3) If space and compression is an issue then I suggest that in
> addition to possibly reloading and compressing as per the methods Seth
> mentioned earlier in the thread you use a reasonable protocol for
> tablespaces that have become read only whether or not you leave them
> unmounted most of the time. Among the features of such a protocol:
>
> a. If the tablespace to become unmounted has more than trivial free
> space, copy everything in the tablespace into something just big enough as
> compressed as you plan to keep it. Partition exchange methods might be
> helpful.
>
> b. Consider using direct load so you don’t have any delayed cleanout
> issues reading things much later.
>
> c. Consider making the destination a less expensive “class†of
> storage than your active database files is on.
>
> d. Make another copy somewhere else that will survive independently of
> the campus this file is on.
>
>
>
> There is probably more.
>
>
>
> mwf
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Mladen Gogala
> *Sent:* Monday, February 01, 2016 4:03 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Re: compress dbf backup files
>
>
>
> On 02/01/2016 12:09 PM, Zelli, Brian wrote:
>
> I have copies of dbf files sitting on a server. Management doesn’t want
> me deleting them. So to garnish space, can I compress these? They are
> only copies of the existing readonly dbffiles…
>
>
>
>
>
> Brian
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
>
>
> Hi Brian,
> How old are those files? What does your management expect from having
> them? What is your company's backup strategy? Do you have an enterprise
> backup suite? How frequently do you take backup and where do you store it?
> How do you take backups?
> Regards
>
> --
>
> Mladen Gogala
>
> Oracle DBA
>
> Tel: (347) 321-1217
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Date: Mon, 1 Feb 2016 18:45:18 -0800 (PST) From: Peter Sharman <pete.sharman_at_oracle.com> Subject: RE: Anyone with experience with the Oracle Data Appliance/ODA?
Tony
Â
I don’t think I saw anything about database versions in the thread, so there are a couple of other options you could use depending on the version:
Â
·        If the DB is 12c, there is snapshotting capability built into the database itself
·        From DB 10g onwards you could look at using Enterprise Manager’s Snap Clone functionality which uses copy on write technology to build thin clones, optionally including masking as well. This may make it easier for you to do the snapshotting as its built into the product, which makes it less error prone than a manual snapshotting process.
Â
Let me know if you need any more details on that.
Â
Pete
Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA
Phone: HYPERLINK "tel:+61262924095"+61262924095 | | Mobile: +61414443449 Email: HYPERLINK "mailto:pete.sharman_at_oracle.com"pete.sharman_at_oracle.com Twitter: @SharmanPete LinkedIn: au.linkedin.com/in/petesharman Website: petewhodidnottweet.com
 _____ Â
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
Â
"Oh no, it's not, it's much harder than that!"
Bruce Pihlamae, long term Oracle DBA
 _____ Â
Â
From: De DBA [mailto:dedba_at_tpg.com.au] Sent: Monday, February 1, 2016 10:32 AM To: Seth Miller <sethmiller.sm_at_gmail.com> Cc: Oracle Discussion List <oracle-l_at_freelists.org> Subject: Re: Anyone with experience with the Oracle Data Appliance/ODA?
Â
Seth,
Thanks for that. I haven't got access to the systems yet, just reading up and preparing for the shock..
You will not find OCFS on the ODA. It uses ACFS for the cluster file system as well as the database files.
Â
Ah, yes, of course, it's on ASM... I understand that oakcli will create & manage fs automatically, but I'm not going to have RAC. One node is supposed to be production, whereas the other node will run dev, test and UAT. I will need to refresh the dev & test databases from production, and wonder whether I can create a snapshot, do the masking etc. and then mount the copy on the other node where it will then be used as the gold copy for the refreshes.
get yourself a couple of excellent books.
HYPERLINK "http://www.amazon.com/Practical-Oracle-Database-Appliance-Curtis/dp/1430262656"Practical Oracle Database Appliance
HYPERLINK "http://www.amazon.com/Oracle-Database-Appliance-Hands--Guide/dp/0071827447"Oracle Database Appliance: A Hands-On Guide
I did look at the first one, which has some famous names amongst the authors. One of the reviews that I saw mentions that it is somewhat dated? Is it still worthwhile getting even if you work with the latest hard/software?
Cheers,
Tony
On 31/01/2016 2:45 pm, Seth Miller wrote:
Tony,
Â
The ODAs apparently are each set up as two stand-alone servers with shared storage. I understand that one needs to use oakcli to create databases and that this tool hides pretty much all functionality that we are used to through dbca etc.
Yes, oakcli is the magic behind ODA but it does not preclude you from using DBCA. If you need to create a database that does not fall into one of the oakcli templates, feel free to use DBCA or any other classic method.
Â
But what does it do exactly?
Oakcli is nothing more than a bunch of very well written perl and shell scripts that wrap the classic tools included with the Oracle database software. They are easy to find and read if you really want to know what they are doing.
Â
How does one manage the OCFS?
You will not find OCFS on the ODA. It uses ACFS for the cluster file system as well as the database files.
Â
Can a file system be mounted on both nodes, or just on one? Is this automatic?
Oakcli will take care of this for you.
Â
Given a complete backup (... which is a problem all of its own...), how does one restore a database?
Use RMAN or Enterprise Manager for this. There will be little difference from a standard RAC database in how you backup and restore a database.
Â
Don't use centralised wallets with TDE, otherwise problems will arise -- but what does that even mean?
This isn't specific to the ODA. There are a number of reasons to have local wallets in RAC -- one of the most important being that you can't have a local only autologin wallet if it is shared with multiple nodes.
Â
You will find little argument that the documentation for ODA is mediocre at best. This is why a number of training companies (including the one I teach for) have developed their own content for the ODA. I think your best course of action, though, is to get yourself a couple of excellent books.
HYPERLINK "http://www.amazon.com/Practical-Oracle-Database-Appliance-Curtis/dp/1430262656"Practical Oracle Database Appliance
HYPERLINK "http://www.amazon.com/Oracle-Database-Appliance-Hands--Guide/dp/0071827447"Oracle Database Appliance: A Hands-On Guide
Â
Seth Miller
Â
On Fri, Jan 29, 2016 at 10:42 PM, De DBA <HYPERLINK "mailto:dedba_at_tpg.com.au"dedba_at_tpg.com.au> wrote:
Â
I've just read through that documentation, as I will shortly get the responsibility for 2 ODA's. I would not classify the 3 software manuals and 2 hw manuals as good documentation. After reading all of it, I've got more questions than what I started out with...
The ODAs apparently are each set up as two stand-alone servers with shared storage. I understand that one needs to use oakcli to create databases and that this tool hides pretty much all functionality that we are used to through dbca etc. But what does it do exactly? How does one manage the OCFS? Can a file system be mounted on both nodes, or just on one? Is this automatic? Given a complete backup (... which is a problem all of its own...), how does one restore a database? Don't use centralised wallets with TDE, otherwise problems will arise -- but what does that even mean? Questions...
Pointers to more complete documentation/blogs/etc. regarding managing and patching the ODA are very welcome!
Cheers,
Tony
On 30/01/2016 6:38 am, Hans Forbrich wrote:
Yes, lack of documentation was a problem at one time.
That has significantly improved. See http://docs.oracle.com/en/engineered-systems/
/Hans
On 29/01/2016 12:54 PM, Andrew Kerber wrote:
I have run into problem with a lack of good documentation on its use.Â
Sent from my iPad
On Jan 29, 2016, at 1:49 PM, <HYPERLINK "mailto:Jay.Miller_at_tdameritrade.com"Jay.Miller_at_tdameritrade.com> <HYPERLINK "mailto:Jay.Miller_at_tdameritrade.com"Jay.Miller_at_tdameritrade.com> wrote:
Hi
Â
We just attended an ODA presentation and it looks very promising as a solution for our non-prod testing environment as it would allow us to clone multiple instances of the gold copy test databases easily (without needing to coordinate with other departments as we do now) and apply patches for those environments quickly and easily as well.
Â
Any real life pros or cons that anyone has experienced with the appliance? We’d keep our production and performance testing environments off it at least for now.
Â
Â
Jay Miller
Sr. Oracle DBA
201.369.8355
Â
Â
Â
Â
Â
End of oracle-l Digest V13 #25
i0zX+ n{+i^ Received on Tue Feb 02 2016 - 13:51:47 CET