oracle数据库表归档,ORACLE RAC如何正确配置数据库归档模式 | YallonKing

ORACLE RAC配置归档模式一例

当前系统没有开启归档

[oracle@rac1 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 27 10:16:27 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn /as sysdba

Connected.

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 1

Current log sequence 2

--在2个节点设置相关目录

[oracle@rac1 ora10g]$ env|grep ORACLE_HOME

ORACLE_HOME=/opt/ora10g/product/database

[oracle@rac1 ~]$ cd /opt/ora10g/

[oracle@rac1 ora10g]$ mkdir racdb1_arch

[oracle@rac1 ora10g]$ mkdir racdb2_arch

[oracle@rac2 ~]$ cd /opt/ora10g/

[oracle@rac2 ora10g]$ mkdir racdb1_arch

[oracle@rac2 ora10g]$ mkdir racdb2_arch

--设置归档参数(其中的service为tnsname.ora中的服务目录)

SQL> alter system set log_archive_dest_1='location=/opt/ora10g/racdb2_arch' scope=spfile sid='racdb2';

System altered.

SQL> alter system set log_archive_dest_2='service=racdb1' scope=spfile sid='racdb2';

System altered.

SQL> alter system set log_archive_dest_1='location=/opt/ora10g/racdb1_arch' scope=spfile sid='racdb1';

System altered.

SQL> alter system set log_archive_dest_2='service=racdb2' scope=spfile sid='racdb1';

System altered.

SQL> alter system set standby_archive_dest='/opt/ora10g/racdb2_arch' scope=spfile sid='racdb1';

System altered.

SQL> alter system set standby_archive_dest='/opt/ora10g/racdb1_arch' scope=spfile sid='racdb2';

System altered.

---将数据库置为单实例

SQL> alter system set cluster_database=false scope=spfile sid='*';

System altered.

--关闭所有实例

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

--在单实例下修改归档设置

SQL> startup mount;

ORACLE instance started.

Total System Global Area 536870912 bytes

Fixed Size 1220432 bytes

Variable Size 171966640 bytes

Database Buffers 360710144 bytes

Redo Buffers 2973696 bytes

Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter system set cluster_database=true scope=spfile sid='*';

System altered.

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

--确认归档是否生成正确

SQL> startup

ORACLE instance started.

Total System Global Area 536870912 bytes

Fixed Size 1220432 bytes

Variable Size 171966640 bytes

Database Buffers 360710144 bytes

Redo Buffers 2973696 bytes

Database mounted.

Database opened.

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /opt/ora10g/racdb1_arch

Oldest online log sequence 1

Next log sequence to archive 2

Current log sequence 2