Oracle 10g r2 rac + ASM 修改为归档状态

Oracle 10g r2 rac数据库修改归档到ASM

1，asm上创建相关空间目录
export ORACLE_SID=+ASM1
asmcmd
mkdir arch1 arch2

ASMCMD> pwd
+DATA/RACDB/archive
ASMCMD> ls
arch1/
arch2/
ASMCMD>

2，mount状态下，在一个节点修改

[oracle@rac1 software]$ export ORACLE_SID=racdb1
[oracle@rac1 software]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 30 10:21:41 2010

Copyright （c） 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 209715200 bytes
Fixed Size                  1218556 bytes
Variable Size             100665348 bytes
Database Buffers          104857600 bytes
Redo Buffers                2973696 bytes
Database mounted.
SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/app/oracle/product/10.2.0/db_1/dbs/arch
Oldest online log sequence     14
Current log sequence           15
SQL> alter system set log_archive_dest_1="LOCATION=+DATA/RACDB/archive/arch1" sid="racdb1";

System altered.

SQL> alter system set log_archive_dest_1="LOCATION=+DATA/RACDB/archive/arch2" sid="racdb2";

System altered.

SQL> show parameter cluster_database

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cluster_database                     boolean     TRUE
cluster_database_instances           integer     2

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +DATA/racdb/archive/arch1
Oldest online log sequence     14
Next log sequence to archive   15
Current log sequence           15
SQL> exit

3,启动另一个节点
[oracle@rac1 software]$ crs_start ora.racdb.racdb2.inst
Attempting to start `ora.racdb.racdb2.inst` on member `rac2`
Start of `ora.racdb.racdb2.inst` on member `rac2` succeeded.

4，验证是否成功
node2执行

SQL> alter system archive log current;

System altered.

[oracle@rac2 ~]$ export ORACLE_SID=+ASM2
[oracle@rac2 ~]$ asmcmd
ASMCMD> ls
DATA/
ASMCMD> cd +DATA/racdb/archive/arch2
ASMCMD> ls
2_7_738946915.dbf修改ASM磁盘的启动权限修改Oracle日志文件大小相关资讯 Oracle基础教程

Oracle块编程返回结果集详解（11/10/2013 10:45:58）
Oracle基础教程之设置系统全局区（08/22/2013 14:24:00）
Oracle基础教程知识点总结（06/18/2013 07:43:32）

Oracle基础教程之tkprof程序详解（10/22/2013 11:49:50）
Oracle基础教程之sqlplus汉字乱码（07/18/2013 16:30:00）
Oracle 管理之 Linux 网络基础（02/16/2013 18:37:35）

本文评论查看全部评论（0）