-
编辑 删除
reinstate database
DGMGRL> show configuration Configuration Name: DRMulti Enabled: &nbs...
-
编辑 删除
PSU 10.2.0.4.2
[oracle@hzshcnc OPatch]$ ./opatch -helpInvoking OPatch 10.2.0.4.2 [oracle@hzshcnc OPatch]$ unzip p6880880_102000_Linux-x86-64.zip [oracle@hzshcnc OPatch]$ ./opatch -helpInvoking OPatc...
-
编辑 删除
oracle patch category
Oracle Interim patches: A patch that is applied in between patchset releases with the Opatch utility. Interim patches are sometimes also referred to as patchset exceptions. Oracle Merge ...
-
编辑 删除
convert database
SQL> set serveroutput onSQL> declare 2 retcode boolean; 3 begin 4 &n...
-
编辑 删除
DG- log type and database role
Pri WEB> SELECT DEST_ID,VALID_TYPE,VALID_ROLE,VALID_NOW FROM V$ARCHIVE_DEST; DEST_ID VALID_TYPE VALID_ROLE VALID_NOW---------- ---------...
-
编辑 删除
flashback drop
SQL> CREATE TABLE CORUSER 2 ( &...
-
编辑 删除
RAC Parallel Compute Parameter
INSTANCE_GROUPS is a Real Application Clusters parameter that you can specify only in parallel mode. Used in conjunction with the PARALLEL_INSTANCE_GROUP parameter, it lets you restrict parallel quer...
-
编辑 删除
Orion
# ./orion_linux_x86 -run simpleORION: ORacle IO Numbers -- Version 11.1.0.7.0Test will take approximately 9 minutesLarger caches may take longer # vi orion_20091022_0316_summary.txtORION V...
-
编辑 删除
Standby is performing log apply
Performing Redo Apply SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY; PROCESS STATUS--------- ------------ARCH CLOSINGARCH &...
-
编辑 删除
Oracle_Architecture
-
编辑 删除
10g sga_target ? < sga_max
在11g 中，这个SGA_TARGET 只能设置是等于SGA_MAX_SIZE 的大小了，设置比它小，oracle 会自动帮你调整，设置比它大，那还是出错。现在可以自己想想，oracle 对SGA_TARGET 的大小处理在往正确的简单的方向前进中。...
-
编辑 删除
HA parameters
DB_BLOCK_CHECKING Oracle checks a block by going through the data in the block, making sure it is logically self-consistent. Block checking can often prevent memory and data corruption. Block c...
-
编辑 删除
Is there a server running on localhost:3306?
set password for <username>@<servername> = old_password('<password>');
-
编辑 删除
RAC Tips
# oifcfg getifeth0 10.224.188.0 global publiceth2 192.168.0.0 global cluster_interconnect # ocrdump -h ocrdump [<filename...
-
编辑 删除
srvctl -h
srvctl [-V]srvctl add database -d <name> -o <oracle_home> [-m <domain_name>] [-p <spfile>] [-A <name|ip>/netmask] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY}] [-s <start_options>] [-n <db_name...
-
编辑 删除
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))...
