随笔分类 -  Oracle / Oracle Error

ORA-12012: error on auto execute of job “SYS“.“ORA$AT_OS_OPT_SY_xx“解决办法
摘要：数据库版本： SQL> col banner for a100; SQL> set linesize 1000; SQL> select * from v$version; BANNER CON_ID Oracle Database 12c Enterprise Edition Release 12 阅读全文
posted @ 2024-02-19 16:20 雪竹子 阅读(301) 评论(0) 推荐(0) 编辑
ORA-01187 cannot read from file 201 because it failed verification tests..temp01
摘要：Description:We get this message in running the Upgrade Express 20-21 export (create_customer_data):ORA-01187: cannot read from file 201 because it fai 阅读全文
posted @ 2023-12-01 13:52 雪竹子 阅读(29) 评论(0) 推荐(0) 编辑
oracle查询scn
摘要：概述 在数据库的恢复过程，有时我们需要查询scn，分享一下具体的方法 解决方案 SQL>set numwidth 50 SQL> set linesize 150 pagesize 1000 SQL> select 'D' file_type, file#, checkpoint_change#, 阅读全文
posted @ 2023-10-25 10:54 雪竹子 阅读(98) 评论(0) 推荐(0) 编辑
Oracle特殊恢复原理与实战_12 Oracle坏块处理
摘要：http://dbase.cc/2018/05/22/oracle/Oracle%E7%89%B9%E6%AE%8A%E6%81%A2%E5%A4%8D%E5%8E%9F%E7%90%86%E4%B8%8E%E5%AE%9E%E6%88%98-%E8%AF%BE%E7%A8%8B%E5%AD%A6% 阅读全文
posted @ 2023-10-24 22:55 雪竹子 阅读(26) 评论(0) 推荐(0) 编辑
oracle修复坏块(BBED/RMAN)
摘要：https://blog.csdn.net/evil0305/article/details/119909664 阅读全文
posted @ 2023-10-24 22:45 雪竹子 阅读(19) 评论(0) 推荐(0) 编辑
Oracle BBED修改数据块进而修改数据
摘要：https://blog.csdn.net/baoyuhang0/article/details/108980528 阅读全文
posted @ 2023-10-24 22:37 雪竹子 阅读(17) 评论(0) 推荐(0) 编辑
ORA-609 : opiodr aborting process unknown ospid
摘要：ORA-609 : opiodr aborting process unknown ospid (8327_47148946930848) ORA-609 : opiodr aborting process unknown ospid (8327_47148946930848)As a genera 阅读全文
posted @ 2021-09-03 16:05 雪竹子 阅读(1273) 评论(0) 推荐(0) 编辑
ORA-01152: file 1 was not restored from a sufficiently old backup
摘要：ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01152: file 1 was not restored from a sufficiently old backup 问题描述 我们在用rman恢复数据库 阅读全文
posted @ 2021-08-26 20:43 雪竹子 阅读(1507) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示
🚀
回顶
➖
收起