RE: oracle-l Digest V13 #25
- From: Sherrie Kubis <Sherrie.Kubis@xxxxxxxxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 2 Feb 2016 12:51:47 +0000
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@xxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxx] ;
Sent: Tuesday, February 02, 2016 1:05 AM
To: oracle-l digest users <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxx>
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@xxxxxxxxx>
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@xxxxxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l
--
Michael Cunningham
------------------------------
From: "Zelli, Brian" <Brian.Zelli@xxxxxxxxxxxxxxx>
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@xxxxxxxxx>
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@xxxxxxxxxxxxxxx> 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@xxxxxxxxx>
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@xxxxxxxxx>
wrote:
ofcourse.
On 1 February 2016 at 17:09, Zelli, Brian
<Brian.Zelli@xxxxxxxxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
------------------------------
From: "Powell, Mark" <mark.powell2@xxxxxxx>
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@xxxxxxxxx>
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@xxxxxx>
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@xxxxxxxxxx>
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@xxxxxx] ;
Sent: Monday, February 01, 2016 3:12 PM
To: Nassyam Basha; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx] ;
Sendt: 29. januar 2016 10:43
Til: Lars Dohn
Cc: HYPERLINK "
mailto:oracle-l@xxxxxxxxxxxxx"oracle-l@xxxxxxxxxxxxx
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@xxxxxx" ;
\nLDO@xxxxxx> 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 :
1) discovering wrong targets
If you have an instance with some kind of dataguard standby attached, em will
find the standby, not the main instance.
2) 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@xxxxxxxxxxxxx"oracle-l-bounce@xxxxxxxxxxxxx ;
[
mailto:HYPERLINK ;
"
mailto:oracle-l-bounce@xxxxxxxxxxxxx"oracle-l-bounce@xxxxxxxxxxxxx] PÃ¥ vegne ;
af Nassyam Basha
Sendt: 14. januar 2016 03:03
Til: HYPERLINK "
mailto:oracle.unknowns@xxxxxxxxx"oracle.unknowns@xxxxxxxxx
Cc: HYPERLINK "
mailto:oracle-l@xxxxxxxxxxxxx"oracle-l@xxxxxxxxxxxxx
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.
1) discovering wrong targets.
2) 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@xxxxxxxxx"oracle.unknowns@xxxxxxxxx> 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
--
//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@xxxxxxxx>
Subject: RE: compress dbf backup files
Date: Mon, 1 Feb 2016 18:08:56 -0500
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@xxxxxxxxxxxxx [
mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Mladen Gogala
Sent: Monday, February 01, 2016 4:03 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx>
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@xxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Mladen Gogala
*Sent:* Monday, February 01, 2016 4:03 PM
*To:* oracle-l@xxxxxxxxxxxxx
*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@xxxxxxxxxx>
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@xxxxxxxxxx"pete.sharman@xxxxxxxxxx ;
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@xxxxxxxxxx] ;
Sent: Monday, February 1, 2016 10:32 AM
To: Seth Miller <sethmiller.sm@xxxxxxxxx>
Cc: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxx"dedba@xxxxxxxxxx> 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@xxxxxxxxxxxxxxxx"Jay.Miller@xxxxxxxxxxxxxxxx> <HYPERLINK
"
mailto:Jay.Miller@xxxxxxxxxxxxxxxx"Jay.Miller@xxxxxxxxxxxxxxxx> 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
******************************
��i��0���zX���+��n��{�+i�^
Other related posts:
- » RE: oracle-l Digest V13 #25 - Sherrie Kubis