Oracle 10g R2 RAC数据库开归档

Oracle 10g R2 RAC数据库开归档

1.修改归档
create pfile='/Oracle/pfile0209.ora' from spfile;
srvctl stop database -d orcl

2.将/oracle/pfile.ora中的*.cluster_database的值改成false
startup mount pfile='/oracle/pfile0209.ora';
alter database archivelog;
alter database open;
shutdown immediate;

3.将*cluster_database 改成true,并增加归档位置
orcl1.log_archive_dest_1='location=/archive1'
orcl2.log_archive_dest_1='location=/archive2'
startup  pfile='/oracle/pfile0209.ora';
create spfile='/dev/rd314' from pfile='/oracle/pfile0209.ora';
shutdown immediate
srvctl start database -d orcl