- 博客(37)
- 收藏
- 关注
转载 ORA-01652错误解决
SQL> conn / as sysdbaConnected.SQL> grant select on dba_objects to a;Grant succeeded.SQL> conn a/a Conn...
2013-02-19 10:13:25
275
转载 oracle中文乱码问题处理
环境描述:测试库:win2008 11.2.0.1.0 64bit 字符集AL32UTF8生产库:suse10 11.2.0.1.0 64bit 字符集WE8MSWIN1252检查字符集:windows2008:M...
2011-11-17 17:48:26
128
转载 将字符集WE8MSWIN1252转换成AL32UTF8
环境描述:测试库:win2008 11.2.0.1.0 64bit 字符集AL32UTF8生产库:suse10 11.2.0.1.0 64bit 字符集WE8MSWIN1252检查字符集:windows2008:Mic...
2011-11-17 17:43:54
174
转载 ORACLE LOGMINER使用简单步骤
本身这个步骤很多高手都已经贴过了,只是我在使用中发现大体上大家写的都有些复杂,于是,我总结了个超级简化版的,方便大家使用:1.安装LOGMNR包,需要本步骤没什么可多说的,只是需要注意在连接数据库的时候默认最好使用本地验证方式C...
2011-11-01 18:10:06
123
转载 Oracle 10gR2 RAC+ASM 归档设置示例
从Oracle 10gR2开始,对于RAC数据库设置归档模式非常方便,只需要在其中任何一个节点上操作,剩余节点instance关闭即可,下面是一个Oracle 10.2.0.2版本2个节点的RAC数据库打开归档模式的示例,归...
2011-11-01 17:29:43
93
转载 sys用户下不允许创建物化视图
SQL> conn /as sysdbaConnected.SQL>SQL>SQL> create table t(x int);Table created.SQL> insert into...
2011-05-23 18:57:08
207
转载 启用oracle10g Flashback闪回功能
[oracle@ocmdb1 ~]$ sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 18 08:46:00 2011Co...
2011-05-18 10:09:22
73
转载 使用>清空监听日志文件
$ >/u01/app/oracle/product/10.2.0/db_1/network/log/listener.log$cat /u01/app/oracle/product/10.2.0/db_1/netwo...
2011-05-16 13:06:37
101
转载 动态监听注册
[oracle@ocmdb1 ~]$ sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 16 12:45:08 2011Co...
2011-05-16 12:52:18
82
转载 Error accessing PRODUCT_USER_PROFILE解决
[oracle@ocmdb1 ~]$ sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 16 12:11:34 2011Co...
2011-05-16 12:12:26
186
转载 RMAN备份语法
RMAN备份语法archivelogRecordSpecifierThis subclause specifies a range of archived redo logs.001 ARCHIVELOG 002...
2011-04-28 17:22:40
198
转载 rman backup
QuickSqlRMANBACKUPBack up a database, tablespace, datafile, archived log, or backup set. RMAN puts the inp...
2011-04-28 17:19:31
90
转载 RMAN Run Clause
RMAN Run ClauseCombine several RMAN commands into a single task, if any one command fails RMAN uses some vague...
2011-04-28 16:46:51
73
转载 RMAN Set Clause
RMAN Set ClauseSettings that apply only to the current RMAN session.Syntax: SET { set_rman_option [;] | set_...
2011-04-28 16:44:22
71
转载 RMAN Show clause
RMAN Show clauseDisplay the currently enabled CONFIGURE commands.Syntax: SHOW { RETENTION POLICY |...
2011-04-28 16:43:35
71
转载 RMAN Report Clause
RMAN Report ClauseReport backup status: database files, status of files and backups (obsolete or unrecoverable...
2011-04-28 16:42:33
74
转载 RMAN Delete
RMAN DeleteDelete backups (and copies) from disk or tape, and update the RMAN repository.Syntax: DELETE [F...
2011-04-28 16:41:38
87
转载 RMAN LIST
RMAN LISTList the backups and copies recorded in the repository.Syntax: LIST { INCARNATION [OF DATABASE [...
2011-04-28 16:40:20
71
转载 RMAN Restore Clause
RMAN Restore ClauseRestore RMAN backups and copies.Syntax: RESTORE [(] restoreObject [(restoreSpecOperan...
2011-04-28 16:39:00
82
转载 RMAN Recover Clause
RMAN Recover ClausePerform. media recovery from RMAN backups and copies.Syntax: RECOVER [DEVICE TYPE deviceS...
2011-04-28 16:37:40
76
转载 RMAN Configure Clause
RMAN Configure ClauseChange persistent RMAN configuration settings.Syntax: CONFIGURE devi...
2011-04-28 16:35:54
117
转载 RMAN Change Clause
RMAN Change ClauseUpdate the status of a backup or copy in the RMAN repository.Syntax: CHANGE {BACKUP | COPY} ...
2011-04-28 16:34:44
66
转载 RMAN Backup Clause
RMAN Backup ClauseBack up database files, archive logs, backups, or copies.Syntax:BACKUP FULL OptionsB...
2011-04-28 16:20:11
66
转载 RMAN Crosscheck Clause
RMAN Crosscheck ClauseCheck whether backup pieces, proxy copies, or disk copies still exist in comparison to t...
2011-04-28 16:17:47
74
转载 impdp语法
$ impdp -helpImport: Release 11.1.0.6.0 - 64bit Production on Thursday, 28 April, 2011 14:20:21Copyright (c) 2...
2011-04-28 14:26:21
145
转载 expdp语法
$ expdp -helpExport: Release 11.1.0.6.0 - 64bit Production on Thursday, 28 April, 2011 14:20:10Copyright (c) 2...
2011-04-28 14:25:00
253
转载 crosscheck archivelog all用途
当手动删除归档日志文件后,Rman备份会检测到日志缺失,从而无法进一步继续执行。所以此时需要手工执行crosscheck过程,之后Rman备份可以恢复正常。RMAN> crosscheck archivelog all...
2011-04-26 21:03:01
367
转载 ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
oracle11g rac在重新创建控制文件后,以open resetlogs打开库时报了此错ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) ...
2011-04-26 20:39:12
350
转载 recover database using backup controlfile与recover database的差别
要理解recover database using backup controlfile,先理解 recover databasegN{0Fvzh0也就是说,不加using backup controlfile的情况。[$WT!...
2011-04-19 21:17:49
53
转载 ORA-00059错误解决
今天在执行ALTER TABLESPACE ** ADD DATAFILE **命令时出现了ORA-00059: 超出 DB_FILES 的最大值的错误信息,之前已经成功添加了几个datafile数...
2011-04-12 17:14:54
330
转载 什么是Oracle RAC
什么是Oracle RAC?文章分类:数据库 Source:http://hi.baidu.com/movieyouth/blog/item/9478800140d788d2277fb5a1.htmlRAC...
2011-03-17 14:05:36
58
转载 exp语法
[oracle@standby ~]$ exp -helpExport: Release 10.2.0.4.0 - Production on Wed Mar 2 19:07:53 2011Copyright (c) 1...
2011-03-16 10:31:47
134
转载 imp语法
[oracle@standby ~]$ imp -helpImport: Release 10.2.0.4.0 - Production on Wed Mar 2 19:08:16 2011Copyright (c) 1...
2011-03-16 10:30:05
263
转载 oracle em预警
预警 : ATTENTION - Enterprise Manager Database Control 10.2.0.4 Or 10.2.0.5 - Patch Required from 31-Dec-2010...
2011-03-16 10:25:06
118
转载 oracle查看表空间使用情况
SELECT tablespace_name,sum_m as total_m, ( sum_m- free_m) as used_m,free_m,to_char(100*(sum_m-free_m)/sum_m, '99.9...
2011-03-15 22:03:59
55
转载 Oracle11g R2 ORA-32004故障解决
(3)查看参数文件内容[oracle@oracle dbs]$ cat inittest.ora...
2011-02-12 16:52:55
97
转载 Oracle11g R2 ORA-32004故障解决
oracle11g R2手动在裸设备(RAW)上建库后,数据库可正常使用,当每次启动数据库时总报ORA-32004错误,如下:SQL>startup...
2011-02-12 15:55:56
171
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人