Restricting “root” access to database
Today’s first topic is about access restriction. Bazlur asked on OTN forum, if he can restrict root users’ access to database. He’s the vendor (owner of the database) who doesn’t want the customer (owner of the os) to connect his database. (It seems familiar to me:))
The result comes with Oracle Database Vault with no other option.

Restore Only One Tablespace From a Cold Backup to Another Database?
This topic is about partial restore of a database backup. It’s not possible to restore “just” 1 tablespace from a full RMAN backup, but if you have time and space issues and you need just 1 tablespace, you can restore just SYSTEM, SYSAUX, UNDO + a particular TS. Metalink doc 102786.1 (Partial Restore Of A Database) describes the steps clearly for this case. The “purpose” part of this document also describes a possible scenario:
“The purpose of this article is to show how to partially restore a database backup. When you've accidentally dropped some objects or deleted rows from a table you can restore a backup of that database as a copy. Using the archivelog files you can rollforward until a time just before the drop or delete. After the rollforward you can export the data from that copy of the database. That export can be used to import the data into the live database. When the database is very large and you're only after a few objects it might not make sense to restore the full backup.”


Data vs. Information
Here comes an an “academical” discussion about the difference between data and information. I’ve gone through this a year ago in my post graduate class. It’s just a theoretical concept but i think it’s important to know the difference and use these words in the correct way.
What they said:
“Data is what you find in one particular column. What you call "record" (which Chris Date would call "tuple") IS information, because in one row of a table you create information by relating data (that's why it's called "relational"). When in table EMP you say that King is President and earns a miserable 5000 (not even 7 times more than the lowest salary - this guy should be locked up), that's information. King, President and 5000 mean nothing by themselves and are just data. Data isn't information, but two related pieces of data are.”
“In the IT field when we talk about data we generally mean what in common usage might be better understood as raw data. Some data might convey information, but often the data needs to be organized and filtered before it can be considered useful information. Placing raw data into a properly constructed set of tables would help identify information. Joins and the application of business logic to the table columns would result in more information being available.”

Oracle to SQL Server
This discussion is about connection from Oracle to SQL server on hp-ux box.
Dick Goulet describes two method.
“Method 1 would be to acquire a copy of the Transparent Gateway to SQL*Server from Oracle. It installs on the sql server box and then acts like a remote database. Very easy, but potentially expensive as we're talking about software form Oracle, although some bird recently told me that Oracle is "giving" this software away. If you can believe that!!
Method 2 is to configure Heterogeneous services, basically ODBC, between Oracle and Sql*Server. If you’re running Oracle in Windows that might be easy, but if you’re on Unix, well lots of luck as I have not managed to get it working yet (which is where the expense is, namely your time chasing it).
And Amar Kumar fills the gap of running ODBC on Unix:
“I recently finalized a solution using hsodbc+unixodbc+freetds (ora 9i on solaris 9/10) . Took me some time to figure out but once set it is quite stable. I will put a note on this on my site soon.”
We’ll be waiting for his post..

Why extra standby redo log group?
And my favorite comes. Yong Huang asks this question and never accepts any suggestion without a proof:) I remember me asking this question to myself when i first met dataguard and reading its documentation. But it was just seconds that i couldn’t find a feasible answer and didn’t need to investigate.
At the end Yong Huang brings the discussion to valuable point by himself. He’re is his last post:
“I have some interesting finding. I opened an SR. Oracle support immediately called back and told me that the recommendation for an extra SRL group is for maximum protection (even though documentation doesn't say so). Fine. But he went on and said even if we have >2 groups on primary, only 2 SRL groups on standby will be used. Skeptical about that, I added one more group to primary so it has 3 now, and added one more SRL group to standby so it has 4 now. I opened 3 sqlplus sessions doing massive delete and rollback in a tight loop on 3 different tables. I'm very excited to find that SRL status check once every one to two seconds does occasionally show more than 3 groups active. In fact, in my test, of all 112 samplings, the first group becomes active with a probability of 82/(40+82)=67%, the second group 64/(58+64)=52%, the third 14/(108+14)=11%, and the fourth, i.e. the extra, group 4/(118+4)=3%. StandbyRedoLogStatus.txt, which is summarized below, records the repeated queries of v$standby_log.
C:\>grep "^ 4" StandbyRedoLogStatus.txt | grep -c UNASSIGNED
40
C:\>grep "^ 4" StandbyRedoLogStatus.txt | grep -c ACTIVE
82
C:\>grep "^ 5" StandbyRedoLogStatus.txt | grep -c UNASSIGNED
58
C:\>grep "^ 5" StandbyRedoLogStatus.txt | grep -c ACTIVE
64
C:\>grep "^ 6" StandbyRedoLogStatus.txt | grep -c UNASSIGNED
108
C:\>grep "^ 6" StandbyRedoLogStatus.txt | grep -c ACTIVE
14
C:\>grep "^ 7" StandbyRedoLogStatus.txt | grep -c UNASSIGNED
118
C:\>grep "^ 7" StandbyRedoLogStatus.txt | grep -c ACTIVE
4
The extra group being ACTIVE is such a rare event that I want to share my joy with you:
SQL> /
GROUP# THREAD# SEQUENCE# USED ARC STATUS FIRST_CHANGE# FIRST_TIME
4 1 682 10130432 NO ACTIVE 954336 20090410 11:21:49
5 1 684 512 YES ACTIVE 954466 20090410 11:21:50
6 1 683 10350592 NO ACTIVE 954347 20090410 11:21:50
7 1 685 0 YES ACTIVE 954756 20090410 11:21:52
That particular sampling is so rare (and precious!) in that all 4 groups are ACTIVE at the same time. By the way, I find that if the file system on the standby server where archive logs are stored becomes full, the all SRL showing ACTIVE phenomenon will also show up and persist. But in the above case, that was not due to space full condition and only appeared in one sampling.
The above test is done with recovery still going. Actually, recovery or not doesn't make difference. I guess my earlier attempt to see the extra SRL active failed is because I still didn't have enough redo per second. I can't think of any other explanation.

4 Responses so far.

  1. インモラル says:

    レディーチャイナ:http://www.hellokanpo.com/view/FLY-D5.html
    インモラル:http://immoral.hellokanpo.com
    淫インモラル:http://immoral.hellokanpo.com
    魔鬼天使性欲粉:http://www.hellokanpo.com/view/mogui-tianshi.html
    情愛芳香劑:http://www.hellokanpo.com/rush/
    黒倍王:http://www.hellokanpo.com/view/heibeiwang.html
    三鞭粒:http://www.hellokanpo.com/view/wei.html
    SPANISCHE FLIEGE D5:http://www.hellokanpo.com/view/SPANISCHE-FLIEGED5.html
    中華牛鞭:http://www.hellokanpo.com/view/zhonghua.html
    セフラジン:http://www.hellokanpo.com/view/kangshengwuzhi.html
    蔵秘雄精:http://www.hellokanpo.com/view/zangmitiongjing.html
    夜狼神:http://www.hellokanpo.com/view/yelangshen.html
    ビグレックス:http://www.hellokanpo.com/view/oil.html
    アフリカ超人:http://www.hellokanpo.com/view/chaoren.html
    インモラル:http://immoral.hellokanpo.com
    淫インモラル:http://immoral.hellokanpo.com
    悦可亭:http://www.hellokanpo.com/view/yueke.html
    止血薬 カルバゾクロム錠:http://www.hellokanpo.com/view/zhixueyao.html
    女性用バイアグラ:http://www.hellokanpo.com/view/nvweige.html
    安宮牛黄丸:http://www.hellokanpo.com/view/tongrenangong.html
    碧生源減肥:http://www.hellokanpo.com/view/bishengyuan.html
    D10催情剤:http://www.hellokanpo.com/view/D10-meiyao.html
    徳国黒金:http://www.hellokanpo.com/view/deguoheijin.html
    Xing霸:http://www.hellokanpo.com/view/xingba2000.html
    性霸2000:http://www.hellokanpo.com/view/xingba2000.html
    壮天根:http://www.hellokanpo.com/view/ZTG.html
    九鞭粒:http://www.hellokanpo.com/view/jiubianli.html
    蔵秘男宝:http://www.hellokanpo.com/view/zangmi.html
    藏秘男宝:http://www.hellokanpo.com/view/zangmi.html
    奇果:http://www.hellokanpo.com/view/qiguo.html
    LIDO SPRAY:http://www.hellokanpo.com/view/Lidosprayer.html
    リドスプレー:http://www.hellokanpo.com/view/Lidosprayer.html
    妖姫:http://youhi.hellokanpo.com
    インモラル:http://immoral.hellokanpo.com
    淫インモラル:http://immoral.hellokanpo.com
    夜夜堅:http://www.hellokanpo.com/view/yeyejian1200.html
    好漢哥:http://www.hellokanpo.com/view/haohange.html
    VVK:http://www.hellokanpo.com/view/VVK-Wenickman.html
    Wenickman:http://www.hellokanpo.com/view/VVK-Wenickman.html
    金博郎:http://www.hellokanpo.com/view/JinBoLang.html
    力多精:http://www.hellokanpo.com/view/lid-jing.html
    ヴァージン催淫水:http://www.hellokanpo.com/view/uejin.html
    poniwa超強力催淫水:http://www.hellokanpo.com/view/poniwa.html
    Lose Chastity 失貞粉:http://www.hellokanpo.com/view/Chastity.html
    KKK超強力催情水:http://www.hellokanpo.com/view/kkk.html

  2. 立挺90度 says:

    立挺90度:http://www.hellokanpo.com/view/liting90.html
    男根増長素:http://www.hellokanpo.com/view/nangen.html
    消渇丸:http://www.hellokanpo.com/view/xiaokewan.html
    消渇丸 輸入:http://www.hellokanpo.com/view/xiaokewan.html
    新一粒神:http://www.hellokanpo.com/view/xinyilishen.html
    壮三天:http://www.hellokanpo.com/view/zhuangsantian.html
    魔根:http://www.hellokanpo.com/view/muogen.html
    金動力:http://www.hellokanpo.com/view/jindongli.html
    黒色風暴:http://www.hellokanpo.com/view/heise-fengbao.html
    男露888:http://www.hellokanpo.com/view/nanlu888.html
    蔵八宝:http://www.hellokanpo.com/view/zhangbabao.html
    西班牙蒼蝿水:http://www.hellokanpo.com/view/xibanyamoli.html
    鹿茸腎宝:http://www.hellokanpo.com/view/lurong.html
    MaxMan:http://www.hellokanpo.com/view/MaxMan.html
    勃動力三體牛鞭:http://www.hellokanpo.com/view/santiniubian.html
    五便宝:http://www.hellokanpo.com/view/wodibo-capsules.html
    男宝:http://www.hellokanpo.com/view/nanbao.html
    VigRx:http://www.hellokanpo.com/view/vigrx.html
    vigrxプラス:http://www.hellokanpo.com/view/vigrx.html
    巨人倍増:http://www.hellokanpo.com/view/jurenbeiceng.html
    巨人倍増 通販:http://www.hellokanpo.com/view/jurenbeiceng.html
    三體牛鞭:http://www.hellokanpo.com/view/santiniubian.html
    三体牛鞭:http://www.hellokanpo.com/view/santiniubian.html
    威哥王:http://www.hellokanpo.com/view/weigewang.html
    威哥王 正規品:http://www.hellokanpo.com/view/weigewang.html
    狼1号:http://www.hellokanpo.com/view/langyihao.html
    狼一号:http://www.hellokanpo.com/view/langyihao.html
    三便宝:http://www.hellokanpo.com/view/satibo-capsules.html
    蟻力神:http://www.hellokanpo.com/view/yilishen.html
    淫インモラル:http://immoral.hellokanpo.com
    インモラル:http://immoral.hellokanpo.com
    金威龍:http://www.hellokanpo.com/view/jinweilong.html
    房事神油:http://www.hellokanpo.com/view/fangshi.html
    性福三宝:http://www.hellokanpo.com/view/xingfusanbao.html
    五夜神:http://www.hellokanpo.com/view/tbwy.html
    野生虫草王:http://www.hellokanpo.com/view/yesheng.html
    東方神龍生精:http://www.hellokanpo.com/view/dongfuangshenlong.html
    壮陽一号:http://www.hellokanpo.com/view/zhuangyangyihao.html
    達克寧:http://www.hellokanpo.com/view/dakening.html
    RUSH BLUE:http://www.hellokanpo.com/view/rush550.html
    ULTRA RUSH:http://www.hellokanpo.com/view/rush549.html
    ラッシュ芳香劑:http://www.hellokanpo.com/view/rush559.html

  3. 妖姫 says:

    妖姫:http://youhi.hellokanpo.com
    インモラル:http://immoral.hellokanpo.com
    淫インモラル:http://immoral.hellokanpo.com
    情愛芳香劑:http://www.hellokanpo.com/rush/
    妻之友:http://www.hellokanpo.com/view/qizhi.html
    D10:http://www.hellokanpo.com/view/D10-meiyao.html
    D10媚薬:http://www.hellokanpo.com/view/D10-meiyao.html
    D10催情剤:http://www.hellokanpo.com/view/D10-meiyao.html
    絶對高潮:http://www.hellokanpo.com/view/juedui.html
    絶對高潮カプセル:http://www.hellokanpo.com/view/juedui.html
    d9催情:http://www.hellokanpo.com/view/D9-INVERMA.html
    D8 催情剤:http://www.hellokanpo.com/view/SpanishFliegeD8.html
    FLY D5:http://www.hellokanpo.com/view/fly-d5.html
    D5原液:http://www.hellokanpo.com/view/FLYD5yuan.html
    蒼蝿水:http://www.hellokanpo.com/view/FLY-D5.html
    花之欲:http://www.hellokanpo.com/view/huazhiyu.html
    美人豹:http://www.hellokanpo.com/view/meirenbao.html
    福源春:http://www.hellokanpo.com/view/fuyuanchun.html
    催情丹:http://www.hellokanpo.com/view/cuiqingdan.html
    蟻王:http://www.hellokanpo.com/view/antking.html
    アリ王:http://www.hellokanpo.com/view/antking.html
    SEX DROPS:http://www.hellokanpo.com/view/sex-drops.html
    VOV催情粉:http://www.hellokanpo.com/view/vovcuiqing.html
    VOV催情液:http://www.hellokanpo.com/view/VOVcuiqingye.html
    小情人:http://www.hellokanpo.com/view/sex-drops5.html
    スペイン セックス ドロップ:http://www.hellokanpo.com/view/SpanishFliegeD8.html
    片仔廣:http://www.hellokanpo.com/view/pientze-huang.html
    へんしこう:http://www.hellokanpo.com/view/pientze-huang.html
    同仁堂牛黄清心丸:http://www.hellokanpo.com/view/trtnh.html
    牛黄清心丸:http://www.hellokanpo.com/view/trtnh.html

    精力剤:http://www.hellokanpo.com/JingLiJi
    媚薬:http://www.hellokanpo.com/meiyao
    催情剤:http://www.hellokanpo.com/view/D10-meiyao.html
    催情:http://www.hellokanpo.com/view/D10-meiyao.html
    催情粉:http://www.hellokanpo.com/view/hongzhizhu1.html
    催淫剤:http://www.hellokanpo.com/view/jueduigaochao.html
    ペニス増大:http://www.hellokanpo.com/view/VVK-Wenickman.html
    終極痩身:http://www.hellokanpo.com/view/zhongjishoushen.html
    超級脂肪燃焼弾:http://www.hellokanpo.com/view/FATBURNING.html
    スーパーファット:http://www.hellokanpo.com/view/FATBURNING.html
    大印象ダイエット茶:http://www.hellokanpo.com/view/dayinxiang.html
    御秀堂:http://www.hellokanpo.com/view/yuxiutang.html
    強効痩:http://www.hellokanpo.com/view/qiangxiao.html
    韓国痩身一号:http://www.hellokanpo.com/view/hanguoshou-575.html
    韓国痩身1号:http://www.hellokanpo.com/view/hanguoshou-575.html
    痩身一号:http://www.hellokanpo.com/view/hgshou.html
    痩身1号:http://www.hellokanpo.com/view/hgshou.html
    日本秀身堂:http://www.hellokanpo.com/view/xouzhentang.html
    天天素:http://www.hellokanpo.com/view/tiantiansu.html
    V26:http://www.hellokanpo.com/view/V26.html
    唯美OB:http://www.hellokanpo.com/view/wmob.html
    花痴:http://www.hellokanpo.com/view/huachi.html
    紅蜘蛛:http://www.hellokanpo.com/view/hong-zhi-zhu.html
    中絶薬:http://www.hellokanpo.com/zhongjue/
    中絶 薬:http://www.hellokanpo.com/zhongjue/
    RU486:http://www.hellokanpo.com/view/beijing-ru486.html
    ru486 個人輸入:http://www.hellokanpo.com/view/beijing-ru486.html
    潤滑剤:http://www.hellokanpo.com/view/K-YJelly-runhua.html
    コンドーム:http://www.hellokanpo.com/view/dlsh.html
    避妊薬:http://www.hellokanpo.com/zhongjue/birenyao.html
    淫インモラル:http://immoral.hellokanpo.com
    インモラル:http://immoral.hellokanpo.com
    媚薬 淫インモラル:http://immoral.hellokanpo.com
    媚薬 インモラル:http://immoral.hellokanpo.com
    淫インモラル 販売:http://immoral.hellokanpo.com
    インモラル 販売:http://immoral.hellokanpo.com
    媚薬 妖姫:http://youhi.hellokanpo.com
    妖姫 効果:http://youhi.hellokanpo.com
    妖姫 販売:http://youhi.hellokanpo.com
    妖姫 通販:http://youhi.hellokanpo.com
    妖姫:http://youhi.hellokanpo.com

  4. インモラル says:

    淫インモラル:http://immoral.hellokanpo.com
    インモラル:http://immoral.hellokanpo.com
    999皮炎平軟膏:http://www.hellokanpo.com/view/999piyan.html
    同仁烏鶏白鳳丸:http://www.hellokanpo.com/view/tongrenwuji.html
    婦科千金片:http://www.hellokanpo.com/view/fukeqian.html
    維尼好:http://www.hellokanpo.com/view/wnh.html
    司米安:http://www.hellokanpo.com/view/simian.html
    毓亭緊急避妊薬:http://www.hellokanpo.com/view/mtji.html
    縮陰膏:http://www.hellokanpo.com/view/suoyingao.html
    新顕臣粉刺浄:http://www.hellokanpo.com/view/fencijing.html
    火辣女強力媚薬:http://www.hellokanpo.com/view/HotSex-Girl.html
    超級猛男健力カプセル:http://www.hellokanpo.com/view/caoji.html
    早漏克星:http://www.hellokanpo.com/view/zaoxiekexing.html
    亀鹿睾丸生精片:http://www.hellokanpo.com/view/guilu.html
    徳国 増大宝:http://www.hellokanpo.com/view/deguozengdabao.html
    マカ:http://www.hellokanpo.com/view/MACA.html
    ビビッドビリリティ:http://www.hellokanpo.com/view/vivid-60.html

DOAG 2016

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -