从这节开始讲其他的参数,参数从v$parameter中提取 基本参数请看如下链接: http://www.zhaibibei.cn/oralce/oracle-parameter/ 如无特殊说明数据库版本为11.2 undo_management...参数类型:字符串 语法:UNDO_MANAGEMENT = { MANUAL | AUTO } 默认值:AUTO 修改:修改需要重启数据库 基础参数:否 取值范围:MANUAL或AUTO RAC中各实例必须为相同的值
参数类型:整型 默认值: 1.1 * SESSIONS 修改:修改需要重启数据库 基础参数:否 取值范围:4 to 2的32次方 ---- 取值意义 该参数决定 UNDO_MANAGEMENT =...MANUAL时,可以有多少online的回滚段 最大的同时事务数的限制由下面决定 UNDO_MANAGEMENT = AUTO时有undo表空间大小决定 UNDO_MANAGEMENT = MANUAL
----------------- ----------- ------------------------------ temp_undo_enabled boolean FALSE undo_management...----------------- ----------- ------------------------------ temp_undo_enabled boolean FALSE undo_management
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ undo_management...string MANUAL undo_retention integer 900 undo_tablespace string UNDOTBS1 undo_management: 设置数据库的撤销段是否使用自动管理模式...在undo_management位auto时生效,为动态参数 undo_tablespace: 指定使用哪个表空间来实现数据的撤销,在undo_management位auto时生效,为动态参数 retention...--9i之后使用的撤销段 INDEX USERS LOBINDEX USERS LOBSEGMENT USERS NESTED TABLE USERS TABLE USERS --下面将undo_management...改为支持自动管理,需要重启实例 SQL> ALTER SYSTEM SET undo_management = 'auto' SCOPE = SPFILE; System altered.
TRANSACTIONS_PER_ROLLBACK_SEGMENT) 该参数不仅可以指定私有的回滚段,同时也可以指定不在使用的公共的回滚段 可以在DBA_ROLLBACK_SEGS视图中找到回滚段的名称,ID以及状态 注意 该参数在UNDO_MANAGEMENT...参考链接 https://docs.oracle.com/cd/E18283_01/server.112/e17110/initparams219.htm 下期参数 undo_management
TYPE VALUE ------------------------------------ ----------- ------------------------------ undo_management...undo_tablespace string UNDOTBS1 SQL> ho grep undo /u02/database/BODB3/initBODB3.ora undo_management...表空间 SQL> ho vi /u02/database/BODB3/initBODB3.ora SQL> ho grep undo /u02/database/BODB3/initBODB3.ora undo_management...TYPE VALUE ------------------------------------ ----------- ------------------------------ undo_management
unknown bytes) 2、生成Oracle的pfile并加入如下三个参数 _allow_resetlogs_corruption=true #跳过redo崩溃,允许resetlogs开库 undo_management...4193], [], [], [], [], [], [], [], [], [], [], [] 接下来ORA600[4193]的处理就是ORACLE rac的undo表空间的重建了,需要配合参数:undo_management
TYPE VALUE ------------------------------------ ----------- ------------------------------ undo_management...TYPE VALUE ------------------------------------ ----------- ------------------------------ undo_management...*.undo_management='MANUAL' *....TYPE VALUE ------------------------------------ ----------- ------------------------------ undo_management
VALUE --------------------- --------------------------------------------- undo_management...- ----------- ------------------------------ _undo_autotune boolean FALSE undo_management
TYPE VALUE ------------------------------------ ----------- ------------------------------ undo_management...integer 900 undo_tablespace string UNDOTBS1 可以看到undo_management...官档这样描述: Automatic undo management uses an undo tablespace.To enable automatic undo management, set the UNDO_MANAGEMENT
空间作用 回滚事务 恢复数据库 提供一致性读 利用Flashback query 查询过去的数据 利用Flashback 特性恢复逻辑错误 ---- 自动undo段空间管理 启用undo段自动管理 undo_management
Shutdown the instance 3. set the following parameters in the pfile /tmp/initsid.ora undo_management
在查看undo的使用率的时候,在Undo_management为auto的时候,经常会看到undo自己在不断的伸缩扩展,自我调节。
row_locking 在更新操作期间指定是否需要使用行级锁 trace_enabled 控制执行历史,代码路径跟踪 undo_management...sga_target=337641472 #下面的thread,undo_tablespace即为唯一参数 ora10g2.thread=2 ora10g1.thread=1 *.undo_management
/arch log_archive_format = %t_%s.dbf db_file_multiblock_read_count= 16 fast_start_mttr_target = 300 undo_management.../arch log_archive_format = %t_%s.dbf db_file_multiblock_read_count= 16 fast_start_mttr_target = 300 undo_management...########### # System Managed Undo and Rollback Segments ########################################### undo_management
pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management
create pfile from spfile; Shutdown the instance set the following parameters in the pfile undo_management...(1) 根据spfile创建pfile, create pfile from spfile; (2) 停止实例,编辑文件,增加: *.undo_management=manual *.event='10513
pga_aggregate_target=135266304 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=406847488 *.undo_management...pga_aggregate_target=135266304 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=406847488 *.undo_management...*.remote_login_passwordfile='EXCLUSIVE' /*远程登陆是否要用密码文件*/ *.sga_target=406847488 /*定义了sga的大小*/ *.undo_management
TYPE VALUE ------------------------------------ ----------------------------------------- undo_management... TYPE VALUE ------------------------------------ ------------------------------------- undo_management
直接通过10015 event 来推进数据库的scn;另外由于是异常关机,那么这里Undo 必然也无法进行正常恢复;因此同时设置 undo_management 参数为manual,并同时设置10015
领取专属 10元无门槛券
手把手带您无忧上云