ITPub博客

 1. Create pfile of lost database , from database alert.log startup messages.2. Startup database in nomount3. Get the controlfile number from db alert log , it will show while starting the database here in this eg. its 256eg., control_files='+DATA/orcl/controlfile/current.256.709676643'I...

KFOD KFOD 可以从系统级别发现ASM实例 及查看磁盘信息[grid@oracle10g~]$ kfod -help_asm_a/llow_only_raw_disks              KFOD allow only raw devices[_asm_allow_only_raw_disks=TRUE/(FALSE)]...

Flashback database  相关参数1  db_recovery_file_dest：指定闪回恢复区的位置2 db_recovery_file_dest_size：指定闪回恢复区的可用空间大小3 db_flashback_retention_target：指定数据库可以回退的时间，单位为分钟闪回日志保留策略1 如果闪回恢复区足够...

ORA-1122:database file %s failed verification checkORA-1110 : datafile : ORA-1207: ORA 1207 file is more recent thancontrol file 该错误表明:数据文件头部信息与控制文件信息部一致,数据文件头部CHECKPOINT大于controlfileCHECKPOINT,需要重建控制文件...

Disk groups specified in the ASM_DISKGROUPS initialization parameterDisk group used by Cluster Synchronization Services (CSS) for voting filesDisk groups used by Oracle Clusterware for Oracle Cluster Registry (OCR)Disk group used by th...

1.      Export/ Import

配置ORACLE RAC 由于盘符不一致造成失败是最常见的故障之一,所以在准备阶段检测各个节点的相同盘符对应的是不是同一个lun就是必须的一个步骤,判断是否是同一个的方法就是查询lun id 或wwid进行对比,以下总结了各种系统下查询lun ID的方法AIX方式一:# lscfg-l hdisk*   hdisk2  &nb...

Dead connections  ,但是进程再服务断依然在服务器断运行:(如防火墙Dead Connections,需要开启DCD 开启后(SQL*NET)会定期发送一个探测包到客户端,这个包将被丢弃,服务端会受到一个错误 开启sqlnet.ora文件中添加SQLNET.EXPIRE_TIME = 10INACTIVE Sessions保持连接并且进程状态是INACTIVE...

global cache cr request/gc current requestThe session is waiting for all pending lock operations on the lock elements (le) attached to a lock context to complete. The session sits in a loop until all requests are complete, and this wait event is effectively a poll interval while waiting.The event ...

临时表空间使用情况 A.tablespace_name , D.mb_total, (A.used_blocks * D.block_size) / / mb_used,SUM10241024FROM( B.name, C.block_size, (C.BYTES) / / mb_total v$tablespace B, v$tempfile C B.ts#= C.ts# B.name, C.block_size...

1.      最新OPatch下载地址https://updates.oracle.com/download/6880880.html2.      安装grid@node1~]$ /u01/app/11.2.0/grid/OPatch/opatch -helpInvokingOPatch 11.1.0.6.6 OracleInterim Patch Ins...

ADRCI 作用 ADR中的诊断数据2 查看Oracle Support诊断信息包含: incident ， problem， tracefiles, dumps, health monitor reports等帮助,展示adrci相关命令adrci>help  HELP [topic]   Available Topics:  &nbs...