ITPub博客

<STYLE. -- {page:Section1;} div.Section1 layout-grid:18.0pt;} mso-paper-source:0; mso-footer-margin:49.6pt; mso-header-margin:42.55pt; 90.0pt; 72.0pt 90.0pt margin:72.0pt 841.9pt; {size:595.3pt Sectio...

数据库恢复实例五:处理用户错误FLASHBACK篇这里的用户指的非DBA用户,用户错语有两种:误删表,误数据用户错误如下:oak用户下的test1表由于失误删除,请求恢复SQL>  select count(*) from test; select c...

数据库恢复实例四:处理坏块数据错误如下:SQL> select count(*) from test;select count(*) from testERROR at line 1:ORA-01578: ORACLE data block corrupted (file # 2, block # 1095)ORA-01110: data file...

RMAN自动备份脚本环境:Linux4U5+ORACLE10GR21.备份脚本如下:level 0级备份脚本#!/bin/shexport ORACLE_SID=hdi26export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1export PATH=.:$ORACLE_HOME/bin:$P...

数据库恢复实例三:恢复spfile数据库错误如下:SQL> startup nomount;ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/...

ORACLE10GR2 RMAN catalog命令详解CATALOG:1.CATALOG BACKUPPICECATALOG BACKUPPIECE '/disk2/09dtq55d_1_2', '/disk2/0bdtqdou_1_1';2.CATALOG ARCHVIELOGCATALOG ARCHIVELOG '/archivelog/1_30.arc', '/arch...

数据库恢复实例二:恢复控制文件数据库错误如下:[oracle@HDI01 hdi26]$ rman target / nocatalog Recovery Manager: Release 10.2.0.1.0 - Production on Wed Dec 10 10:32:44 2008 Copyright (c) 19...

数据库恢复实例一:重建undo表空间数据库错误如下:ORA-01116:error in opening database file 2ORA-01110:datafile 2:'/u02/oradata/sfcsys/undotbs01.dbf'ORA-27041:unable to open fileLinux Error 2:No such fi...

安装数据库收到ORA-00600错误OS:Linux4U5DataBase:10R2安装数据库没有问题,创建数据库报如下错误ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []解决方法:正...

online redefinition example环境:Red Hat Linux4.5+ORACLE10GR2创建测试用表CREATE TABLE TEST(  ORDER_ID  NUMBER,  DETAIL    CHAR(255),  CONSTRAINT PK_TEST PRIMARY KEY (...

online table redefinitiononline table redefinition是oracle9i引入的新特性，在10g加强了这个特性，该特性通过DBMS_REDEFINITON包实现的。online table redefinitio保证了表的可用性，（alter table ...move 和cr...

通过bat文件设置Window时间同步在设置Window时间同步时﹐如果你不想写命令就用下的bat檔吧bat文件内容如下:@echo offecho autor OAK@echo offecho --------------------------------@echo offecho setup time res...

Subject:  WAITEVENT: "TCP Socket (KGAS)" Reference Note   Doc ID:  Note:558510.1 Type:  REFERENCE   Last Revision Date:  19-MAR-2008 Status:  PUBLISHED "TCP Socket ...

10gR2 Dedicated Connections Intermittently Fail with TNS-12518 Subject:  10gR2 Dedicated Connections Intermittently Fail with TNS-12518   Doc ID:  Note:371983.1 Type:  PROBLEM &...

Subject:  Shared server connections hang after installing CPUJAN2006   Doc ID:  Note:361273.1 Type:  PROBLEM   Last Revision Date:  21-JUL-2008 Status:  MODERATED I...

DataGuard standby_archive_dest与log_archvie_dest_n参数说明standby_archive_dest:用于存放归档日志log_archive_dest_n:在使用recover automatic standby database寻找归档时使用的路径建议将这两参数的路径设...

一次standby异常处理问题描述:primary与standby日志不同步,在primary上切换日志不能传输到standby上.查看v$archive_gap没有数据.环境:OS:Linux AS4DB:ORACLE10GR2  确认是否存在archivelog gapSQL> s...

通过系统PID找出问题SQL用top监控系统的性能时﹐发现cpu占用率高或长时间运行的oracle进程时﹐可以根据PID查出所执行的SQL.下面以一个例子说明假定PID为25431 首先通过PID来找到oracle对应的process&nbsp...

ORA-01102 cannot mount database in EXCLUSIVE mode今天遇到ORA-01102﹐跟据网上如下方法解决﹐特收集原文链接：http://www.hellodba.com/cases/case-unexception_down.htm数据库异常关闭后无法启动问题处理一例...

AUTO_SPACE_ADVISOR_JOB ERROR ORA-20000错误信息如下﹕ORA-12012: error on auto execute of job 8898ORA-20000: ORA-20000: Content of the tablespace specified is not permanent or tablespace name is inva...