ITPub博客

以前都是通过把主机移出storage group，然后再移进来，做这个操作需要系统停机。通过与EMC交流，EMC称LUNZ的盘为鬼盘，这种盘在系统里看不再是数据盘，可以删除再重新认。>#lsdev -Cc disk |grep LUNZhdisk4 Defined 05-08-01 EMC CLARiiON FCP LUNZ Diskhdisk5 Defined 06-08-01 EMC CLARiiON FCP LUNZ Diskhdisk66 Defined 05-08-01 EMC CLARiiON FCP LUNZ Diskhdisk67 Defined 05-08-01 EMC CLARiiON FCP LUNZ Diskhdisk68 Defined 05-08-01 EMC CLARiiON FCP LUNZ Diskhdisk69 Defined 05-08-01 EMC CLARiiON FCP LUNZ Diskhdisk70

1、在A机ssh-keygen -t rsa 或 ssh-keygen -d (dsa) => 產生出 id_rsa, id_rsa.pub scp id_rsa.pub remote_hostname:~/.ssh/ 2、ssh root@remote_host 'cat>> /home/oracle/.ssh/authorized_keys '</home/oracle/.ssh/id_rsa.pub或在B机cat .ssh/id_rsa.pub >> .ssh/authorized_keys这样就可以在 A机 ssh 到B机，免密码登录。[@more@]

差点丢失数据的RMAN 恢复，最后用隐藏参数打开。Oracle Error: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error belowORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/u01/oracle/oradata/dbc/data1/system01.dbf'RMAN-00571: ===============================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS RMAN-00571: =================================================RMAN-03002: failure of recover command at 04/02/2009

说一下过程及遇到的问题[@more@] recover databasealter database open upgrade@?/rdbms/admin/utlirp.sql //数据位数不一样升级数据字典SPOOL /home/oracle/upgrade.log@?/rdbms/admin/catupgrd.sqlSPOOL off@?/rdbms/admin/utlrp.sql //重编译对象检查升级后各组件状态@?/rdbms/admin/utlu102s.sql检查dba_registrycol comp_name for a30select comp_name,version,status from dba_registry;如果utlu102s.sql的结果与dba_registry冲突，则以dba_registry结果为准检查invalid对象col object_name format a32select owner,object_name f

Subject: Receiving error Ora-27054 When Running Rman With NFSDoc ID: 424785.1[@more@]CauseImproper NFS mount options are used. This behaviour has been observed on Solaris Linux and AIX Platforms.Bug 5146667 ORA-27054 ERRORS WHEN RUNNING RMAN WITH NFS SolutionWorkarounds:*.event='10298 trace name context forever, level 32'- Use the event 10298 (It can have a side effect of disabling direct IO on RAC using regular files on NFS mounts) Reference : Note 387700.1 ORA-27054 ERRORS WHEN RUNNING RMAN WI

-- 确定角色的权限select * from role_tab_privs ; 数据字典视图包含了授予角色的对象权限select * from role_role_privs ; 包含了授予另一角色的角色select * from role_sys_privs ; 包含了授予角色的系统权限-- 确定用户帐户所授予的权限select * from DBA_tab_privs ; 直接授予用户帐户的对象权限select * from DBA_role_privs ; 授予用户帐户的角色select * from DBA_sys_privs ; 授予用户帐户的系统权限查看当前用户权限:[@more@]http://blog.ixpub.net/html/62/8026162-375749.html-- 确定角色的权限

备份对于一个系统管理员来讲非常重要，有效的备份不是万能的，但没有备份是万万不可的。因此对系统的备份是系统管理员经常要做的事情, 主要包括rootvg备份和用户数据备份.如果一个系统没有相应的备份，无异于等死。[@more@]AIX操作系统下的用磁带进行备份操作步骤:将一盘新磁带或无用磁带插入磁带机 　　#tctl -f /dev/rmt0 rewind （重绕磁带设备）1,系统备份　　#smit mksysb Backup DEVICE or FILE [ /dev/rmt0] Create MAP files? no EXCLUDE files