郭一军，网名guoyJoe，尖峰在线培训创始人、Oracle OCM、ITPUB论坛Oracle认证版版主、2013最佳精华贴、Senior DBA、Oracle OCT、 ACOUG MEMBER、CSDN 认证专家、RHCE、在线技术分享的倡导者和实践者。 http://www.jianfengedu.com http://jianfengedu.taobao.com
全部博文（72）
发布时间：2014-06-20 16:44:35
BASE的计算方法为：对于ASSM：76+（itc-1) * 24= 52 + itc * 24对于MSSM：68+（itc-1) * 24= 44 + itc * 24点击(此处)折叠或打开gyj@ZMDB> select * from v$type_size where component in ('KCB','KTB');COMPONEN TYPE DESCRIPTION TYPE_SIZE----.........【阅读全文】
发布时间：2014-06-19 10:39:02
转载请注明出处：http://blog.csdn.net/guoyjoe/article/details/30839817##########恢复前的准备工作 1丶做个热备 select \'alter tablespace \'||tablespace_name|| \' begin backup;\' ||chr(10)|| \'host cp \'||file_name||\' /backup\' ||chr(10)|| \'alter tablespace \'||tablespace_name|| \' end backup;\' from dba_data_files order by tablespace_name; sys@PROD> alter tablespace SYSAUX begin backup;host cp /u01/app/oracle/oradata/PROD/sysaux01.dbf /backupalter t......【阅读全文】
发布时间：2014-06-19 10:39:02
转载请注明出处 http://blog.csdn.net/guoyjoe/article/details/30965303 实验步骤如下：1丶使用rman备份全库Recovery Manager: Release 11.2.0.3.0 - Production on Sun Jun 8 15:30:35 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: PROD (DBID=254815294) RMAN> backup database; Starting backup at 08-JUN-14 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 chann......【阅读全文】
发布时间：2014-06-19 10:39:02
转载请注明出处：http://blog.csdn.net/guoyjoe/article/details/31018075@@@@@@@利用BBED模拟损坏5文件1号块（文件头）BBED> copy file 4 block 4 to file 5 block 1 File: /u01/app/oracle/oradata/PROD/tp01.dbf (5) Block: 1 Offsets: 0 to 19 Dba:0x01400001 ------------------------------------------------------------------------ 1ea20000 04000001 1a4b0000 00000104 99810000 <32 bytes per line> sys@PROD> shutdown abort; ORACLE instance ......【阅读全文】
发布时间：2014-06-19 10:39:01
转载请注明出处：http://blog.csdn.net/guoyjoe/article/details/206475531丶配置安装VNC[root@guodb2 Disk1]# yum install vnc*2丶设VNC密码[root@guodb2 Disk1]# vncserverYou will require a password to access your desktops.Password:Verify:New \'guodb2:1 (root)\' desktop is guodb2:1Creating default startup script /root/.vnc/xstartupStarting applications specified in /root/.vnc/xstartupLog file is /root/.vnc/guodb2:1.log3丶重新启动VNC服务[root@guodb2 Disk1]# service vncserver stopSh......【阅读全文】
