-
编辑 删除
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...
-
编辑 删除
Stream objects
Streams配置和管理相关packagedbms_steams_admdbms_capture_admdbms_propagation_admdbms_apply_admdbms_rule_admStreams主要相关数据字典dba_streams_administratordba_capturedba_capture_parametersdba_prop...
-
编辑 删除
2 listeners are serving for 1 instance .
1, netca .2, vi /home/oracle/OraBase/OraHome1/network/admin/tnsnames.oraLISTENERS_MAMBO = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hzdevdb1.mambo....
-
编辑 删除
ORA-27102: out of memory
Causeshmall is the total amount of shared memory, in pages, that the system can use at one time. SolutionSet shmall equal to the sum of all the SGAs on the system, divided by the...
-
编辑 删除
Stream alter parameter
AQ_TM_PROCESSESProperty DescriptionParameter type IntegerDefault value 0Modifiable ALTER SYSTEMRange of values 0 to 10Basic NoAQ_TM_PROCESSES enables time monitoring of queue messages. The tim...
-
编辑 删除
ORA-27054
Solution1) The problem can be solved by using the recommended mounting options which are: (hard,bg,proto=tcp,suid,rsize=32768,wsize=32768,noac)* Note that this list of options is not exhaustive, a...
