1)编辑log_archive_dest_1参数,指定归档目录;
然后登录到一个节点(racdb1),通过在当前实例中将 cluster_database 设置为 FALSE 来禁用集群实例参数:
$ sqlplus / as sysdba
SQL> alter system set log_archive_dest_1='location=+ARCH' scope=spfile;
System altered.
$ sqlplus / as sysdba
SQL> alter system set cluster_database=false scope=spfile sid='racdb1';
System altered.
2)关闭数据库的所有实例
$ srvctl stop database -d racdb
[oracle@racdb1 ~]$ srvctl stop database -d racdb
[oracle@racdb1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.racdb.db application 0/0 0/1 OFFLINE OFFLINE
ora....b1.inst application 0/5 0/0 OFFLINE OFFLINE
ora....b2.inst application 0/5 0/0 OFFLINE OFFLINE
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE racdb1
ora....B1.lsnr application 0/5 0/0 ONLINE ONLINE racdb1
ora.racdb1.gsd application 0/5 0/0 ONLINE ONLINE racdb1
ora.racdb1.ons application 0/3 0/0 ONLINE ONLINE racdb1
ora.racdb1.vip application 0/0 0/0 ONLINE ONLINE racdb1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE racdb2
ora....B2.lsnr application 0/5 0/0 ONLINE ONLINE racdb2
ora.racdb2.gsd application 0/5 0/0 ONLINE ONLINE racdb2
ora.racdb2.ons application 0/3 0/0 ONLINE ONLINE racdb2
ora.racdb2.vip application 0/0 0/0 ONLINE ONLINE racdb2
3)使用本地实例,挂载数据库:
$ sqlplus / as sysdba
SQL> startup mount
4)启用存档:
SQL> alter database archivelog;
5)通过在当前实例中将实例参数 cluster_database 修改为 TRUE,重新启用对集群的支持:
SQL> alter system set cluster_database=true scope=spfile sid='racdb1';
6)关闭本地实例:
SQL> shutdown immediate
7)使用 srvctl打开所有实例:
$ srvctl start database -d racdb
8)使用 srvctl打开所有服务:
$ srvctl start service -d racdb
9)登录到本地实例,验证存档日志模式已启用:
$ sqlplus / as sysdba
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +ARCH
Oldest online log sequence 1
Next log sequence to archive 3
Current log sequence 3
10)启用存档日志模式后,RAC 配置中的每个实例都可以自动存档重做日志!手工生成归档日志,然后检查是否正常生成归档文件;
SQL> alter system archive log current;
System altered.
SQL> r
1* alter system archive log current
System altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +ARCH
Oldest online log sequence 3
Next log sequence to archive 5
Current log sequence 5
SQL>
[oracle@racdb1 ~]$ export ORACLE_SID=+ASM1
[oracle@racdb1 ~]$ asmcmd
ASMCMD> ls
ARCH/
DATA/
ASMCMD> cd ARCH
ASMCMD> ls
RACDB/
ASMCMD> cd RACDB
ASMCMD> ls
ARCHIVELOG/
ASMCMD> cd ARCHIVELOG
ASMCMD> ls
2012_02_08/
ASMCMD> cd 2012_02_08/
ASMCMD> ls
thread_1_seq_3.257.774717465
thread_1_seq_4.258.774717489
thread_2_seq_3.256.774717467
thread_2_seq_4.259.774717497
ASMCMD>
当然,查看archived_log视图就最方便了
SQL> select name from v$archived_log;
NAME
--------------------------------------------------------------------------------
+ARCH/racdb/archivelog/2012_02_08/thread_2_seq_3.256.774717467
+ARCH/racdb/archivelog/2012_02_08/thread_1_seq_3.257.774717465
+ARCH/racdb/archivelog/2012_02_08/thread_1_seq_4.258.774717489
+ARCH/racdb/archivelog/2012_02_08/thread_2_seq_4.259.774717497
SQL>
That is All.
如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!
赞0
添加新评论0 条评论