-
编辑 删除
srvctl service
# srvctl status service -d webdbService hzwebtaf is running on instance(s) webdb2, webdb1 # srvctl config service -d webdb -ahzwebtaf PREF: webdb2 webdb1 AVAIL: TAF: basic # sr...
-
编辑 删除
Customizing How Oracle Clusterware Manages Oracle RAC Databases
To prevent Oracle Clusterware from restarting your Oracle RAC database when you restart your system, or to avoid restarting failed instances more than once, configure a policy to define the degree of ...
-
编辑 删除
CRS diagwait
This setting increases the time for failed nodes to flush final trace files, which helps to debug the cause of a node failure. 1. Execute as root #crsctl stop crs #<CRS_HOME>/bin/oprocd s...
-
编辑 删除
Extend nodes Tips
The following sections provide a summary of the command line procedures for deployments of RAC in grid environments with large numbers of nodes using cloned Clusterware and RAC images: Cloning...
-
编辑 删除
TAF
HZWEBTAF = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.224.183.142)(PORT = 1522)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.224.183.144)(PORT = 1522))...
-
编辑 删除
Backup and restore voting disk and OCR
Backing Up Voting Disks ■ After installation■ After adding nodes to or deleting nodes from the cluster■ After performing voting disk add or delete operations dd if=voting_disk_name...
-
编辑 删除
Parameters for an Oracle RAC Database
Parameters that Must Have Identical Settings on All Instances ACTIVE_INSTANCE_COUNTARCHIVE_LAG_TARGETCLUSTER_DATABASECLUSTER_DATABASE_INSTANCESCOMPATIBLECONTROL_FILESDB_BLOCK_SIZED...
-
编辑 删除
Performance monitor
[root@hzdcdb /]# vmstat 1procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------ r b swpd free buff cache ...
-
编辑 删除
Netapp_linux_host_utilities_3_2
-
编辑 删除
Real Application Testing
Step1 Enabling and Disabling Workload CaptureSQL> @$ORACLE_HOME/rdbms/admin/wrrenbl.sql SQL> SET FEEDBACK 1SQL> SET NUMWIDTH 10SQL> SET LINESIZE 80SQL> SET TRIMSPOOL ONSQL> SET TAB OFFSQL> SET ...
-
编辑 删除
OVM tips
– Server Pool Master functionThe Server Pool Master is the core of the server pool operations. It acts as the contact point of the server pool to the outside world, and also as the dispatcher to ot...
-
编辑 删除
tightvnc-java-1.3.9-3.noarch.rpm
A keystore file is created during the installation, even if you do not select SSL during the installation. # sh /opt/ovs-manager-2.1/bin/secure_ws.sh pass password
-
编辑 删除
Linux Tips
<STYLE. -- {page:Section1;} div.Section1 mso-paper-source:0;} mso-footer-margin:36.0pt; mso-header-margin:36.0pt; 90.0pt; 72.0pt 90.0pt margin:72.0pt 792.0pt; {size:612.0pt Section1 @page mso-page-bo...
-
编辑 删除
DG tips
############################# switchover ###############################sql> select database_role ,open_mode,protection_mode,protection_level,switchover_status from v$database;sql> alter d...
-
编辑 删除
PDG
################################## on primary db ######################################[oracle@hzdevdb1 dbs]$ ll $oracle_home/dbs/orapwcfgdb-rw-r----- 1 oracle dba 1536 jul 13 06:27 ...
-
编辑 删除
RMAN cases
RMAN> backup database plus archivelog;$ scp * hzdevdb2:/home/oracle/OraBase/flash_recovery_area/CFGDB/backupset/2009_07_24 $ export ORACLE_SID=cfgdb$ rman target /RMAN> set dbid 359504372RM...
-
编辑 删除
RMAN recover
各种故障背景下的恢复方法 丢失或损坏的文件 归档模式 数据库状态 恢复方法 一个或多个数据文件 不归档模式 关闭状态 利用一致的完全数据库备份修复整个数据库，自从备份之后发生的所有修改...
-
编辑 删除
RMAN tips
RMAN>LIST COPY OF TABLESPACE 'SYSTEM'; RMAN>LIST BACKUP OF TABLESPACE 'SYSTEM' ; RMAN>DELETE OBSOLETE ; RMAN>DELETE EXPIRED BACKUP; RMAN>DELETE EXPIRED COPY ; RMAN>DELETE BACKUPSET 19 ; RMAN>DELETE BA...
-
编辑 删除
rlwrap
alias sqlplus='rlwrap sqlplus'alias rman='rlwrap rman'
-
编辑 删除
oracle auto startup and shutdown script
[root@hzdevdb2 OraHome1]# vi /etc/init.d/oracle #!/bin/sh# chkconfig: 345 85 15# description: This service is for oracle startup and shutdown.ORACLE_HOME=/home/oracle/OraBase/OraHome1ORACLE=oracle...
