-
编辑 删除
Flashback Data Archive Requirements
Flashback Data Archive Requirements 1. Flashback Data Archive tablespaces must be managed with automatic segment space management&...
-
编辑 删除
SQL Management Base Architecture
SQL Management Base ArchitectureWithin the SYSAUX data dictionary tablespace one can find a SQL Management Base entry for a one or more SQL statements when this feature is enabled.The SQL Ma...
-
编辑 删除
Automatic Diagnostic Repository (ADR)
The ADR is a file-based repository for database diagnostic data such as traces, dumps, the alert log, health m...
-
编辑 删除
BLOCK CHANGE TRACKING
About Block Change TrackingIf block change tracking is enabled on a primary or standby database, then RMAN uses a block change tracking file to identify changed blocks for incremental backup...
-
编辑 删除
SESSIONS, PROCESSES, TRANSACTIONS
1. SESSIONS, PROCESSES, TRANSACTIONSSESSIONSDefault value : (1.5 * PROCESSES) + 22 (ORACLE 11G) / (1.1 * PROCESSES) + 5 (ORACLE 10G)Range of values: 1 to231http://do...
-
编辑 删除
ORA-00258: manual archiving in NOARCHIVELOG mode must identify log
10g RAC 数据库未归档。 解释:alter system archive log current*ERROR at line 1:ORA-00258: manual archiving in NOARCHIVELOG mode must identify logOERR: ORA 258 manual archiving in...
-
编辑 删除
归档区别
alter system s swotch logfile : 仅对当前节点的对应redo thread 进行日志切换并归档。alter system archive log current 对集群内所有节点 的redo thread 进行日志切换并归档...
-
编辑 删除
IMP 错误
IMP 导入错误IMP-00019: row rejected due toORACLE error 1IMP-00003: ORACLE error 1encounteredORA-00001: unique constraint(SYSMAN.MGMT_PRIV_INCLUDES_PK) violated查到MGMT_PRIV_INCLUDES_P...
-
编辑 删除
RAC 用户权限错误
错误代码ORA-01565: error in identifying file '+DATA/ruirui/spfileruirui.ora'ORA-17503: ksfdopn:2 Failed to open file +DATA/ruirui/spfileruirui.oraORA-01031: insufficient privileges描述：RAC 用户id需要...
-
编辑 删除
统计用户表对应字段
select TABLE_NAME,COLUMN_NAME,DATA_TYPE from user_tab_columns;
-
编辑 删除
About Static Data Dictionary Views
1.静态数据字典视图：Data dictionary tables are not directly accessible, but you can access information in them through data dictionary views. To list the data dictionary views available to...
-
编辑 删除
rman 备份 全库
run{allocate channel d1 type disk maxpiecesize=50G;allocate channel d2 type disk maxpiecesize=50G;backup full database filesperset 10 include current controlfile format '/backup/fullbak_%d_%T_%s_%...
-
编辑 删除
给自己的歌
想得却不可得你奈人生何该舍的舍不得只顾著跟往事瞎扯等你发现时间是贼了它早已偷光你的选择爱恋不过是一场高烧思念是紧跟著的好不了的咳是不能原谅却无法阻挡恨意在夜里翻墙是空空荡荡却嗡嗡作响谁在你心里放冷枪旧...
-
编辑 删除
TEMPORARY Tablespaces and TEMPFILES 详细解释
What are Temporary Tablespaces:Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables. For example, if you join two large tables, and Oracl...
-
编辑 删除
TEMPORARY Tablespaces and TEMPFILES
具体需求： 安装完oracle 10g DATA GUARD 需要修改tempfile参数 刚装好DATA GUARD 时 tempfile 大小为 30M 需要对其修改查询当前tempfile 大小 和数据文件SELECT NAME, bytes/1024/1024 ...
