今天应要求对某库中的一个用户下的数据进行备份，是在远端通过exp远程备份的。在执行exp后，报EXP-00091，见下： ?View Code BASH1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 srapp1:[/idep/srdb2_dmp]$ exp system/■■■@XJ_SR2 owner=sr2 file=/idep/srdb2_dmp/sr2.dmp log=/idep/srdb2_dmp/sr2.log buffer=102400000 feedback=100000 Export: Release 10.2.0.5.0 – Production on Thu May 17 19:01:30 2012 …省略部分… . about to export SR2′s tables via Conventional Path … . . exporting table [...]
一例简单的gg数据库同步复制案例： 源端地址：192.168.1.138 目标段地址：192.168.1.139 使用gg达到的目的：使源端hr用户下的数据库变化实时更新到目标段的hr用户下，实现源端与目标端中hr用户下的数据同步。 一、源端配置： 1、开启归档模式 2、开启数据库级supplemental logging ?View Code SQL1 2 3 4 5 6 7 SQL> alter database add supplemental log data; SQL> alter system switch logfile; SQL> select supplemental_log_data_min,supplemental_log_data_pk,supplemental_log_data_ui from v$database; SUPPLEME SUP SUP ——– — — YES NO NO 3、开启表级supplemental logging 生成add trandata命令语句： ?View Code SQL1 2 3 4 5 [...]
今天朋友说其一套10gR2 RAC数据库的节点1无法启动，随即远程登录上去看了下: ?View Code BASH1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 db1[/home/oracle]$crs_stat -t Name Type Target State Host ———————————————————— ora….SM1.asm application ONLINE OFFLINE ora….B1.lsnr application OFFLINE OFFLINE ora.db1.gsd application ONLINE ONLINE db1 ora.db1.ons application ONLINE ONLINE db1 ora.db1.vip application ONLINE OFFLINE ora….SM2.asm application ONLINE ONLINE db2 [...]
先来看一个建表语句： ?Download ligledba.txt1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 CREATE TABLE BOSSWG.INP_IDEP_DATA_RESPONSE_FILES ( FILE_ID NUMBER(12) NOT NULL, NE_ID NUMBER(9) NOT NULL, …省略… STAT_TIME VARCHAR2(12 BYTE) –注意该列数据类型，VARCHAR2 ) TABLESPACE BOSSWG_CFG PARTITION BY RANGE [...]
一套11.2.0.3库（单节点），控制文件被损坏启动报错一例 ?View Code SQL1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 [oracle@dbserverM ~]$ sqlplus ‘/as sysdba’ SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 25 18:44:14 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL> [...]
在从本地10.2.0.4版本的数据库端通过network_link expdp远端11.2.0.3版本的数据库时，报如下错误： ?View Code BASH1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 bmp1:[/oracle/dir02]$expdp system/oracle directory=dir02 dumpfile=scott.dmp logfile=scott_expdp.log schemas=scott content=metadata_only network_link=link_ht Export: Release 10.2.0.4.0 – 64bit Production on Wednesday, 25 April, 2012 13:01:46 Copyright (c) 2003, 2007, Oracle. All [...]
Applies to: Oracle Server – Enterprise Edition – Version: 9.2.0.1 to 11.2.0.2 – Release: 9.2 to 11.2 Information in this document applies to any platform. Goal We use a “alter session disable parallel query” and we need a way to double check if a session has parallel query disabled. Solution Please query the value of [...]
?View Code TEXT1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 [...]
?View Code SQL1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 SQL> alter session set nls_date_format=’yyyy-mm-dd hh24:mi:ss’; Session altered. SQL> select job,last_date,next_date,total_time,broken,interval,failures from dba_jobs where job=81; JOB LAST_DATE NEXT_DATE TOTAL_TIME B INTERVAL FAILURES ———- ——————- ——————- ———- – —————————— ———- 81 2012-04-01 01:31:05 2012-04-02 01:31:05 1042518 [...]
X$KTUXE视图的介绍（转自Mcalean博客） ?View Code SQL1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 [...]