【识记】spfile迁往共享存储，关闭审计，开启归档日志和查看休息连接数等2013.4.27

(1)对于HA或者RAC的oracle,有时候需要把spfile放在共享存储上.
cd $ORACLE_HOME/dbs 建立一个initUID.ora,里面添加一条记录指向共享存储的spfile,例如:
spfile="/data/oradata/udb/spfile/spfileudb.ora"
删除$ORACLE_HOME/dbs下的spfile.

(2)oracle11g 默认打开了oracle的审计,可以将oracle的审计关闭.
alter system set audit_trail='NONE' scope=spfile;

SQL> alter system set audit_trail = none scope=spfile;
System altered.
SQL> show parameter audit
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /opt/oracle/admin/udb/adump
audit_sys_operations                 boolean     FALSE
audit_syslog_level                   string
audit_trail                          string      DB
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size                  2213776 bytes
Variable Size             402655344 bytes
Database Buffers         1157627904 bytes
Redo Buffers               40914944 bytes
Database mounted.
Database opened.
SQL> show parameter audit;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /opt/oracle/admin/udb/adump
audit_sys_operations            boolean     FALSE
audit_syslog_level                 string
audit_trail                             string      NONE 

(3)开启与关闭归档日志:
开启:
sql>shutdown immediate;
sql>startup mount;
sql>alter database archivelog;
sql>alter database open;
sql>alter system set log_archive_dest_1='location=/orashare/archivelog' scope=spfile;
sql>shutdown immediate;
sql>startup;
sql>archive log list;
sql>alter system switch logfile;

关闭:
sql>shutdown immediate;
sql>startup mount;
sql>alter database noarchivelog;
sql>alter database open;
sql>archive log list;

(4)查询系统连接数
a.查询目前连接数
  show parameter processes;
b.更改系统连接数
  alter system set processes=1000 scope=spfile;
c.重启Oracle服务或重启Oracle服务器

(5)Oracle RAC 开启归档日志

1.关闭所有节点数据库实例(grid账号)

srvctl stop database -d udb

2.修改服务器配置参数(oracle账号)
节点1:
startup mount;
alter system set log_archive_dest_1='location=+RECOVERY/UDB/arch' scope=spfile sid='udb1';
alter system set log_archive_dest_1='location=+RECOVERY/UDB/arch' scope=spfile sid='udb2';
alter database archivelog ;
alter database open;
archive log list;
shutdown immediate;

srvctl start database -d udb (grid账号)

3.测试归档日志的切换
节点1：
alter system switch logfile;
show parameter archive_dest;
节点2：
alter system switch logfile;
show parameter archive_dest;