oradbHome

2.
SQL> alter database commit to switchover to physical standby;
alter...]]> blog oradbHome Fri, 04 Jul 2008 14:36:04 GMT ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected http://space.itpub.net/?uid-471666-action-viewspace-itemid-371912
SQL> alter database commit to switchover to physical standby;
alter database commit to switchover to physical standby
*
ERROR at line 1:
ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

SQL>...]]> blog oradbHome Fri, 04 Jul 2008 14:11:44 GMT DATA GUARD 软件硬件系统要求 http://space.itpub.net/?uid-471666-action-viewspace-itemid-369007

dg 要求系统的限制约来约宽了. oracle11g 已经支持不在同步平台的dg, 例如 linux 和window是可以做dg , 但是在不同bit 版本的数据库(64bit 和32bit ) 还不支持建立dg, 可以是64bit os 和32bit os 上都按照32bit databas...]]> blog oradbHome Thu, 03 Jul 2008 14:11:40 GMT DATA GUARD 维护一 http://space.itpub.net/?uid-471666-action-viewspace-itemid-368995
1. 使 standby database 在应用 log 状态.

SQL> alter database recover managed standby database disconnect from session;
Media recovery complete.
SQL>

ALTER DATABASE RECOVER&n...]]> blog oradbHome Thu, 03 Jul 2008 14:02:41 GMT ORACLE10G RAC 环境搭建物理 DATA GUARD http://space.itpub.net/?uid-471666-action-viewspace-itemid-368876 一. 检查数据库要处于归档模式.
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival ...]]> blog oradbHome Wed, 02 Jul 2008 11:33:09 GMT oracle 10GR2 DROP DATAFILE http://space.itpub.net/?uid-471666-action-viewspace-itemid-368783
sys@oradb.> create tablespace tbs_test datafile '+DG1' size 5M;

...]]> blog oradbHome Tue, 01 Jul 2008 18:09:35 GMT 查询一物化视图不能进行查询重写的原因 http://space.itpub.net/?uid-471666-action-viewspace-itemid-366214

CREATE MATERIALIZED VIEW MV_TAB
REFRESH FORCE ON DEMAND
START WITH TO_DATE('29-06-2008 04:10:00', 'DD-MM-YYYY HH24:MI:SS') NEXT TRUNC(SYSDATE + 1, 'DD') + 4 / 24 + 10 / 1440
ENABLE QUER...]]> blog oradbHome Sat, 28 Jun 2008 15:40:16 GMT oracle events 列表 http://space.itpub.net/?uid-471666-action-viewspace-itemid-365981 生成代码:

SET linesize 120
SET feedback off
SET SERVEROUTPUT ON
DECLARE
err_msg VARCHAR2(120);
BEGIN
dbms_output.enable (1000000);
FOR err_num IN 10000..10999
LOOP
e...]]> blog oradbHome Thu, 26 Jun 2008 10:58:25 GMT oracle10g flashback versions 查询 http://space.itpub.net/?uid-471666-action-viewspace-itemid-351963 Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.3.0Connected as test
SQL> create table t_flash_ver (id number , name varchar2(200));
Table created

SQL> alter table t_flash_ver add cdate date default sysda...]]> blog oradbHome Fri, 20 Jun 2008 13:45:53 GMT linux lvm 增加swap 空间 http://space.itpub.net/?uid-471666-action-viewspace-itemid-351942

1. 查看lv
lvs
/dev/cdrom: open failed: No medium found
LV VG Attr LSize Origin Snap%...]]> blog oradbHome Fri, 20 Jun 2008 10:30:09 GMT Oracle AWR速查 -- 转载 http://space.itpub.net/?uid-471666-action-viewspace-itemid-351826 Oracle AWR速查

以上结果表示,每小时产生一个SNAPSHOT，...]]> blog oradbHome Thu, 19 Jun 2008 09:49:17 GMT 查看连接oracle 的客户端IP http://space.itpub.net/?uid-471666-action-viewspace-itemid-343254 大家都知道在v$session 中记录着客户端的机器名称,但是没有IP , 如果记录clinet ip 呢?

1. 利用triger 这里不介绍.

2. 利用 DBMS_SESSION 过程包.

BEGIN
DBMS_SESSION.set_identifier(SYS_CONTEXT('USERENV', 'IP_ADDRESS'));
END;...]]> blog oradbHome Tue, 10 Jun 2008 11:22:53 GMT Dba_2pc_Pending 处理 http://space.itpub.net/?uid-471666-action-viewspace-itemid-330994 SELECT * FROM Dba_2pc_Pending

BEGIN
COMMIT FORCE '13.31.25345' ;
dbms_transaction.purge_lost_db_entry('13.31.25345');
END;

]]> blog oradbHome Tue, 03 Jun 2008 10:21:56 GMT AUTO SGA: Not free http://space.itpub.net/?uid-471666-action-viewspace-itemid-329608 /app/oracle/admin/racdb/bdump/racdb2_mman_26392.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME = /app/oracle/produc...]]> blog oradbHome Mon, 02 Jun 2008 11:04:42 GMT ORA-06519 active autonomous transaction detected and rolled back http://space.itpub.net/?uid-471666-action-viewspace-itemid-329586
*** SESSION ID:(457.31015) 2008-06-02 07:31:29.011
*** 2008-06-02 07:31:29.011
ORA-12012: error on auto execute of job 44
ORA-01086: savepoint 'A' never established
ORA-06512: at "xxxx.pro_procedure", line 58
ORA-06519: active aut...]]> blog oradbHome Mon, 02 Jun 2008 10:31:40 GMT ORA-00600 [17285] http://space.itpub.net/?uid-471666-action-viewspace-itemid-324424 Fri May 30 00:33:11 2008
Errors in file /app/oracle/admin/racdb/udump/racdb1_ora_971000.trc:
ORA-00600: internal error code, arguments: [17285], [0x11050BE78], [4294967295], [0x7000000FBF569A8], [], [], [], []
ORA-00600: internal error code...]]> blog oradbHome Fri, 30 May 2008 11:33:35 GMT