-
编辑 删除
重建表时,遇到ORA-02449: 表中的唯一/主键被外键引用的处理办法
1.检查哪些表的外键引用了要删除的表的唯一/主键. select A.* from user_constraints A, user_constraints B &n...
-
编辑 删除
How to Recover Deleted Oracle Datafiles with No Downtime
So you have accidentally removed a datafile from your production database? First thing, DON’T PANIC! There’s an easy way to recover deleted datafiles, for as long as your database remains up. The pr...
-
编辑 删除
当前日志损坏的案例（蚂蚁）
[oracle@ts01 oracle]$ sqlplus ‘/ as sysdba’SQL*Plus: Release 9.2.0.4.0 - Production on Tue Nov 15 10:35:11 2005Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Connected to...
-
编辑 删除
RFS-process on physical standby database fails with Ora-00600:[Kcrrrfswda.9]
In this Document Symptoms Changes Cause Solution ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 11.1.0.6 and later ...
-
编辑 删除
Warning: OS async I/O limit 128 is lower than.. in Alert log
1. For more details about how to tune ASYNC I/O for Raw disk partitions on HP_UX kindly refer, Oracle Database Administrator's Reference 11g Release 1 (11.1) for Linux and UNIX-Based Operating Sy...
-
编辑 删除
Monitoring Open Cursors & Troubleshooting ORA-1000 Errors
In this Document Purpose Scope and Application Monitoring Open Cursors & Troubleshooting ORA-1000 Errors ReferencesApplies to: PL/SQL - Version: 10.2.0...
-
编辑 删除
ORA-00313, ORA-00312, ORA-27037 in Standby Database
ORA-00313, ORA-00312, ORA-27037 in Standby Database [ID 601835.1] 修改时间 20-APR-2009 类型 PROBLEM 状态 MODERATED In th...
-
编辑 删除
Archiving With Multiple Destinations Fails With ORA-16040
fact: Oracle Server - Enterprise Edition 9.0fact: Oracle Server - Enterprise Edition 8.1symptom: Archiving failssymptom: ORA-16040: standby destination archivelog file is lockedsymptom: Multiple a...
-
编辑 删除
Changing SYS passwd of PRIMARY db when STANDBY in place to avoid ORA-16191
In this Document Goal SolutionPlatforms: 1-914CU; This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been s...
-
编辑 删除
Two ORA-1031 Reported in Trace File of Primary in Dataguard Configuration
In this Document Symptoms Cause Solution ReferencesThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and ...
-
编辑 删除
LOG_ARCHIVE_DEST_2 Fails With ORA-1031 [ID 259142.1]
In this Document Symptoms Cause Solution ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.1.0.2 - Release: 10.1 to 10...
-
编辑 删除
Redo Corruption Errors During Redo Transport [ID 386417.1]
Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1.0 to 9.2.0.7.0This problem can occur on any platform.SymptomsWhen shipping redo to a standby database, the following errors are repo...
-
编辑 删除
在ORACLE中增进SCN及案例介绍
在oracle数据库中我们可以利用oracle的内部事件调整SCN。增进SCN通常有两种常用方法:1.alter session set events 'IMMEDIATE trace name ADJUST_SCN level x';--需要数据库OPEN2.通过10015事件alter session se...
-
编辑 删除
Resolving an ORA-600 [12700] error in Oracle 8 and above. (文档 ID 155933.1)
Checked for relevance on 19-Sep-2008Resolving an ORA-600 [12700] error in Oracle 8 and above~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~PURPOSE: &n...
