标签云
asm mount asm 恢复 asm恢复 bbed bootstrap$ dul eking In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2662 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle异常恢复 ORACLE恢复 Oracle 恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 sql加密恢复 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币 oracle 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (91)
- 数据库 (1,419)
- DB2 (22)
- MySQL (58)
- Oracle (1,305)
- Data Guard (41)
- EXADATA (7)
- GoldenGate (20)
- ORA-xxxxx (150)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (12)
- ORACLE 21C (3)
- Oracle ASM (58)
- Oracle Bug (7)
- Oracle RAC (42)
- Oracle 安全 (6)
- Oracle 开发 (26)
- Oracle 监听 (26)
- Oracle备份恢复 (438)
- Oracle安装升级 (71)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (63)
- PostgreSQL (10)
- SQL Server (26)
- SQL Server恢复 (7)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (24)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (7)
-
最近发表
- O/S-Error: (OS 23) 数据错误(循环冗余检查) 数据库恢复
- 数据库open报ORA-00959: tablespace ‘UNDOTBS1′ does not exist分析
- ASM删除表空间恢复
- ORA-12518 ORA-27302: 错误发生在: ssthrddcr
- plsql 插入blob
- 分享运气超级好的一次drop tablespace 数据恢复
- segment header异常对象删除处理
- Oracle 数据库(RDBMS)的版本支持状态摘要 (Doc ID 1674382.1)
- [back2023@proxy.tg].eking勒索数据库恢复
- ORA-600 ktbsdp2 处理
- win文件系统损坏oracle恢复
- asm disk 磁盘部分被清空恢复
- File #xxx found in data dictionary but not in controlfile. Creating OFFLINE file ‘MISSING00XXX’ in the controlfile
- commit_wait和commit_logging设置不当导致数据库无法正常启动
- ORA-00742 ORA-00312故障恢复
- 110T oracle故障恢复
- ora-600 kcratr_scan_lastbwr
- .asistchinadecryption扩展名勒索数据库恢复
- .[decrypt20@firemail.cc].eking 数据库勒索恢复
- ocr磁盘组掉盘故障处理
友情链接
标签归档:12c oradebug poke
oradebug poke ORA-32521/ORA-32519故障解决
最近有不少朋友咨询12.1.0.2及其以后的版本使用oradebug去修改scn失败,这里做了一个测试正常情况下确实无法修改(oradebug poke报 ORA-32519 或者 ORA-32521) ,这里进行了一系列修改测试最后修改成功.
数据库版本
SQL> select * from v$version; BANNER CON_ID -------------------------------------------------------------------------------- ---------- Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0 PL/SQL Release 12.1.0.2.0 - Production 0 CORE 12.1.0.2.0 Production 0 TNS for 64-bit Windows: Version 12.1.0.2.0 - Production 0 NLSRTL Version 12.1.0.2.0 - Production 0
oradebug poke测试
SQL> oradebug setmypid 已处理的语句 SQL> oradebug DUMPvar SGA kcsgscn_ kcslf kcsgscn_ [14C8D6270, 14C8D62A0) = 009EA333 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 4C8D5CF0 00000001 SQL> oradebug poke 0x14C8D6274 4 0x00000001 ORA-32521: 对 ORADEBUG 命令 进行语法分析时出错 --或者该提示 SQL> oradebug setmypid 已处理的语句 SQL> oradebug DUMPvar SGA kcsgscn_ kcslf kcsgscn_ [14C8D6270, 14C8D62A0) = 009EAE3D 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 4C8D5CF0 00000001 SQL> oradebug poke 0x14C8D6274 4 0x0000000a ORA-32519: 权限不足, 无法执行 ORADEBUG 命令: execution of ORADEBUG commands is disabled for this instance
通过测试确定oradebug正常情况无法执行poke,不是提示ORA-32521就是提示ORA-32519错误导致scn无法修改.
通过一些修改之后oradebug 修改scn
SQL> select dbid, name,open_mode, 2 created created, 3 open_mode, log_mode, 4 checkpoint_change# as checkpoint_change#, 5 controlfile_type ctl_type, 6 controlfile_created ctl_created, 7 controlfile_change# as ctl_change#, 8 controlfile_time ctl_time, 9 resetlogs_change# as resetlogs_change#, 10 resetlogs_time resetlogs_time 11 from v$database; DBID NAME OPEN_MODE CREATED OPEN_MODE LOG_MODE ---------- ---------------------------------------------------- -------------------- -------------- ------------ ------------ CHECKPOINT_CHANGE# CTL_TYP CTL_CREATED CTL_CHANGE# CTL_TIME RESETLOGS_CHANGE# RESETLOGS_TIME ------------------ ------- -------------- ----------- -------------- ----------------- -------------- 1504692401 XIFENFEI READ WRITE 16-8月 -15 READ WRITE ARCHIVELOG 10407853 CURRENT 16-8月 -15 10408361 07-7月 -16 1 16-8月 -15 SQL> select con_id,file#,checkpoint_change# from v$datafile_header; CON_ID FILE# CHECKPOINT_CHANGE# ---------- ---------- ------------------ 1 1 10407853 2 2 9457324 1 3 10407853 2 4 9457324 1 5 10407853 1 6 10407853 3 7 10407853 3 8 10407853 3 9 10407853 4 10 9559964 4 11 9559964 4 12 9559964 3 13 10407853 已选择 13 行。 SQL> shutdown abort; ORACLE 例程已经关闭。 SQL> startup ORACLE 例程已经启动。 Total System Global Area 3221225472 bytes Fixed Size 3837232 bytes Variable Size 838861520 bytes Database Buffers 2365587456 bytes Redo Buffers 12939264 bytes 数据库装载完毕。 SQL> oradebug setmypid 已处理的语句 SQL> oradebug DUMPvar SGA kcsgscn_ kcslf kcsgscn_ [14BE16270, 14BE162A0) = 009ED5C6 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 4BE15CF0 00000001 SQL> oradebug poke 0x14BE16274 4 0x0001 BEFORE: [14BE16274, 14BE16276) = 0000 AFTER: [14BE16274, 14BE16276) = 0001 SQL> alter database open; 数据库已更改。 SQL> select dbid, name,open_mode, 2 created created, 3 open_mode, log_mode, 4 checkpoint_change# as checkpoint_change#, 5 controlfile_type ctl_type, 6 controlfile_created ctl_created, 7 controlfile_change# as ctl_change#, 8 controlfile_time ctl_time, 9 resetlogs_change# as resetlogs_change#, 10 resetlogs_time resetlogs_time 11 from v$database; DBID NAME OPEN_MODE CREATED OPEN_MODE LOG_MODE ---------- ---------------------------------------------------- -------------------- -------------- ----------- ------------ CHECKPOINT_CHANGE# CTL_TYP CTL_CREATED CTL_CHANGE# CTL_TIME RESETLOGS_CHANGE# RESETLOGS_TIME ------------------ ------- -------------- ----------- -------------- ----------------- -------------- 1504692401 XIFENFEI READ WRITE 16-8月 -15 READ WRITE ARCHIVELOG 4305478053 CURRENT 16-8月 -15 4305478245 07-7月 -16 1 16-8月 -15 SQL> select con_id,file#,checkpoint_change# from v$datafile_header; CON_ID FILE# CHECKPOINT_CHANGE# ---------- ---------- ------------------ 1 1 4305478053 2 2 9457324 1 3 4305478053 2 4 9457324 1 5 4305478053 1 6 4305478053 3 7 4305478053 3 8 4305478053 3 9 4305478053 4 10 9559964 4 11 9559964 4 12 9559964 3 13 4305478053 已选择 13 行。 SQL> select con_id,file#,checkpoint_change# from v$datafile; CON_ID FILE# CHECKPOINT_CHANGE# ---------- ---------- ------------------ 1 1 4305478053 2 2 9457324 1 3 4305478053 2 4 9457324 1 5 4305478053 1 6 4305478053 3 7 4305478053 3 8 4305478053 3 9 4305478053 4 10 9559964 4 11 9559964 4 12 9559964 3 13 4305478053 已选择 13 行。
通过上述测试证明scn已经被完美修改.证明我们已经具备了不使用bbed的情况下推进12.1.0.2版本的scn问题,为12c的一系列需要推scn的恢复提供完美技术支持.
发表在 Oracle备份恢复
标签为 12c oradebug poke, ORA-32519, ORA-32521, oradebug ORA-32519, oradebug poke, oradebug scn
评论关闭