2015年02月_渔夫数据库笔记

12月 11月 10月 09月 08月 07月 06月 05月 04月 03月 02月 01月

原创 Using Flashback Database and Restore Points

Using Flashback Database and Restore Points This chapter explains Flashback Database, restore points. This chapter discusses configuring, monitoring, and maintaining these features as part of an ov

2015-02-27 14:37:22 803

原创 Dataguard 主库数据文件rename方法

9.3.4 Renaming a Datafile in the Primary Database When you rename one or more datafiles in the primary database, the change is not propagated to the standby database. Therefore, if you want to re

2015-02-25 19:49:34 876

转载 Script to show Active Distributed Transactions

该脚本可以用于显示活跃的分布式事务(Distributed Transactions from dblink)，可以协助诊断dblink远程事务： REM distri.sql column origin format a13 column GTXID format a35 column LSESSION format a10 column s format a1 column wait

2015-02-10 16:27:30 471

转载 Fast-Start On-Demand Rollback&Fast-Start Parallel Rollback

During the second phase of instance recovery, Oracle rolls back uncommitted transactions. Oracle uses two features, fast-start on-demand rollback and fast-start parallel rollback, to increase the effi

2015-02-10 14:36:23 712

转载 OERR: ORA-8103 "object no longer exists" Master Note / Troubleshooting, Diagnostic and Solution (Doc

In this Document Purpose Scope Details Description Cause Expected behavior. Block Corruption

2015-02-03 15:23:33 6566

原创 ORA-8103 "object no longer exists"错误

一：版本信息操作系统版本：AIX 61009 数据库版本：11.2.0.3.11(RAC) 二：错误描述今天研发过来说他们的过程报ORA-08103错误，我查了一下他们过程中用到的表，都是正常的！三：错误原因及解决方案 OERR: ORA-8103 "object no longer exists" Master Note / Tr

2015-02-03 15:17:03 21478 1