目的:把归档模式打开并且将日志放在共享存储(ASM)上
环境信息:RHEL5.5,Oracle11gR2
主机名:rac1,rac2
实例名:orcl1,orcl2
1、在ASM下创建归档目录
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
cdMOUNTED EXTERN N 512 4096 1048576 20480 18143 0 18143 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 10240 9910 0 9910 0 N FLASH/
MOUNTED NORMAL N 512 4096 1048576 3072 2146 1024 561 0 Y OCR
ASMCMD> cd DATA/orcl
ASMCMD> mkdir ARCH
ASMCMD> ls
ARCH/
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
TEMPFILE/
修改归档路径
[oracle@rac1 ~]$ sqlplus / as sysdba SQL> alter system set log_archive_dest_1='location=+DATA/ORCL/ARCH' scope=spfile sid='*';
System altered.
关闭数据库
srvctl stop database -d orcl
检查资源状态
crsctl stat res -t
将一个节点数据库启动到mount状态
srvctl start instance -d orcl -i orcl1 -o mount
修改数据库的归档模式并启动数据库
alter database archivelog;
alter database open;
检查归档信息
archive log list
开启另外一个数据库节点
srvctl start instance -d orcl -i orcl2
检查资源状态
crsctl stat res -t
环境信息:RHEL5.5,Oracle11gR2
主机名:rac1,rac2
实例名:orcl1,orcl2
1、在ASM下创建归档目录
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
cdMOUNTED EXTERN N 512 4096 1048576 20480 18143 0 18143 0 N DATA/
MOUNTED EXTERN N 512 4096 1048576 10240 9910 0 9910 0 N FLASH/
MOUNTED NORMAL N 512 4096 1048576 3072 2146 1024 561 0 Y OCR
ASMCMD> cd DATA/orcl
ASMCMD> mkdir ARCH
ASMCMD> ls
ARCH/
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
TEMPFILE/
修改归档路径
[oracle@rac1 ~]$ sqlplus / as sysdba SQL> alter system set log_archive_dest_1='location=+DATA/ORCL/ARCH' scope=spfile sid='*';
System altered.
关闭数据库
srvctl stop database -d orcl
检查资源状态
crsctl stat res -t
将一个节点数据库启动到mount状态
srvctl start instance -d orcl -i orcl1 -o mount
修改数据库的归档模式并启动数据库
alter database archivelog;
alter database open;
检查归档信息
archive log list
开启另外一个数据库节点
srvctl start instance -d orcl -i orcl2
检查资源状态
crsctl stat res -t
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29108856/viewspace-2144894/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29108856/viewspace-2144894/