=====RAC(ASM)归档模式修改==============
1,设置归档路径
a、在asm中创建目录
(通过sqlplus修改,或ASMCMD)
export ORACLE_HOME=/oracle/app/crs/product/11.2/crs
export ORACLE_SID=+ASM1
export PATH=$ORACLE_HOME/bin:$PATH:.
[grid@tip01 ~]$ sqlplus / as sysasm
SQL> select name from v$asm_diskgroup;
SQL> alter diskgroup LIUQIDG add directory '+LIUQIDG/liuqi/arch';
b、到Oracle用户下:
SQL> alter system set log_archive_dest_1='location=+LIUQIDG/liuqi/arch' scope=spfile sid='*';
2,关闭所有数据库
$srvctl stop database -d liuqi
3,启动任意一个节点,使用SQLPLUS启动数库;
SQL>startup mount;
SQL>alter system set cluster_database=false scope=spfile sid='*';
SQL>alter database archivelog;--noarchivelog
SQL>alter database open;
SQL>archive log list;
4,将参数改回
SQL>alter system set cluster_database=true scope=spfile sid='*';
SQL>shutdown immediate;
5,启动数据库
$srvctl start database -d liuqi
SQL>archive log list;
注:10g R2之后切换到归档模式不再需要修改cluster_database参数。
1,设置归档路径
a、在asm中创建目录
(通过sqlplus修改,或ASMCMD)
export ORACLE_HOME=/oracle/app/crs/product/11.2/crs
export ORACLE_SID=+ASM1
export PATH=$ORACLE_HOME/bin:$PATH:.
[grid@tip01 ~]$ sqlplus / as sysasm
SQL> select name from v$asm_diskgroup;
SQL> alter diskgroup LIUQIDG add directory '+LIUQIDG/liuqi/arch';
b、到Oracle用户下:
SQL> alter system set log_archive_dest_1='location=+LIUQIDG/liuqi/arch' scope=spfile sid='*';
2,关闭所有数据库
$srvctl stop database -d liuqi
3,启动任意一个节点,使用SQLPLUS启动数库;
SQL>startup mount;
SQL>alter system set cluster_database=false scope=spfile sid='*';
SQL>alter database archivelog;--noarchivelog
SQL>alter database open;
SQL>archive log list;
4,将参数改回
SQL>alter system set cluster_database=true scope=spfile sid='*';
SQL>shutdown immediate;
5,启动数据库
$srvctl start database -d liuqi
SQL>archive log list;
注:10g R2之后切换到归档模式不再需要修改cluster_database参数。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27126919/viewspace-1101860/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27126919/viewspace-1101860/