联系：手机/微信(+86 17813235971) QQ(107644445)标题：DBMS_SESSION.set_context提示ORA-01031问题解决作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]最近给客户把oracle数据库从11.2.0.3 aix平台迁移到19.23 linux平台,使用impdp+network_link 按照用户的方式处理,结果发现有一个程序运行异常ORA-01031: insufficient privileges通过程序跟踪确认是在调用以下部分异常DBMS_SESSION.set_context ( 'back_exec', 'back_exec_log_no', v_back_exec_log_no ……通过跟踪执行用户权限,确认EXECUTE ON SYS.DBMS_SESSION已经授权.做一个简单测试重现给问题:SQL> show user; USER 为 "SYS" SQL> exec DBMS_SESSION.SET_CONTEXT('test_ctx', 'a', '1'); BEGIN DBMS_SESSION.SET_CONTEXT('test_ctx', 'a', '1'); END; * 第 1 行出现错误: O ...继续阅读 (39)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：DBMS_SESSION.set_context提示ORA-01031问题解决作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]最近给客户把oracle数据库从11.2.0.3 aix平台迁移到19.23 linux平台,使用impdp+network_link 按照用户的方式处理,结果发现有一个程序运行异常ORA-01031: insufficient privileges通过程序跟踪确认是在调用以下部分异常DBMS_SESSION.set_context ( 'back_exec', 'back_exec_log_no', v_back_exec_log_no ……通过跟踪执行用户权限,确认EXECUTE ON SYS.DBMS_SESSION已经授权.做一个简单测试重现给问题:SQL> show user; USER 为 "SYS" SQL> exec DBMS_SESSION.SET_CONTEXT('test_ctx', 'a', '1'); BEGIN DBMS_SESSION.SET_CONTEXT('test_ctx', 'a', '1'); END; * 第 1 行出现错误: O ...继续阅读 (29)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：redo写丢失导致ORA-600 kcrf_resilver_log_1故障作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]有一个客户硬件故障,做完硬件恢复之后,数据库启动报ORA-600 kcrf_resilver_log_1错误.Thu Aug 22 13:37:50 2024 alter database open Beginning crash recovery of 1 threads parallel recovery started with 3 processes Started redo scan Errors in file e:\oracle\zy\diag\rdbms\orcl\orcl\trace\orcl_ora_1640.trc (incident=9767): ORA-00600: 内部错误代码, 参数: [kcrf_resilver_log_1], [0x7DCEBE020], [2], [], [], [], [], [], [], [], [], [] Incident details in: e:\oracle\zy\diag\rdbms\orcl\orcl\incident\incdir_9767\orcl ...继续阅读 (34)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：redo写丢失导致ORA-600 kcrf_resilver_log_1故障作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]有一个客户硬件故障,做完硬件恢复之后,数据库启动报ORA-600 kcrf_resilver_log_1错误.Thu Aug 22 13:37:50 2024 alter database open Beginning crash recovery of 1 threads parallel recovery started with 3 processes Started redo scan Errors in file e:\oracle\zy\diag\rdbms\orcl\orcl\trace\orcl_ora_1640.trc (incident=9767): ORA-00600: 内部错误代码, 参数: [kcrf_resilver_log_1], [0x7DCEBE020], [2], [], [], [], [], [], [], [], [], [] Incident details in: e:\oracle\zy\diag\rdbms\orcl\orcl\incident\incdir_9767\orcl ...继续阅读 (24)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：硬件故障导致ORA-01242 ORA-01122等错误作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]客户多个节点rac,早上反馈说有两个节点实例异常,需要分析原因,查看其中一个节点的数据库alert日志,发现是由于访问1399号文件异常报ORA-01242 ORA-01122等错误,导致实例crashMon Aug 19 20:48:02 2024 Read of datafile '+DATA/xifenfei_01-157.dbf' (fno 1399) header failed with ORA-01207 Rereading datafile 1399 header failed with ORA-01207 Errors in file /u01/app/oracle/diag/rdbms/xff/xff6/trace/xff6_ckpt_75582.trc: ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode ORA-01122: database file 1399 failed verification check ORA-01110 ...继续阅读 (38)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：硬件故障导致ORA-01242 ORA-01122等错误作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]客户多个节点rac,早上反馈说有两个节点实例异常,需要分析原因,查看其中一个节点的数据库alert日志,发现是由于访问1399号文件异常报ORA-01242 ORA-01122等错误,导致实例crashMon Aug 19 20:48:02 2024 Read of datafile '+DATA/xifenfei_01-157.dbf' (fno 1399) header failed with ORA-01207 Rereading datafile 1399 header failed with ORA-01207 Errors in file /u01/app/oracle/diag/rdbms/xff/xff6/trace/xff6_ckpt_75582.trc: ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode ORA-01122: database file 1399 failed verification check ORA-01110 ...继续阅读 (25)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：断电引起redo和数据文件不一致故障恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]有些时候故障总是来的让人非常意外,这个在准备停机迁移数据库之前的几分钟由于某种原因直接导致主机掉电,再次开机数据库无法启动Sat Aug 03 23:10:37 2024 Successful mount of redo thread 1, with mount id 3696805928 Database mounted in Exclusive Mode Lost write protection disabled Completed: alter database mount Sat Aug 03 23:10:43 2024 alter database open Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\xff\xff\trace\xff_ora_6808.trc: ORA-01113: 文件 21 需要介质恢复 ORA-01110: 数据文件 21: 'D:\APP\ADMINISTRATOR\ORADATA\XFF\XIFENFEI.DBF' ORA-1113 signalled during: alt ...继续阅读 (43)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：断电引起redo和数据文件不一致故障恢复作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]有些时候故障总是来的让人非常意外,这个在准备停机迁移数据库之前的几分钟由于某种原因直接导致主机掉电,再次开机数据库无法启动Sat Aug 03 23:10:37 2024 Successful mount of redo thread 1, with mount id 3696805928 Database mounted in Exclusive Mode Lost write protection disabled Completed: alter database mount Sat Aug 03 23:10:43 2024 alter database open Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\xff\xff\trace\xff_ora_6808.trc: ORA-01113: 文件 21 需要介质恢复 ORA-01110: 数据文件 21: 'D:\APP\ADMINISTRATOR\ORADATA\XFF\XIFENFEI.DBF' ORA-1113 signalled during: alt ...继续阅读 (29)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-03113: 通信通道的文件结尾作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]数据库启动报:ORA-03113: 通信通道的文件结尾PS C:\Users\Administrator> sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on 星期六 8月 3 11:05:03 2024 Copyright (c) 1982, 2010, Oracle. All rights reserved. 已连接到空闲例程。 SQL> startup nomount ORACLE 例程已经启动。 Total System Global Area 2.0510E+10 bytes Fixed Size 2184632 bytes Variable Size 1.1476E+10 bytes Database Buffers 8992587776 bytes Redo Buffers 40046592 bytes SQL> shutdown immediate ORA-0150 ...继续阅读 (33)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-03113: 通信通道的文件结尾作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]数据库启动报:ORA-03113: 通信通道的文件结尾PS C:\Users\Administrator> sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on 星期六 8月 3 11:05:03 2024 Copyright (c) 1982, 2010, Oracle. All rights reserved. 已连接到空闲例程。 SQL> startup nomount ORACLE 例程已经启动。 Total System Global Area 2.0510E+10 bytes Fixed Size 2184632 bytes Variable Size 1.1476E+10 bytes Database Buffers 8992587776 bytes Redo Buffers 40046592 bytes SQL> shutdown immediate ORA-0150 ...继续阅读 (34)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：手工对multipath设备进行授权导致asm 磁盘组mount报ORA-15032-ORA-15131作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]客户硬件通过底层重组raid,然后把lun进行到asm的机器上,在mount data_dg磁盘组的时候,报ORA-15032 ORA-15131错误,磁盘组无法正常mount,这种报错不太常见,一般要不直接报某个block无法访问,要不直接报缺少asm disk之类的.通过远程上去分析,发现alert日志如下Wed Jul 31 04:55:17 2024 NOTE: attached to recovery domain 1 NOTE: cache recovered group 1 to fcn 0.1814063801 NOTE: redo buffer size is 256 blocks (1053184 bytes) Wed Jul 31 04:55:17 2024 NOTE: LGWR attempting to mount thread 1 for diskgroup 1 (DATA_DG) Errors in file /oracle/u01/app/grid/diag/asm/+a ...继续阅读 (38)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：手工对multipath设备进行授权导致asm 磁盘组mount报ORA-15032-ORA-15131作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]客户硬件通过底层重组raid,然后把lun进行到asm的机器上,在mount data_dg磁盘组的时候,报ORA-15032 ORA-15131错误,磁盘组无法正常mount,这种报错不太常见,一般要不直接报某个block无法访问,要不直接报缺少asm disk之类的.通过远程上去分析,发现alert日志如下Wed Jul 31 04:55:17 2024 NOTE: attached to recovery domain 1 NOTE: cache recovered group 1 to fcn 0.1814063801 NOTE: redo buffer size is 256 blocks (1053184 bytes) Wed Jul 31 04:55:17 2024 NOTE: LGWR attempting to mount thread 1 for diskgroup 1 (DATA_DG) Errors in file /oracle/u01/app/grid/diag/asm/+a ...继续阅读 (31)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：Oracle23ai新特性—sqlplus errordetails功能作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]在oracle 23ai中如果sqlplus执行遇到ORA-错误,会有对应的Help: https://docs.oracle.com/error-help/db/ORA-XXXXX提示,由于以前的使用习惯或者是提示本身意义不大等原因,还是希望在sqlplus中关闭这类提示.通过分析确认该提示是由errordetails来控制的[oracle@xifenfei admin]$ sqlplus / as sysdba SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Mon Jul 29 22:44:23 2024 Version 23.5.0.24.07 Copyright (c) 1982, 2024, Oracle. All rights reserved. Connected to: Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for ...继续阅读 (36)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：Oracle23ai新特性—sqlplus errordetails功能作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]在oracle 23ai中如果sqlplus执行遇到ORA-错误,会有对应的Help: https://docs.oracle.com/error-help/db/ORA-XXXXX提示,由于以前的使用习惯或者是提示本身意义不大等原因,还是希望在sqlplus中关闭这类提示.通过分析确认该提示是由errordetails来控制的[oracle@xifenfei admin]$ sqlplus / as sysdba SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Mon Jul 29 22:44:23 2024 Version 23.5.0.24.07 Copyright (c) 1982, 2024, Oracle. All rights reserved. Connected to: Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for ...继续阅读 (47)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：存储宕机导致Oracle异常故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]存储突然掉线，导致数据库crash,报大量ORA-00206 ORA-00202 ORA-15081以及Linux-x86_64 Error: 5: Input/output error之类的错误Sun Jul 21 20:00:11 2024 Thread 1 advanced to log sequence 1594398 (LGWR switch) Current log# 5 seq# 1594398 mem# 0: +DATA/xff/onlinelog/group_5.412.906718739 Sun Jul 21 20:53:17 2024 WARNING: Write Failed. group:2 disk:0 AU:506916 offset:49152 size:16384 Sun Jul 21 20:53:17 2024 WARNING: Read Failed. group:2 disk:2 AU:506931 offset:49152 size:16384 WARNING: failed to read mirror side 1 of ...继续阅读 (36)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：存储宕机导致Oracle异常故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]存储突然掉线，导致数据库crash,报大量ORA-00206 ORA-00202 ORA-15081以及Linux-x86_64 Error: 5: Input/output error之类的错误Sun Jul 21 20:00:11 2024 Thread 1 advanced to log sequence 1594398 (LGWR switch) Current log# 5 seq# 1594398 mem# 0: +DATA/xff/onlinelog/group_5.412.906718739 Sun Jul 21 20:53:17 2024 WARNING: Write Failed. group:2 disk:0 AU:506916 offset:49152 size:16384 Sun Jul 21 20:53:17 2024 WARNING: Read Failed. group:2 disk:2 AU:506931 offset:49152 size:16384 WARNING: failed to read mirror side 1 of ...继续阅读 (36)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-00756 ORA-10567故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]数据库异常断电之后，recover 报ORA-00756 ORA-10567等错SQL> recover database; ORA-00756: 恢复操作检测到数据块写入丢失 ORA-10567: Redo is inconsistent with data block (file# 1,block# 113855,file offset is 932700160 bytes) ORA-10564: tablespace SYSTEM ORA-01110: 数据文件 1: 'H:\BAIDUNETDISK\XIFENFEI\SYSTEM01.DBF' ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 67alert日志报大量block逻辑错误2024-07-16T13:16:31.050599+08:00 Slave exiting with ORA-10562 exception 2024-07-16T13:16:31.050599+08:00 Errors in f ...继续阅读 (47)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-00756 ORA-10567故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]数据库异常断电之后，recover 报ORA-00756 ORA-10567等错SQL> recover database; ORA-00756: 恢复操作检测到数据块写入丢失 ORA-10567: Redo is inconsistent with data block (file# 1,block# 113855,file offset is 932700160 bytes) ORA-10564: tablespace SYSTEM ORA-01110: 数据文件 1: 'H:\BAIDUNETDISK\XIFENFEI\SYSTEM01.DBF' ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 67alert日志报大量block逻辑错误2024-07-16T13:16:31.050599+08:00 Slave exiting with ORA-10562 exception 2024-07-16T13:16:31.050599+08:00 Errors in f ...继续阅读 (44)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-01092 ORA-00604 ORA-08103故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]数据库启动报SQL> alter database open; alter database open * 第 1 行出现错误: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00604: error occurred at recursive SQL level 1 ORA-08103: object no longer exists 进程 ID: 39348 会话 ID: 67 序列号: 29322对应的alert日志Mon Jul 15 10:59:46 2024 SMON: enabling cache recovery Mon Jul 15 10:59:46 2024 Undo initialization finished serial:0 start:302658203 end:302658218 diff:15 ms (0.0 seconds) Verifying minimum file header compatibility (11g) ...继续阅读 (88)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-01092 ORA-00604 ORA-08103故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]数据库启动报SQL> alter database open; alter database open * 第 1 行出现错误: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00604: error occurred at recursive SQL level 1 ORA-08103: object no longer exists 进程 ID: 39348 会话 ID: 67 序列号: 29322对应的alert日志Mon Jul 15 10:59:46 2024 SMON: enabling cache recovery Mon Jul 15 10:59:46 2024 Undo initialization finished serial:0 start:302658203 end:302658218 diff:15 ms (0.0 seconds) Verifying minimum file header compatibility (11g) ...继续阅读 (43)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：数据库启动报ORA-600 6711故障分析处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]几个月以前的一个数据库故障,今天拿出来在win上重新分析,数据库启动报ORA-600 6711错C:\Users\XFF>SQLPLUS / AS SYSDBA SQL*Plus: Release 12.1.0.2.0 Production on 星期日 7月 14 16:17:32 2024 Copyright (c) 1982, 2014, Oracle. All rights reserved. 已连接到空闲例程。 SQL> startup mount pfile='d:/pfile.txt' ORACLE 例程已经启动。 Total System Global Area 6442450944 bytes Fixed Size 6205768 bytes Variable Size 1493175992 bytes Database Buffers 4932501504 bytes Redo Buffers 10567680 bytes 数据 ...继续阅读 (36)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：数据库启动报ORA-600 6711故障分析处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]几个月以前的一个数据库故障,今天拿出来在win上重新分析,数据库启动报ORA-600 6711错C:\Users\XFF>SQLPLUS / AS SYSDBA SQL*Plus: Release 12.1.0.2.0 Production on 星期日 7月 14 16:17:32 2024 Copyright (c) 1982, 2014, Oracle. All rights reserved. 已连接到空闲例程。 SQL> startup mount pfile='d:/pfile.txt' ORACLE 例程已经启动。 Total System Global Area 6442450944 bytes Fixed Size 6205768 bytes Variable Size 1493175992 bytes Database Buffers 4932501504 bytes Redo Buffers 10567680 bytes 数据 ...继续阅读 (55)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：RMAN SBT_TAPE备份无法被DISK通道识别作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]经过测试确认rman SBT_TAPE通道备份的rman备份集无法被DISK通道(文件系统方式备份)方式恢复,关于rman的SBT_TAPE通道(带库方式备份)备份参考:模拟带库实现rman远程备份发起SBT_TAPE通道备份备份[oracle@xifenfei ~]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 14 13:19:03 2024 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: XIFENFEI (DBID=1780931490) RMAN> CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE; using target database control file instead of recovery catalog old ...继续阅读 (36)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：RMAN SBT_TAPE备份无法被DISK通道识别作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]经过测试确认rman SBT_TAPE通道备份的rman备份集无法被DISK通道(文件系统方式备份)方式恢复,关于rman的SBT_TAPE通道(带库方式备份)备份参考:模拟带库实现rman远程备份发起SBT_TAPE通道备份备份[oracle@xifenfei ~]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 14 13:19:03 2024 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: XIFENFEI (DBID=1780931490) RMAN> CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE; using target database control file instead of recovery catalog old ...继续阅读 (91)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-27154 ORA-27300 ORA-27301 ORA-27302故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]根据经验对系统的内核参数做了一些调整,结果导致数据库启动失败提示报ORA-27154 ORA-27300 ORA-27301 ORA-27302错误ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpcreates根据官方描述:Database Startup Fails with ORA-27300: OS system dependent operation:semget failed with status: 28 (Doc ID 949468.1),出现该问题原因可能是由于kernel.sem参数配置不合适当时,该库的processes配置为:20000,kernel.sem ...继续阅读 (35)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：ORA-27154 ORA-27300 ORA-27301 ORA-27302故障处理作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]根据经验对系统的内核参数做了一些调整,结果导致数据库启动失败提示报ORA-27154 ORA-27300 ORA-27301 ORA-27302错误ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpcreates根据官方描述:Database Startup Fails with ORA-27300: OS system dependent operation:semget failed with status: 28 (Doc ID 949468.1),出现该问题原因可能是由于kernel.sem参数配置不合适当时,该库的processes配置为:20000,kernel.sem ...继续阅读 (51)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：Patch SCN工具for Linux作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]前几年开发了图形化的win平台的patch scn工具:一键修改Oracle SCN工具升级(patch scn)最近基于linux平台开发了命令行方式的Patch scn工具,大概使用如下:1. 数据库必须处于mount状态才能修改scn[oracle@iZbp11c0qyuuo1gr7j98upZ tmp]$ ./Patch_SCN 328 247884300 ERROR:Oracle Database must be in Mount state in order to modify SCN2. Patch_SCN参数提示[oracle@iZbp11c0qyuuo1gr7j98upZ tmp]$ ./Patch_SCN Use Parameters: PID SCN(10) [ADDR(16,don't 0x)]3.修改SCN 具体操作1)启动数据库到mount状态 SQL> startup mount; ORACLE instance started. Total System Global Area 551165952 bytes Fix ...继续阅读 (54)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：Patch SCN工具for Linux作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]前几年开发了图形化的win平台的patch scn工具:一键修改Oracle SCN工具升级(patch scn)最近基于linux平台开发了命令行方式的Patch scn工具,大概使用如下:1. 数据库必须处于mount状态才能修改scn[oracle@iZbp11c0qyuuo1gr7j98upZ tmp]$ ./Patch_SCN 328 247884300 ERROR:Oracle Database must be in Mount state in order to modify SCN2. Patch_SCN参数提示[oracle@iZbp11c0qyuuo1gr7j98upZ tmp]$ ./Patch_SCN Use Parameters: PID SCN(10) [ADDR(16,don't 0x)]3.修改SCN 具体操作1)启动数据库到mount状态 SQL> startup mount; ORACLE instance started. Total System Global Area 551165952 bytes Fix ...继续阅读 (42)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：RMAN-06207 RMAN-06208报错解决作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]数据库在rman备份时执行delete noprompt expired backup报RMAN-06207和RMAN-06208错误RMAN>delete noprompt expired backup; RMAN retention policy will be applied to the command RMAN retention policy is set to recovery window of 1 days allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1364 instance=hisdb1 device type=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: SID=3102 instance=hisdb1 device type=DISK allocated channel: ORA_DISK_3 channel ORA_DISK_3: SID=4534 instance=hisdb1 device typ ...继续阅读 (47)

联系：手机/微信(+86 17813235971) QQ(107644445)标题：RMAN-06207 RMAN-06208报错解决作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]数据库在rman备份时执行delete noprompt expired backup报RMAN-06207和RMAN-06208错误RMAN>delete noprompt expired backup; RMAN retention policy will be applied to the command RMAN retention policy is set to recovery window of 1 days allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1364 instance=hisdb1 device type=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: SID=3102 instance=hisdb1 device type=DISK allocated channel: ORA_DISK_3 channel ORA_DISK_3: SID=4534 instance=hisdb1 device typ ...继续阅读 (54)