-
编辑 删除
物理standby database的日常维护
Standby database
-
编辑 删除
物理standby database的日常维护
物理standby database的日常维护 分类： oracle相关 2012-12-06 22:25695人阅读评论(0)收藏举报1.停止Standbyselect process, s...
-
编辑 删除
Recover On Primary Using Flashback On A Standby Database
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=169781064884617&id=958557.1&_afrWindowMode=0&_adf.ctrl-state=mnmggr81a_4How To Recover From A Drop/Truncate/Delete Table Done On Primary Using Flashback On A Standby Database (Doc ID 958557.1)Applies to:Oracle Server - Enterpris...
-
编辑 删除
CTSSD Runs (Doc ID 1054006.1)
In this DocumentSymptomsCauseSolutionReferencesApplies to: Oracle Server - Enterprise Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]Information in this document applies to any plat...
-
编辑 删除
Oralce ASH report
@$ORACLE_HOME/rdbms/admin/ashrpt.sql v$sessionv$active_session_historydba_hist_active_sess_historyselect * from dba_hist_active_sess_history a where a.session_id=266 and a...
-
编辑 删除
Statistics related view
v$segment_statistics SQL> desc v$segment_statistics; Name  ...
-
编辑 删除
Introduction of DataGuard protection mode
http://www.oracledistilled.com/oracle-database/high-availability/data-guard/changing-the-data-guard-protection-mode/ Changing the Data Guard Protection Mode Oracle Data Guard provid...
-
编辑 删除
All the privileges the user has
SQL> select PRIVILEGE from dba_sys_privs where GRANTEE='SCOTT';PRIVILEGE----------------------------------------UNLIMITED TABLESPACESQL> select TABLE_NAME,PRIVILEGE from dba_tab_privs where GRANTEE=...
-
编辑 删除
Check the transaction running in oracle
SQL> conn scott/tiggerConnected.SQL>SQL>SQL> select distinct sid from v$mystat; SID---------- 28SQL> create table...
-
编辑 删除
11gR2; AWR Reports in RAC
http://www.oracle-class.com/?p=2409 1- AWR Concept:In this post, I am going to show you how to generate AWR reports for Real Application Clusters (RAC) environment.AWR was first introduce...
-
编辑 删除
Notes of Oracle 11.2 Dataguard setup
1. Change primary database to force logging modealter database force logging;2. Create standby controlalter database create standby controlfile as '/tmp/control.ctl';3. Primary database parameter file...
-
编辑 删除
oem11g agent
./emctl stop agent./emctl start agent./emctl unsecure agent./agentca -f./agentca -p ./agentca -help After database not connected issue, oem unable to check database stat...
-
编辑 删除
有用的Oracle DOCS ID
Oracle Recommended Patches — Oracle Database [ID 756671.1] 文档中查到各个产品版本最新的PSU。 你也可以 找到最新的PSU通过tab[Patches & Updat...
-
编辑 删除
Difference between UTF8 and AL32UTF8
转载： http://oracleappstechnology.blogspot.jp/2007/10/difference-between-utf8-and-al32utf8.html Difference between UTF8 and AL32UTF8UTF8 and AL32UTF8 are encodings of the Unicode charact...
-
编辑 删除
11g ACTIVE STANDBY
转： http://gavinsoorma.com/2009/06/11g-active-standby/11g ACTIVE STANDBYActive Standby :PRIMARY DB- APEXSTANDBY DB- APEXDGNow you can bring up the standby database in read-only mode a...
