ITPub博客

udevadm命令可以看到具体信息udevadm info --attribute-walk --name=/dev/sdaUDEV涉及的一些常见目录信息ll /sys/class/block/ll /dev/rawll /dev/mapperll /dev/blockll /dev/disk/by-pathll /dev/disk/by-idll /dev/disk/by-uuidUDEV规则的匹配字段属性ACTION        匹配事件的动作名...

wwid为3600c0ff0001001cd78cdaa4e02000000的分区1对应来对应/dev/udev1,分区2对应/dev/udev2,分区3对应/dev/udev3按分区来LINUX 5的/etc/udev/rules.d/99-oracle-asmdevices.rules配置(/block/$parent)KERNEL=="sda1", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -d /block/$parent", RESULT=="3600c0ff0001001cd78c...

Physical Standby Databases模式下，备库不是Real-Time Apply，也没建立任何standby redo log，备库failover后发现自动生成一个standby redo log一般归档日志的s都是1开始的，该standby redo log很奇怪，默认放在归档日志路径下，命名方式占用LOG_ARCHIVE_FORMAT中s为0的编号，具体如下/iso/db/oradata/TDB/archivelog/1_...

主库新增redo log(standby redo log亦如此)或删除redo log(standby redo log亦如此)，主库进行了归档，且归档日志同步到备库，且备库应用了归档日志，备库都不会显示已经新增或删除的redo log(standby redo log亦如此)说明：dataguard时，主库操作redo log或standby redo log的信息不会同步到备库当然备库不可以执行这...

Program global area (PGA)A PGA is a nonshared memory region that contains data and control information exclusively for use by an Oracle process. The PGA is created by Oracle Database when an Oracle process is started.One PGA exists for each server process and background process. The collection of ...

GRID能否安装 [grid@host]$./runcluvfy.sh stage -pre crsinst -n testdb01,testdb02 -fixup –verbose显示的结果如下 Pre-check for clusterservices setup was successful.  GRID是否已经正常安装 [grid@host]$./runcluvfy.shstage -post crsinst -n testdb01,testdb02 显示的...

源端环境版本11.2.0.4.0，字符集ZHS16GBK 目标端环境版本11.2.0.4.0，字符集AL32UTF8 HRMLOG.CLIENTADDRESS字段内容只有5个中文而已，没有制表符、换行符、回车符等特殊字符，目标端不存在该表的，源端直接expdp导出再impdp导入,理论上15个字节足够的，但是导入时报错实际为20字节，修改为40字节后，导入居然...

问题1：数据库不方便安装透明网关软件怎么办？解决方案：在其他数据库服务器上安装透明网关软件，再在本机上添加透明网关服务器的tns别名即可192.168.21.16不方便安装透明网关服务器，直接在一台虚拟机192.168.128.163上安装透明网关（指向IP为172.16.50.162端口为1433的RPT数据库），192.168.21.16新增指向192.168.128....

主库rman指定压缩备份RMAN>CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET;RMAN> show DEVICE TYPE;using target database control file instead of recovery catalogRMAN configuration parameters for database with db_unique_name MEDB are:CONFIGURE DEVICE TYPE DISK PARALLELI...

Deprecated Attributes for LOG_ARCHIVE_DEST_nLOG_ARCHIVE_DEST_n已弃用的属性，ARCH和LGWR已经被SYNC和ASYNC替代掉了The following attributes are deprecated for the LOG_ARCHIVE_DEST_n parameter. They are retained for backward compatibilityonly. In addition, note the following ...

This chapter provides reference information for the attributes of the LOG_ARCHIVE_DEST_n initialization parameter, where n is an integer between 1 and 31. The followinglist shows the attributes for the parameter:AFFIRM and NOAFFIRM■ ALTERNATE (not supported for LOG_ARCHIVE_DEST_11 through LOG_...

直接在linux上运行shell脚本时，oracle用户是有这个环境变量的。但是crontab运行时，是没有用户的环境变量，所以需要在脚本中设置。所以必须指定如下ORACLE_SID和ORACLE_HOME和PATH变量，否则会报错, 而有没有#!/bin/sh倒是没什么关系没有#!/bin/sh则按默认的默认shell中执行，查看默认的shell命令是 echo $SHELL...

oracle用户下crontab增加任务计划*/15 * * * *  /u01/app/scripts/remove_stdby_arch.sh 2>&1如下信息表示删除1小时以前的，已经通过RFS进程接受的并被recover的归档日志select max(completion_time)-1/24 from v\$archived_log where sequence# is NOT NULL and applied='YES' and registrar ='RFS'脚本名...

VALID_FOR=(redo_log_type, database_role)Identifies when redo transport services can transmit redo data to destinations based on the following factors:– redo_log_type—whether online redo log files, standby redo log files, or both are currently being archived on the database at this dest...

00 8 * * * su - oracle -c "find /wfdb/db/diag/rdbms/wf/WF/alert -type f -mtime +10 -exec rm -rvf {} \;"00 8 * * * su - oracle -c "find /wfdb/db/diag/rdbms/wf/WF/trace -type f -mtime +10 -exec rm -rvf {} \;"10 8 * * * su - oracle -c "find /wfdb/db/diag/tnslsnr/wfdb/listener/alert -type f -mtime +10...

1.    先创建一个SEND_EMAIL存储过程create or replace PROCEDURE SEND_EMAIL (p_From IN VARCHAR2 :='mdssysmail@mic.com.tw',p_To IN VARCHAR2,p_Subject IN VARCHAR2,p_Body IN VARCHAR2,p_Cc IN VARCHAR2 := NULL,p_Bcc IN VARCHAR2 := NULL,p_ContentType IN VARCHAR2 := 'text/plain;char...

linux 5环境下1.解压安装邮件软件http://downloads.sourceforge.net/heirloom/mailx-12.4.tar.bz21.# tar jxvf mailx-12.4.tar.bz2  2.# cd mailx-12.4  3.# make  4.# make install UCBINSTALL=/usr/bin/install  2.配置邮件软件在/etc/nail.rc最后几行加上如下信息# vi /etc/nail.rc*...

CREATE OR REPLACE procedure SYSTEM.sp_asm_check asx number;v_html varchar2(30000);beginselect min(round((free_mb/total_mb)*100)) into x  from gv$asm_diskgroup;if x<30 then      v_html:='<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xht...

create or replace procedure sp_job_check asv_counter number;v_html varchar2(30000);beginselect max(failures) into v_counter from dba_jobs;if v_counter>0 then      v_html:='<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-tran...

create or replace procedure sp_scheduler_check asx number;beginselect round((select (sysdate-(select to_date((select * from (select to_char(log_date,'YYYY-MM-DD HH24:MI:SS') from user_scheduler_job_run_details where job_name='XXX' order by log_id desc) where rownum<2),'YYYY-MM-DD HH24:MI:SS') fro...