-
编辑 删除
ORA-01652错误解决
SQL> conn / as sysdbaConnected.SQL> grant select on dba_objects to a;Grant succeeded.SQL> conn a/a Connected.SQL> select count(*) from dba_objects; COUNT(*)---------- &n...
-
编辑 删除
oracle中文乱码问题处理
环境描述：测试库：win2008 11.2.0.1.0 64bit 字符集AL32UTF8生产库：suse10 11.2.0.1.0 64bit 字符集WE8MSWIN1252检查字符集：windows2008:Microsoft Windows [版本 6.0.6001]版权所有 (C) 2006 Microsoft...
-
编辑 删除
将字符集WE8MSWIN1252转换成AL32UTF8
环境描述：测试库：win2008 11.2.0.1.0 64bit 字符集AL32UTF8生产库：suse10 11.2.0.1.0 64bit 字符集WE8MSWIN1252检查字符集：windows2008:Microsoft Windows [版本 6.0.6001]版权所有 (C) 2006 Microsoft ...
-
编辑 删除
ORACLE LOGMINER使用简单步骤
本身这个步骤很多高手都已经贴过了，只是我在使用中发现大体上大家写的都有些复杂，于是，我总结了个超级简化版的，方便大家使用：1.安装LOGMNR包，需要本步骤没什么可多说的，只是需要注意在连接数据库的时候默认最...
-
编辑 删除
Oracle 10gR2 RAC+ASM 归档设置示例
从Oracle 10gR2开始,对于RAC数据库设置归档模式非常方便,只需要在其中任何一个节点上操作,剩余节点instance关闭即可,下面是一个Oracle 10.2.0.2版本2个节点的RAC数据库打开归档模式的示例,归档存放在FRA磁盘组下的d...
-
编辑 删除
sys用户下不允许创建物化视图
SQL> conn /as sysdbaConnected.SQL>SQL>SQL> create table t(x int);Table created.SQL> insert into t values (1);1 row created.SQL> insert into t values (2);1 row created.SQL> /1 row created.SQL> ...
-
编辑 删除
启用oracle10g Flashback闪回功能
[oracle@ocmdb1 ~]$ sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 18 08:46:00 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database ...
-
编辑 删除
使用>清空监听日志文件
$ >/u01/app/oracle/product/10.2.0/db_1/network/log/listener.log$cat /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log$ tail -200f /u01/app/oracle/product/10.2.0/db_1/network/log/listener....
-
编辑 删除
动态监听注册
[oracle@ocmdb1 ~]$ sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 16 12:45:08 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database ...
-
编辑 删除
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 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database ...
-
编辑 删除
RMAN备份语法
RMAN备份语法archivelogRecordSpecifierThis subclause specifies a range of archived redo logs. 001 ARCHIVELOG 002 { ALL 003 LIKE 'string_pattern' 004 archlogRange [LIKE...
-
编辑 删除
rman backup
QuickSqlRMANBACKUPBack up a database, tablespace, datafile, archived log, or backup set. RMAN puts the input files into one or more backup sets, which are RMAN-specific logical structures. The bac...
-
编辑 删除
RMAN Run Clause
RMAN Run ClauseCombine several RMAN commands into a single task, if any one command fails RMAN uses some vaguely intelligent logic and may or may not abort the remainder of the combined task.Syntax:...
-
编辑 删除
RMAN Set Clause
RMAN Set ClauseSettings that apply only to the current RMAN session.Syntax: SET { set_rman_option [;] | set_run_option; } set_rman_option::= { ECHO { ON | OFF } | DBID [=] integer ...
-
编辑 删除
RMAN Show clause
RMAN Show clauseDisplay the currently enabled CONFIGURE commands.Syntax: SHOW { RETENTION POLICY | [DEFAULT] DEVICE TYPE | [AUXILIARY] CHANNEL [FOR DEVICE TYPE deviceSpecifier] | M...
-
编辑 删除
RMAN Report Clause
RMAN Report ClauseReport backup status: database files, status of files and backups (obsolete or unrecoverable.)The REPORT command performs more complex analysis than LIST. Syntax: REPORT { { ...
-
编辑 删除
RMAN Delete
RMAN DeleteDelete backups (and copies) from disk or tape, and update the RMAN repository.Syntax: DELETE [FORCE] [NOPROMPT] { [EXPIRED] { { BACKUP [OF listObjectList] | C...
-
编辑 删除
RMAN LIST
RMAN LISTList the backups and copies recorded in the repository.Syntax: LIST { INCARNATION [OF DATABASE [['] database_name [']]] | [EXPIRED] { listObjectSpec [ maintQualifier |...
-
编辑 删除
RMAN Restore Clause
RMAN Restore ClauseRestore RMAN backups and copies.Syntax: RESTORE [(] restoreObject [(restoreSpecOperand [restoreSpecOperand]...] [)]... [ CHANNEL ['] channel_id ['] | PARMS [=] 'chann...
-
编辑 删除
RMAN Recover Clause
RMAN Recover ClausePerform. media recovery from RMAN backups and copies.Syntax: RECOVER [DEVICE TYPE deviceSpecifier [, deviceSpecifier]...] recoverObject [recoverOptionList]; ...
