-
编辑 删除
backup/restore pluggale database
Restore part PITR:Connect to CDB:ALTER pluggable database jackey close;run{set until scn xxx;restore pluggable database jackey;recover pluggable database jaceky}ALTER pluggable database jackey open resetlogs;
-
编辑 删除
compile invalid object
SQL> select owner, object_name,object_type from dba_objects where status ='INVALID'; OWNER--------------------------------------------------------------------------------OBJECT_NAME--------------------------------------------------------------------------------OBJECT_TYPE---------------------...
-
编辑 删除
RAC modify online redo log size
1.Add log fileSQL> alter database add logfile thread 1 group 7 ('+Q4DBFILE/ORADB/ONLINELOG/online7.dbf','+Q4DBFRA/ORADB/ONLINELOG/ronline7.dbf') size 500m reuse;SQL> alter database add logfile thread 1 group 8 ('+Q4DBFILE/ORADB/ONLINELOG/online8.dbf','+Q4DBFRA/ORADB/ONLINELOG/ronline8.dbf') size 5...
-
编辑 删除
xm relative command
xm block-list hostnameVdev BE handle state evt-ch ring-ref BE-path768 0 0 4 7 8 /local/domain/0/backend/vbd/18/768 51856 0 &...
-
编辑 删除
Single instance to RAC related
You can refer to http://www.linkedin.com/groups/How-will-you-convert-single-3156190.S.5875270675291217921?view=&item=5875270675291217921&type=member&gid=3156190&trk=eml-b2_anet_digest-null-2-null&fromEmail=fromEmail&ut=22vczqI8fclmg1 for detailed information.a. using dbca b. using EM&...
-
编辑 删除
CPU related information
/usr/sbin/psrinfo -p -vThe physical processor has 4 virtual processors (0-3) x86 (GenuineIntel 206D7 family 6 model 45 step 7 clock 2893 MHz) Intel(r) Xeon(r) CPU E5-2690 0 @ 2.90GHz
-
编辑 删除
Linux Profile order
shell分类：交互式登录shell：以一个用户的身份登陆进去，输入命令的格式的shell 读取配置文件的顺序： /etc/profile-->/etc/profile.d/*-->~/.bash_profile-->~/.bashrc-->/etc/bashrc 非交互式登录...
-
编辑 删除
solaris 11 x64 network configuration
# svcadm disable network/physical:nwam# svcadm enable network/physical:defaultdladm show-physLINK MEDIA &n...
-
编辑 删除
Linux common command
Find command related to mtime:find $HOME -mtime 0Search for files in your home directory which have been modified in the last twenty-four hours. This command works this way because the time since each file was last modified is divided by 24 hours and any remainder ...
-
编辑 删除
disable haip in oracle rac clusterware
Not useful. Just for Fun.Before root.sh, set following env:HAIP_UNSUPPORTEDORAfter root.sh, issue following command:crsctl modify res ora.cluster_interconnect.haip "ENABLED=0" -init Then you need to modify the ASM dependency. I believe the...
-
编辑 删除
system state dump when cannot connect to db instance
$ORACLE_HOME/bin/sqlplus /nologSQL> set _prelim onSQL> connect / as sysdbaPrelim connection establishedSQL> !ps -ef|grep pmon racusr2 16086 1 0 01:07 ? 00:00:00 ora_pmon_DB21...
-
编辑 删除
multicast for oracle rac clusterware part
11.2.0.2.0 need multicast enabled on 230.0.1.0 for private nic11.2.0.3.0 multicast is not a must for this version11.2.0...
-
编辑 删除
vimperator search hit Type Error: config.browser.getFindBar is not a function
Vimperator Type Error: config.browser.getFindBar is not a function
-
编辑 删除
Oracle RAC GNS 相关记录
$CRS_HOME/bin/cluvfy comp dhcp如果network是用dhcp分配地址的，这个check需要在network res offline的时候才可以使用。
