ITPub博客

今天发现一个生产库侦听HANG ps 发现有两个侦听进程[oracle@centosdb ~]$ ps -ef | grep LISoracle    6235 32390  0 01:32 ?        00:00:00 /u01/app/oracle/oracle/product/...

ORA-7445 [kpodpals] During DataPump Import [ID 1096837.1]Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.1 - Release: 10.2 to 11.2Information in this document applies to an...

检查Standby数据库上是否归档有被应用： 在standby 上查看   select process,status fromv$managed_standby;       是否出现mrp进程 SQL> select proce...

 Modified 12-AUG-2009     Type HOWTO     Status REVIEWED In this Document  Goal  SolutionApplies to:Oracl...

【转载地址】:http://blog.csdn.net/tianlesoftware/article/details/6194498 Oracle Data Guard 是通过归档文件来进行数据同步的。 主库的归档文件，我们可以在RMAN 备份的时候进行删除，但是...

【转载david的一片文章】:http://blog.csdn.net/tianlesoftware/article/details/6227965   对于Oracle Data Guard 的Maximum Availability和 Maximum Performance 两种模式下的主库归档文...

Applies to:Oracle Server - Enterprise Edition - Version 10.2.0.1 to 11.2.0.2 [Release 10.2 to 11.2]Information in this document applies to any platform.Checked for relevance on 21-Sep-2012SymptomsORA-...

DATA GUARD 跨平台支持列表PLATFORM_IDPLATFORM_NAMERelease namePLATFORM_IDs supported within the same Data Guard configuration when using Data Guard Redo Apply (Physical Standby)2Solaris...

转载地址:http://www.dba-oracle.com/t_alter_system_switch_logfile_vs_alter_system_archivelog_current.htmQuestion:  I understand that there are times that you need to force a log switch for ba...

普通的RMAN DUPLICATE/RESTORE/RECOVER(非convert database 方式)  对平台有一定的要求:具体见上一篇博客:http://space.itpub.net/15747463/viewspace-758172对于不满足以上要求的需要使用CONVERT DATABASE 进...

RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform. Support [ID 1079563.1]Applies to:Oracle Server - Enterprise Edition - Version 10.2.0.1 and laterInformation in this document applies to a...

How to Migrate to different Endian Platform. Using Transportable Tablespaces With RMAN [ID 371556.1]GoalStarting with Oracle Database 10g, you can transport tablespaces across platform...

Cross-Platform. Database Migration (across same endian) using RMAN Transportable Database [ID 1401921.1]Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.2.0.3 [Release ...

第一步:调整主库LOG_ARCHIVE_DEST_n参数各个模式的最低要求 Maximum Protection Maximum Availability Maximum Performance Redo archival process...

[ID 969002.1]Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.0. - Release: 10.2 to 11.2Information in this document applies to any platform.This applies to 10.2 to 11.2 phy...

等待时间描述:  Waiting for a log switch because thesession cannot wrap into the next log. Wrapping cannot be performed because thecheckpoint for that log has not completed.当你的日志组...

等待时间描述:     这个等待事件发生时，当我们试图访问一个缓冲区高速缓存中的缓冲区，但我们发现该缓冲区目前正在由其他用户读取磁盘，所以我们需要等待完成之前，我们可以访问它。在以前的版...

转载地址:http://blog.csdn.net/wyzxg/article/details/6864045author：skatetime：2011/09/29db_writer_processes 和 dbwr_io_slaves对比 在计算机世界里，磁盘的发展速度远低于cpu，memory。磁盘io现在已经成...

1.安装好Oracle数据库后: 执行 dbstart和dbshut会提示：[oracle@oracle11g ~]$ dbstartFailed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnrProcessing Database instance "test": ...

　　一、打开ASM实例　　[oracle@ASM ~]$ echo $ORACLE_SID　　+ASM　　[oracle@ASM ~]$ sqlplus /nolog　　SQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 6 01:01:28 2009　　Copyright (c) 1982, 2005, O...