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
分享到:
相关推荐
[RAC+DataGuard]Oracle RAC 10g R2RAC+ASM+DataGuard容灾配置手册_精华_PDF
Windows Server 2012 R2 X64环境下搭建Oracle 11G R2 RAC+ASM,文档目录清晰,需要的拿去。
利用StarWind在Windows 2008 R2环境下安装Oracle 11G R2 RAC+ASM.doc
Windows_2008_R2环境下的Oracle_11G_R2_RAC+ASM实验室环境安装指南V1.0,参考价值非常大
实战完美搭建Oracle 11gR2_RAC+ASM+DG(最新精编版)
完整搭建Oracle 11gR2_RAC+ASM+DG ,满满的都是干货。。。
ORACLE10r2+RAC+ASM ORACLE10r2+RAC+ASM ORACLE10r2+RAC+ASM
Oracle10g(RAC+ASM)6810189升级过程
Windows_2008_R2环境下的Oracle_11G_R2_RAC+ASM实验室环境安装指南V1.0.doc
AIX6.1+oracle 10g RAC+ASM
Oracle 11g R2 RAC + DG高端实战[黄伟-专题],超详细,超经典的实例过程文档,绝对有帮助。出自播布客-黄伟老师的作品(花钱购买的哦,现在奉献给大家)
Oracle10g rac+asm 原库备份与恢复 .docx Oracle10g rac+asm 原库备份与恢复 .docx
Windows_2008_R2下Oracle_11G_R2_RAC+ASM安装指南
Oracle_11g_R2_RAC+ASM
发现网上相关文章很多但是不是很专,因此细化版本为了使文档更加实用。 这次搭建的是Oracle 11g R2 11.2.0.4的RAC环境,使用的操作系统版本为Oracle Linux 6.4
Oracle_RAC+ASM+DataGuard配置实验记录+常见问题
Oracle rac+asm 原库备份与恢复