自定义rac归档模式设置与操作

[oracle@SPICTDB2]/oradata2/osw/tmp$UNIX95= ps -e -o "pid,pcpu,vsz,args" |grep OSW |grep -v grep
28524  0.00     604 /usr/bin/ksh ./OSWatcherFM.sh 48
28432  0.30     620 /usr/bin/ksh ./OSWatcher.sh 3 48
[oracle@SPICTDB2]/oradata2/osw/tmp$UNIX95= ps -e -o "pid,pcpu,vsz,args" |grep osw |grep -v grep
 7134  0.00     528 /usr/bin/ksh ./oswsub.sh archive/oswiostat/SPICTDB2_iostat_11.04.17.1900.dat iostat 1 3
 7129  0.00     528 /usr/bin/ksh ./oswsub.sh archive/oswvmstat/SPICTDB2_vmstat_11.04.17.1900.dat vmstat 1 3
 7130  0.00     528 /usr/bin/ksh ./oswsub.sh archive/oswmpstat/SPICTDB2_mpstat_11.04.17.1900.dat sar -A -S 1 3
 7037  0.00    1064 top -d 1 -f archive/oswtop/SPICTDB2_top_11.04.17.1900.dat
 7135  0.00    1064 top -d 1 -f archive/oswtop/SPICTDB2_top_11.04.17.1900.dat
[oracle@SPICTDB2]/oradata2/osw/tmp$

1、更改参数

   保证在两个节点分别存在以下目录，D:\arch1, D:\arch2  这两个目录可以根据需要改为其他目录

   在A节点以sys用户执行
   alter system set cluster_database=false scope=spfile sid='*';
   alter system set log_archive_dest_1='LOCATION=D:\arch1' scope=spfile;
   在B节点以sys用户执行
   alter system set log_archive_dest_1='LOCATION=D:\arch2' scope=spfile;

2、关闭数据库，分别在两个节点执行
   shutdown immediate


3、在A节点以sys用户执行
  3.1、启动数据库到加载状态(mount)
sqlplus /nolog
sql>connect /as sysdba
sql>startup mount