- 博客(94)
- 收藏
- 关注
转载 RMAN备份及恢复归档日志的语法
一.备份所有归档日志文件 RMAN> backup archivelog all delete input;二: restore archivelog 的各种选项 1.恢复全部归档日志文件 RMAN>...
2011-11-04 10:44:52 161
转载 实现linux下配置单网卡双ip的方法
1. [root@Linux root]#cd /etc/sysconfig/network-scripts [root@Linux network-scripts]#vi ifcfg-eth...
2011-10-10 10:16:08 216
转载 linux系统打开文件数过多的解决办法
一.永久生效.1. /etc/pam.d/login 添加 session required /lib/security/pam_limits.so2. /etc/security/limits.conf 添加...
2011-09-19 14:21:55 376
转载 rsync for windows 详细使用教程
rsync在windows与windows服务器之间的同步设置1.准备两台机器:server-----192.168.0.201client-----192.168.0.2022.下载windows版的rsync工具 ...
2011-09-09 11:13:35 1317
转载 重建表时,遇到ORA-02449: 表中的唯一/主键被外键引用的处理办法
1.检查哪些表的外键引用了要删除的表的唯一/主键. select A.* from user_constraints A, user_constraints B WHERE b.table_...
2011-09-02 09:34:40 230
转载 Unexpected inconsistency
一台测试的redhat操作系统在非正常关机后,重启,报如下错误:checking filesystem/: unexpected inconsistency;RUN fsck MANUALLYAn error occurre...
2011-08-15 11:34:44 96
转载 vi中替换命令
1. 基本的替换 :s/vivian/sky/ 替换当前行第一个 vivian 为 sky :s/vivian/sky/g 替换当前行所有 vivian 为 sky :n,$s/vivian/sky/ 替换第 ...
2011-08-04 16:00:46 67
转载 win2003系统通过ftp自动上传数据及定期删除脚本
ftp自动上传脚本:======================================@echo offset YEAR=%date:~0,4%set MONTH=%date:~5,2%set DAY=%dat...
2011-07-21 11:13:22 119
转载 "Found duplicate PV SdqCHHILXNSG1bLLLqtZ9fAv6sGTtiqj"的解决方法
在使用lvm的时候,会出现Found duplicate PV及cdrom的信息,如下:[root@mylinux2 lvm]# pvscan /dev/cdrom: open failed: Read-only f...
2011-05-13 13:48:23 675
转载 yum遇到warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY的解决办法
在redhat linux下有的时候用yum安装软件的时候最后会提示:warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID*****这是由于...
2011-05-10 16:15:10 205
转载 在主备库上统一的Rman备份脚本
crontab配置如下:0 3 * * 3,7 sh /home/oracle/shell/rman_mytest.sh >/home/oracle/shell/log/rman_mytest_`date +\%Y\%...
2011-04-11 14:42:47 88
转载 oracle打补丁步骤简介
1、了解opatchopatch是用于维护"个别"补丁的,有人称其为interim path或是one-off patch 该命令的存放位置在$ORACLE_HOME下的OPatch目录下. 使用“-help”参数可以获得o...
2011-03-17 11:56:44 158
转载 11GR2新特性(DEFERRED_SEGMENT_CREATION)
DEFERRED_SEGMENT_CREATIONPropertyDescriptionParameter typeBooleanDefault valuetrue...
2011-03-16 22:12:50 77
转载 单机rman备份脚本
crontab配置如下:-----------------------------------------------------------------------------------------------0 3...
2011-03-03 09:19:31 75
转载 Linux的free命令输出详解
我的linux执行free命令显示如下:[root@Linux /tmp]# free total used free shared buffers cach...
2011-02-25 12:46:11 85
转载 How to Convert a Single-Instance ASM to Cluster ASM [ID 452758.1]
In this DocumentApplies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.6Informat...
2011-02-23 23:04:26 58
转载 How to Convert 10g Single-Instance database RAC
In this Document3)Restore the backup of datafiles,redo logs,control file to a shared location on the cluster...
2011-02-23 23:02:05 74
转载 正确修改DBSNMP和SYSMAN密码
DBSNMP 密码修改: 1.Stop dbconsole2.set new password for dbsnmp3.test dbsnmp new password by connect4.进入到$ORACLE_HOME/h...
2011-02-15 10:08:02 165
转载 How to Recover Deleted Oracle Datafiles with No Downtime
So you have accidentally removed a datafile from your production database? First thing, DON’T PANIC! There’s an ea...
2011-02-13 16:56:23 99
转载 当前日志损坏的案例(蚂蚁)
[oracle@ts01 oracle]$ sqlplus ‘/ as sysdba’SQL*Plus: Release 9.2.0.4.0 - Production on Tue Nov 15 10:35:11 200...
2011-01-30 09:12:27 113
转载 一些X$表的小结
· 作者 小荷||【转载时请务必以超链接形式标明文章原始出处和作者信息】 · 永久链接: http://www.oracleblog.org/study-note/summary-of-some-x-tables/ 1....
2011-01-26 22:36:22 183
转载 RFS-process on physical standby database fails with Ora-00600:[Kcrrrfswda.9]
In this DocumentSymptomsChangesCauseSolutionReferencesApplies to: Oracle Server - Enterprise E...
2011-01-24 10:29:51 97
转载 Warning: OS async I/O limit 128 is lower than.. in Alert log
1. For more details about how to tune ASYNC I/O for Raw disk partitionson HP_UX kindly refer, Oracle Database Adm...
2011-01-21 17:25:46 94
转载 DataGuard体系结构
一、DataGuard总体结构 总体目标1、 描述计划和非计划停机的不同因数 2、 DataGuard的主要组件 3、 物理以及逻辑DataGuard的异同 4、 建立DataGuard的好处 5、 在高...
2011-01-21 16:41:08 185
转载 How to Add/Drop/Resize Redo Log with Physical Standby in place
In this DocumentGoalSolutionApplies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10...
2011-01-21 15:47:23 78
转载 Monitoring Open Cursors & Troubleshooting ORA-1000 Errors
In this DocumentPurposeScope and ApplicationMonitoring Open Cursors & Troubleshooting ORA-1000 ErrorsR...
2011-01-21 12:24:57 85
转载 ORA-00313, ORA-00312, ORA-27037 in Standby Database
ORA-00313, ORA-00312, ORA-27037 in Standby Database [ID 601835.1]修改时间 20-APR-2009类型 PROB...
2011-01-21 11:20:34 75
转载 sqlnet.expire_time and IDLE_TIME
当设置了resource_limit=true 。通过idle_time限制session idle 时间。session idle超过设置时间,状态为sniped (v$session).,然而OS下的process并不会释放...
2011-01-21 10:35:41 117
转载 Archiving With Multiple Destinations Fails With ORA-16040
fact: Oracle Server - Enterprise Edition 9.0fact: Oracle Server - Enterprise Edition 8.1symptom: Archiving fai...
2011-01-21 09:00:09 92
转载 Changing SYS passwd of PRIMARY db when STANDBY in place to avoid ORA-16191
In this DocumentGoalSolutionPlatforms: 1-914CU; This document is being delivered to you via Or...
2011-01-21 00:39:36 66
转载 Two ORA-1031 Reported in Trace File of Primary in Dataguard Configuration
In this DocumentSymptomsCauseSolutionReferencesThis document is being delivered to you via...
2011-01-21 00:03:27 82
转载 LOG_ARCHIVE_DEST_2 Fails With ORA-1031 [ID 259142.1]
In this DocumentSymptomsCauseSolutionReferencesApplies to: Oracle Server - Enterprise Edition - ...
2011-01-20 23:48:38 158
转载 Redo Corruption Errors During Redo Transport [ID 386417.1]
Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1.0 to 9.2.0.7.0This problem can occur on any plat...
2011-01-20 11:31:07 71
转载 LAG与LEAD分析函數的用法
LAG的使用例子:with a as (select 1 id,'a' name from dual union all select 2 id,'b' name from dual union all selec...
2011-01-12 13:41:32 99
转载 在ORACLE中增进SCN及案例介绍
在oracle数据库中我们可以利用oracle的内部事件调整SCN。增进SCN通常有两种常用方法:1.alter session set events 'IMMEDIATE trace name ADJUST_SCN l...
2010-12-20 23:36:05 62
转载 使用vi编辑器删除文本中所有空行
我这里在编辑一个很大的文件,有几万行,都是文件名sheetid, 中间有很多空行,我现在要做的事情就有要把这个文件中的空行都删除掉,这个本来想在ultraedit里面完成的,结果弄了好半天都没有搞定,时间紧急也没法再去慢慢的tr...
2010-11-12 09:27:17 492
转载 left join与right join
create table mytest1(id number,name varchar2(20));insert into mytest1 select 1,'a' from dual;insert into mytest1 s...
2010-08-29 11:55:08 81
转载 压缩及删除归档日志脚本
前两天备库的归档日志尚未应用,结果被脚本给压缩了,导致备库向主库再次请求归档日志时主库的归档日志也被压缩而找不到相应文件,结果报错.因以前的压缩及删除归档的脚本存在过多弊端,故重新写了一个通用版的压缩并删除归档程序....
2010-08-11 22:14:32 122
转载 OracleRAC10.2.0.1Linux升级到10.2.0.4步骤:
OracleRAC10.2.0.1Linux升级到10.2.0.4步骤: 1.下载升级补丁p6810189_10204_Linux-x86.zip,并上传到RAC的master node,解压. 2.停止数据库,...
2010-08-02 22:07:45 63
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人