ITPub博客

Howto Recover a Linux Partition after a Superblock corruption?A SuperBlock in Linux saves information about the File System like, the File System type, size, status etc. A File system...

backup validate datafile 1;select * from v$database_block_corruption where file#=4;blockrecover datafile 4 block 35 from backupset;

-- 1. 检查损坏的对象 SELECT tablespace_name, segment_type, owner, segment_name             FROM dba_extents       &...

VNC缺省使用twm窗口管理器。如果用户想用KDE桌面环境，编辑$HOME/.vnc/xstartup文件，注掉除unset SESSION_MANAGER和exec /etc/X11/xinit/xinitrc以外所有的行。在这个文件的末尾添加一行：　　startkde & ...

1.首先应保证inetd守护进程是开启的，可输入#lssrc –s inetd查看    [root@HAN04UX] /home/root #lssrc -s inetd    Subsystem Group PID Status    inetd tcpip 184...

Step by Step Checklist1. Check if the GATHER_STATS_JOB exists in the database:SELECT object_id, object_name FROM dba_objects WHERE  object_type = 'JOB';The output should look like:OBJECT_ID&nbsp...

1 PowerDesigner中批量根据对象的name生成comment的脚本执行方法：Open PDM -- Tools -- Execute Commands -- Run ScriptOption Explicit   ValidationMode = True   InteractiveMode...

The System Information2006-10-31Author:Ecore1 HP-UX系统信息收集1.1 Cpu Infomation#sam //通过sam查看系统cpu,内存等信息SAM -->; Performance Monitors -->; System Properties# ioscan -fnC processor //...

/etc/cron.d/sysstat中 # run system activity accounting tool every 10 minutes */10 * * * * root /usr/lib64/sa/sa1 1 1 改为： # run system activity accounting tool every 10 minutes */1 * * * * root ...

AIX:   1,获得AIX主机连接的光纤设备:       # lsdev -Cc adapter -S a | grep fcs        fcs0     Availab...

【IT168信息化】数据集成是商业智能(BI)流程的关键组成部分，可将来自多个源系统的数据进行整合，并将它们合并到数据仓库以作分析。不过，对于BI数据集成策略，数据管理分析师提醒从业者不可掉以轻心;一旦设计执行不...

Check the status of the cluster[oracle@rac1 ~]$ crsctl check crsCRS-4638: Oracle High Availability Services is onlineCRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Ser...

Deprecated Subprograms or CommandsTable E-1 lists the commands that are deprecated in Oracle Clusterware 11g release 2 (11.2) and their replacements that you can use to perform. the same or ...

1 crsctl start/stop crs 是单节管理 crsctl start/stop cluster [-all 所有节点] 可以管理多个节点 2 crsctl start/stop crs 管理crs 包含进程 OHASD  crsctl start/stop cluster ...

--迁移voting盘检查crsctl query css votedisk（1）    两台机器停crs进程/sbin/init.d/init.crs stop（2）    备份voting盘dd if=/dev/rdisk/disk20f=/u01/app/oracle/vo...

在RAC中使用crs_stat -t时看到unknownoracle 高可用 2009-08-22 23:11:04 阅读35 评论0 字号：大中小 订阅 crs_stop -all 命令后遇到 UNKNOWN RAC中执行crs_stop -all后提示一些服务停不了，再用crs_stat -t查看状态的时候，停不掉的服务会显示状态是UNKNOWN， 服务在UNKNOWN状态下用 crs_start 不能启动服务 例如： [oracle@rac1 ~]$ crs_stop -all Attempting to stop `ora.rac1.gsd` on member `rac1` Attempting to stop `ora.rac1.ons` on member `rac1` Attempting to stop `ora.rac2.gsd` on member `rac2` Attemp

Select k.segname 对象名, k.userm 使用表空间, k.tablespace_name 表空间, k.segment_type 段类型/*, '0' || substr(to_char(k.userm / (Select Sum(bytes) / 1024 / 1024 userm From User_Extents)), 1, 5) 表空间使用率*/ from (Select Segment_Name segname, Sum(bytes) / 1024 / 1024 userm,t.tablespace_name,t.segment_type From dba_Extents t where t.owner in ('AA') /*and t.segment_type='TABLE'*/