oracle11grac归档备份,Oracle11gR2RAC环境归档模式的配置

在10gR2中和11g,不再需要将cluster_database设置为false,将非归档的RAC数据库改成归档的RAC数据库,方法与单实例设置归档模式是一样的了。今天就演示一个归档到ASM磁盘组的例子。

第一步&＃xff1a;查看ASM磁盘组

[root&＃64;rac1 ~]# su - grid

rac1-> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Aug 2 11:02:59 2014

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> select name from v$asm_diskgroup;

NAME

--------------------------------------------------------------------------------

DATA

PROD

SQL> alter diskgroup data add directory &＃39;&＃43;DATA/ARC1&＃39;;

Diskgroup altered.

SQL>   可以看到我们这边的环境有2个ASM磁盘组

第二步&＃xff1a;创建归档目录在ASM磁盘组

因为磁盘组是共享的&＃xff0c;所以在任意一节点创建就可以了。

[root&＃64;rac1 ~]# su - grid

rac1-> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Aug 2 11:02:59 2014

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> select name from v$asm_diskgroup;

NAME

--------------------------------------------------------------------------------

DATA

PROD

SQL> alter diskgroup data add directory &＃39;&＃43;DATA/ARC1&＃39;;

Diskgroup altered.

SQL>

SQL> alter diskgroup data add directory &＃39;&＃43;DATA/ARC2&＃39;;

Diskgroup altered.

SQL>

第三步&＃xff1a;设置归档目录

在节点一设置完以后&＃xff0c;关闭数据库

SQL> SELECT INSTANCE_NAME FROM V$INSTANCE;

INSTANCE_NAME

------------------------------------------------

PROD1

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1&＃61;&＃39;LOCATION&＃61;&＃43;DATA/ARC1&＃39; SCOPE&＃61;SPFILE SID&＃61;&＃39;PROD1&＃39;;

System altered.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1&＃61;&＃39;LOCATION&＃61;&＃43;DATA/ARC2&＃39; SCOPE&＃61;SPFILE SID&＃61;&＃39;PROD2&＃39;;

System altered.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>    节点二也关闭数据库

SQL> SELECT INSTANCE_NAME FROM V$INSTANCE;

INSTANCE_NAME

------------------------------------------------

PROD2

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

第四步&＃xff1a;设置归档模式

第一个节点设置归档模式

rac1-> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Aug 2 11:12:19 2014

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

Connected to an idle instance.

SQL> STARTUP MOUNT

ORACLE instance started.

Total System Global Area 1653518336 bytes

Fixed Size 2253784 bytes

Variable Size 1073744936 bytes

Database Buffers 570425344 bytes

Redo Buffers 7094272 bytes

Database mounted.

SQL> ALTER DATABASE ARCHIVELOG;

Database altered.

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination &＃43;DATA/arc1

Oldest online log sequence 4

Next log sequence to archive 5

Current log sequence 5

SQL>

SQL>

SQL> alter database open;

Database altered.

SQL>  第二个节点开启&＃xff0c;注意第二个节点可以直接打开&＃xff0c;不用再设置归档模式

rac2-> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Aug 2 11:13:26 2014

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

Connected to an idle instance.

SQL> STARTUP MOUNT

ORACLE instance started.

Total System Global Area 1653518336 bytes

Fixed Size 2253784 bytes

Variable Size 1073744936 bytes

Database Buffers 570425344 bytes

Redo Buffers 7094272 bytes

Database mounted.

SQL> ALTER DATABASE ARCHIVELOG;

Database altered.

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination &＃43;DATA/arc2

Oldest online log sequence 1

Next log sequence to archive 2

Current log sequence 2

SQL>

SQL> alter database open;

Database altered.

SQL>

第五步&＃xff1a;2节点切换日志&＃xff0c;查看归档文件是否生成

SQL> alter system switch logfile;   2个节点都要运行&＃xff0c;产生各自节点的归档文件

[root&＃64;rac1 ~]# su - grid

rac1-> asmcmd

ASMCMD> ls

DATA/

PROD/

ASMCMD> cd DATA

ASMCMD> ls

ARC1/

ARC2/

PROD/

scan-cluster/

ASMCMD> cd ARC1/

ASMCMD> ls

1_5_851804842.dbf

ASMCMD>

ASMCMD> cd ..

ASMCMD> pwd

&＃43;DATA

ASMCMD> cd ARC2

ASMCMD> ls

2_2_851804842.dbf

ASMCMD>    好了检查完毕。成功&＃xff01;