-
编辑 删除
ORA-1578 ORA-26040 in a LOB segment (Doc ID 293515.1)
Purpose:The purpose of this article is to provide a script to update a lob column, that is referencing a lob block marked as corrupted due to NOLOGGING operations, with an empty lob.It will avoid errors ORA-1578 / ORA-26040 when the lob column is accessed by a sql statement like a SELECT and a...
-
编辑 删除
ORA-1578 解决思路
ORA-1578错误，出现的场景不同，解决办法也不相同，以下是各种场景下的解决办法一、 Database in ARCHIVELOG mode(归档并有备份):使用RMAN Block Mediarecovery进行恢复Mos相关文章Note 342972.1 How to perform Block Media Recovery(BMR) ...
-
编辑 删除
HugePages on Linux: What It Is... and What It Is Not...
ID 361323.1In this Document Purpose Scope HugePages on Linux: What It Is... and What It Is Not... Introduction ...
-
编辑 删除
临时使用
磊
-
编辑 删除
ORACLE 收集统计信息
今天网上看到一篇关于收集统计信息的文章，还不错，特转载下来。1. 理解什么是统计信息优化器统计信息就是一个更加详细描述数据库和数据库对象的集合，这些统计信息被用于查询优化器，让其...
-
编辑 删除
ORA-19550: cannot use backup/restore functions while using dispatcher
RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of delete command at 04/25/...
-
编辑 删除
多路径重用归档日志
SQL> show parameter log_archive_dest;NAME &n...
-
编辑 删除
单机迁移数据到RAC完整案例
单机迁移数据到RAC完整案例
