oracle 10g rac 启用归档模式

最新推荐文章于 2024-09-14 19:55:29 发布

cplj45920

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量131

点赞数

文章标签：数据库操作系统开发工具

RAC环境，双节点，之前没有启用归档，现在因上备份软件要启用归档。

本次处理方案是将归档日志存放到双节点的本地磁盘，

[@more@]

首先选取操作系统中空闲多的分区作为归档日志存放的位置。

如下，我选用/opt分区

# df -g
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 20.00 18.78 7% 10184 1% /
/dev/hd2 10.00 8.17 19% 41599 3% /usr
/dev/hd9var 10.00 9.83 2% 1096 1% /var
/dev/hd3 4.00 3.90 3% 677 1% /tmp
/dev/hd1 25.00 10.00 60% 37970 2% /home
/dev/hd11admin 0.25 0.25 1% 5 1% /admin
/proc - - - - - /proc
/dev/hd10opt 60.00 58.52 3% 4763 1% /opt

每个节点分别执行
# cd /opt
# ls
IBM RPM_inst_root eclipse2 nbu_software
IBMinvscout Tivoli freeware pconsole
LicenseUseManagement cam hsc perfwb
ORCLcluster csm ibm perl
ORCLfmap diagnostics lost+found
# mkdir ora_archive
# ls
IBM RPM_inst_root eclipse2 nbu_software
IBMinvscout Tivoli freeware ora_archive
LicenseUseManagement cam hsc pconsole
ORCLcluster csm ibm perfwb
ORCLfmap diagnostics lost+found perl
# chown -R oracle:oinstall ora_archive
设置本地归档日志存放目录

SQL> alter system set log_archive_dest='/opt/ora_archive' sid='keyan1';

System altered.

SQL> alter system set log_archive_dest='/opt/ora_archive' sid='keyan2';

System altered.

关闭集群所有节点实例 $ srvctl stop database -d keyan

在每个节点分别执行
$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jul 14 11:46:12 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 1610612736 bytes
Fixed Size 2084400 bytes
Variable Size 939524560 bytes
Database Buffers 654311424 bytes
Redo Buffers 14692352 bytes
Database mounted.
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 /opt/ora_archive
Oldest online log sequence 141
Next log sequence to archive 142
Current log sequence 142
SQL>

重新启动集群所有节点实例 $ srvctl start database -d keyan

强制切换归档查看结果
$ date
Tue Jul 14 12:22:23 CDT 2009
$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jul 14 12:22:33 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> alter system switch logfile;

System altered.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
$ ls -al
total 114944
drwxr-xr-x 2 oracle oinstall 256 Jul 14 12:22 .
drwxr-xr-x 23 root system 4096 Jul 14 11:37 ..
-rw-rw---- 1 oracle oinstall 17235968 Jul 14 12:22 1_142_682350777.dbf
-rw-r----- 1 oracle oinstall 41601536 Jul 14 11:47 2_53_682350777.dbf