OCM(四)

以此记录每一次OCM练习的过程，发现其中缺少的部分并补完。

新建redo文件

alter database add logfile
group 4 ('/u01/app/oracle/oradata/PROD1/disk1/redo04a.log','/u01/app/oracle/oradata/PROD1/disk2/redo04b.log') size 100m,
group 5 ('/u01/app/oracle/oradata/PROD1/disk1/redo05a.log','/u01/app/oracle/oradata/PROD1/disk2/redo05b.log') size 100m;

三份控制文件

sqlplus / as sysdba
alter system set control_files = '/u01/app/oracle/oradata/PROD1/control01.ctl','/u01/app/oracle/oradata/PROD1/control02.ctl','/u01/app/oracle/oradata/PROD1/control03.ctl' scope=spfile;
shutdown immediate
exit
--------------------------
cp /u01/app/oracle/oradata/PROD1/control01.ctl /u01/app/oracle/oradata/PROD1/control03.ctl
--------------------------
sqlplus / as sysdba
startup

收集统计信息

exec dbms_stats.gather_database_stats;
select username from sys.dba_users;
exec dbms_stats.gather_schema_stats('ORACLE_OCM');

设置UTL_FILE_DIR

show parameter utl_file_dir;
alter system set utl_file_dir = '/home/oracle','/home/oracle/temp','/home/oracle/scripts' scope=spfile;
shutdown immediate
startup

配置dNFS

需要两台机器

• 准备环境

110:
[root]# 
mkdir -p /u01/shared_mount
chmod -R 777 /u01/shared_mount
service nfs start
---------------------------
Starting NFS services:                                     [  OK  ]
Starting NFS quotas:                                       [  OK  ]
Starting NFS daemon:                                       [  OK  ]
Starting NFS mountd:                                       [  OK  ]
Stopping RPC idmapd:                                       [  OK  ]
Starting RPC idmapd:                                       [  OK  ]
---------------------------
vi /etc/exports
/u01/shared_mount   192.168.56.110(rw,sync)
---------------------------
exportfs -a
exportfs -v
---------------------------
/u01/shared_mount
        192.168.56.100(rw,wdelay,root_squash,no_subtree_check,anonuid=65534,anongid=65534)
---------------------------
100:
[root]# 
vi /etc/fstab
192.168.56.110:/u01/shared_mount        /nfsdir nfs     nolock          0 0
---------------------------
mount -t nfs 192.168.56.110:/u01/shared_mount /nfsdir
su - oracle
. oraenv
cd $ORACLE_HOME/dbs
vi orafstab
server:even
path:192.168.56.110
export:/u01/shared_mount mount:/nfsdir
---------------------------
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dnfs_on
sqlplus / as sysdba
shutdown immediate
startup
select * from v$dnfs_servers;
create tablespace dnfs_tbs datafile '/nfsdir/dnfs_tab01.dbf' size 5m;
select * from v$dnfs_servers;
---------------------------
    ID
----------
SVRNAME
----------------------------------------------------------------------------------------------------
DIRNAME
----------------------------------------------------------------------------------------------------
   MNTPORT    NFSPORT      WTMAX      RTMAX
---------- ---------- ---------- ----------
     1
192.168.56.110
/u01/shared_mount
       614   2049          0      0
---------------------------
drop tablespace dnfs_tbs including contents and datafiles;

后面还有最后一题安装Grid就结束考试的第一部分<数据库管理>了。