RAC 环境下修改归档模式

我会带着你远行 2022-03-17 08:24 273阅读 0赞

分享一下我老师大神的人工智能教程。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！[https://blog.csdn.net/jiangjunshow][https_blog.csdn.net_jiangjunshow]

RAC环境下的归档模式切换与单实例稍有不同，主要是共享存储所产生的差异。在这种情况下，我们可以将RAC数据库切换到非集群状态下，仅仅在一个实例上来实施归档模式切换即可完成RAC数据库的归档模式转换问题。本文主要描述了由非归档模式切换到归档模式，而由非归档切换的归档步骤相同，不再赘述。

1、主要步骤： 备份spfile，以防止参数修改失败导致数据库无法启动 修改集群参数cluster_database为false 启动单实例到mount状态 将数据库置于归档模式(alter database archivelog/noarchivelog) 修改集群参数cluster_database为true 关闭单实例 启动集群数据库2、环境  oracle@bo2dbp:~> cat /etc/issue Welcome to SUSE Linux Enterprise Server 10 SP3 (x86_64) - Kernel \r (\l). oracle@bo2dbp:~> sqlplus -v SQL*Plus: Release 10.2.0.3.0 - Production  使用asm存储方式存放归档日志3、修改集群数据库到归档模式 oracle@bo2dbp:~> export ORACLE_SID=ora10g1 oracle@bo2dbp:~> sqlplus / as sysdba SQL*Plus: Release 10.2.0.3.0 - Production on Mon Dec 24 16:53:18 2012 Copyright (c) 1982, 2006, Oracle.  All Rights Reserved. Connected to: Oracle Database 10g Release 10.2.0.3.0 - 64bit Production With the Real Application Clusters option SQL> archive log list;    -->查看当前数据库的归档模式 Database log mode              No Archive Mode          -->非归档模式 Automatic archival             Disabled Archive destination            USE_DB_RECOVERY_FILE_DEST Oldest online log sequence     59 Current log sequence           60 SQL> select instance_name,host_name,status from gv$instance; INSTANCE_NAME    HOST_NAME            STATUS ---------------- -------------------- ------------ ora10g1          bo2dbp               OPEN ora10g2          bo2dbs               OPEN SQL> show parameter cluster      -->查看集群的参数,cluster_database为true表示为集群数据库，否则，非集群数据库 NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ cluster_database                     boolean     TRUE cluster_database_instances           integer     2 cluster_interconnects                string SQL> create pfile='/u01/oracle/db/dbs/ora10g_robin.ora' from spfile;  -->先备份spfile File created. SQL> alter system set cluster_database=false scope=spfile sid='*';  -->修改为非集群数据库，该参数为静态参数，需要使用scope=spfile System altered. oracle@bo2dbp:~> srvctl stop database -d ora10g                        -->关闭数据库 oracle@bo2dbp:~> srvctl start instance -d ora10g -i ora10g1 -o mount   -->启动单个实例到mount状态 oracle@bo2dbp:~> sqlplus / as sysdba SQL> select instance_name,status from v$instance; INSTANCE_NAME    STATUS ---------------- ------------ ora10g1          MOUNTED SQL> alter database archivelog;                                       -->改变数据库到归档模式 Database altered. SQL> alter system set cluster_database=true scope=spfile sid='*';    -->在将数据库改为集群模式 System altered. SQL> ho srvctl stop instance -d ora10g -i ora10g1                     -->关闭当前实例 SQL> ho srvctl start database -d ora10g                               -->启动集群数据库   SQL> archive log list; ORA-03135: connection lost contact SQL> conn / as sysdba Connected. SQL> archive log list;                                                -->查看归档模式 Database log mode              Archive Mode                           -->已经处于归档模式 Automatic archival             Enabled                                -->自动归档 Archive destination            USE_DB_RECOVERY_FILE_DEST              -->归档位置为参数DB_RECOVERY_FILE_DEST的值 Oldest online log sequence     60                                     -->下面是sequence相关信息    Next log sequence to archive   61 Current log sequence           61 SQL> show parameter db_recovery_file NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest                string      +REV db_recovery_file_dest_size           big integer 2G4、归档验证  SQL> select inst_id,name,thread#,sequence#,status from gv$archived_log;  -->当前无任何归档日志 no rows selected SQL> alter system switch logfile;        -->在实例1上进行归档 System altered. SQL> col name format a65 SQL> select inst_id,name,thread#,sequence#,status from gv$archived_log;   -->查看到sequence为61的日志已经归档    INST_ID NAME                                                                 THREAD#  SEQUENCE# S ---------- ----------------------------------------------------------------- ---------- ---------- -    1 +REV/ora10g/archivelog/2012_12_24/thread_1_seq_61.459.802892953            1         61  SQL> select name,thread#,sequence#,status from v$archived_log;  -->下面是从实例级别的视图来查看 NAME                                                                 THREAD#  SEQUENCE# S ----------------------------------------------------------------- ---------- ---------- - +REV/ora10g/archivelog/2012_12_24/thread_1_seq_61.459.802892953            1         61 A SQL> conn system/oracle@ora10g2    -->连接到实例2 Connected.    SQL> show parameter instance_name; NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ instance_name                        string      ora10g2 SQL> alter system switch logfile;   -->在实例2上进行归档 System altered. SQL> select inst_id,name,thread#,sequence#,status from gv$archived_log;   -->可以看到sequence为43的日志已经归档 -->注意这个视图查询时同一个归档日志除了出现在自身实例中外,对另外的实例也是可见的    INST_ID NAME                                                                 THREAD#  SEQUENCE# S ---------- ----------------------------------------------------------------- ---------- ---------- -    1 +REV/ora10g/archivelog/2012_12_24/thread_1_seq_61.459.802892953            1         61 A    1 +REV/ora10g/archivelog/2012_12_24/thread_2_seq_43.458.802893283            2         43 A    2 +REV/ora10g/archivelog/2012_12_24/thread_1_seq_61.459.802892953            1         61 A    2 +REV/ora10g/archivelog/2012_12_24/thread_2_seq_43.458.802893283            2         43 A -->查看日志的状态 -->注意这个v$log视图将两个实例上的组及状态都显示出来了 -->在这里用thread#来区分，thread#为1表示实例1上的日志组有1,2,且1处于current状态.thread#2类似.    SQL> select * from v$log;  GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------    1          1         62   52428800          2 NO  CURRENT                4314741 24-DEC-12    2          1         61   52428800          2 YES ACTIVE                 4312116 24-DEC-12    3          2         43   52428800          2 YES ACTIVE                 4312300 24-DEC-12    4          2         44   52428800          2 NO  CURRENT                4315097 24-DEC-12 -->Author: Robinson -->Blog  : http://blog.csdn.net/robinson_0612 -->归档当前日志,注意该命令在单实例下等同于alter system switch logfile -->在rac环境下则不同，那就是所有实例上的current日志都将会被归档    SQL> alter system archive log current; System altered. -->下面的查询正好验证了上面的描述 -->日志62与44正是刚刚上面的命令同时产生的归档日志    SQL> select inst_id,name,thread#,sequence#,status from gv$archived_log;    INST_ID NAME                                                                 THREAD#  SEQUENCE# S ---------- ----------------------------------------------------------------- ---------- ---------- -    2 +REV/ora10g/archivelog/2012_12_24/thread_1_seq_61.459.802892953            1         61 A    2 +REV/ora10g/archivelog/2012_12_24/thread_2_seq_43.458.802893283            2         43 A    2 +REV/ora10g/archivelog/2012_12_24/thread_2_seq_44.456.802894343            2         44 A    2 +REV/ora10g/archivelog/2012_12_24/thread_1_seq_62.457.802894341            1         62 A    1 +REV/ora10g/archivelog/2012_12_24/thread_1_seq_61.459.802892953            1         61 A    1 +REV/ora10g/archivelog/2012_12_24/thread_2_seq_43.458.802893283            2         43 A    1 +REV/ora10g/archivelog/2012_12_24/thread_2_seq_44.456.802894343            2         44 A    1 +REV/ora10g/archivelog/2012_12_24/thread_1_seq_62.457.802894341            1         62 A 8 rows selected.

更多参考

有关Oracle RAC请参考  
[使用crs\_setperm修改RAC资源的所有者及权限  
][crs_setperm_RAC_] [使用crs\_profile管理RAC资源配置文件  
][crs_profile_RAC_] [RAC 数据库的启动与关闭  
][RAC _] [再说 Oracle RAC services  
][Oracle RAC services] [Services in Oracle Database 10g  
][Services in Oracle Database 10g] [Migrate datbase from single instance to Oracle RAC  
][Migrate datbase from single instance to Oracle RAC] [Oracle RAC 连接到指定实例  
][Oracle RAC _] [Oracle RAC 负载均衡测试(结合服务器端与客户端)  
][Oracle RAC _ 1] [Oracle RAC 服务器端连接负载均衡(Load Balance)  
][Oracle RAC _Load Balance_] [Oracle RAC 客户端连接负载均衡(Load Balance)  
][Oracle RAC _Load Balance_ 1] [ORACLE RAC 下非缺省端口监听配置(listener.ora tnsnames.ora)][ORACLE RAC _listener.ora tnsnames.ora]  
[ORACLE RAC 监听配置 (listener.ora tnsnames.ora)  
][ORACLE RAC _ _listener.ora tnsnames.ora_] [配置 RAC 负载均衡与故障转移  
][RAC _ 1] [CRS-1006 , CRS-0215 故障一例][CRS-1006 _ CRS-0215]  
[基于Linux (RHEL 5.5) 安装Oracle 10g RAC][Linux _RHEL 5.5_ _Oracle 10g RAC]  
[使用 runcluvfy 校验Oracle RAC安装环境][runcluvfy _Oracle RAC]

有关Oracle 网络配置相关基础以及概念性的问题请参考：  
[配置非默认端口的动态服务注册][Link 1]  
[配置sqlnet.ora限制IP访问Oracle  
][sqlnet.ora_IP_Oracle] [Oracle 监听器日志配置与管理][Oracle]  
[设置 Oracle 监听器密码(LISTENER)  
][Oracle _LISTENER_] [配置ORACLE 客户端连接到数据库][ORACLE]

有关基于用户管理的备份和备份恢复的概念请参考  
[Oracle 冷备份  
][Oracle _] [Oracle 热备份  
][Oracle _ 1] [Oracle 备份恢复概念  
][Oracle _ 2] [Oracle 实例恢复  
][Oracle _ 3] [Oracle 基于用户管理恢复的处理  
][Oracle _ 4] [SYSTEM 表空间管理及备份恢复  
][SYSTEM _] [SYSAUX表空间管理及恢复  
][SYSAUX_] [Oracle 基于备份控制文件的恢复(unsing backup controlfile)][Oracle _unsing backup controlfile]

有关RMAN的备份恢复与管理请参考  
[RMAN 概述及其体系结构  
][RMAN _] [RMAN 配置、监控与管理  
][RMAN _ 1] [RMAN 备份详解  
][RMAN _ 2] [RMAN 还原与恢复  
][RMAN _ 3] [RMAN catalog 的创建和使用  
][RMAN catalog _] [基于catalog 创建RMAN存储脚本  
][catalog _RMAN_] [基于catalog 的RMAN 备份与恢复  
][catalog _RMAN _] [RMAN 备份路径困惑  
][RMAN _ 4] [使用RMAN实现异机备份恢复(WIN平台)  
][RMAN_WIN_] [使用RMAN迁移文件系统数据库到ASM  
][RMAN_ASM] [linux 下RMAN备份shell脚本  
][linux _RMAN_shell_] [使用RMAN迁移数据库到异机][RMAN]

有关ORACLE体系结构请参考  
[Oracle 表空间与数据文件  
][Oracle _ 5] [Oracle 密码文件  
][Oracle _ 6] [Oracle 参数文件  
][Oracle _ 7] [Oracle 联机重做日志文件(ONLINE LOG FILE)  
][Oracle _ONLINE LOG FILE_] [Oracle 控制文件(CONTROLFILE)  
][Oracle _CONTROLFILE_] [Oracle 归档日志  
][Oracle _ 8] [Oracle 回滚(ROLLBACK)和撤销(UNDO)  
][Oracle _ROLLBACK_UNDO_] [Oracle 数据库实例启动关闭过程  
][Oracle _ 9] [Oracle 10g SGA 的自动化管理  
][Oracle 10g SGA _] [Oracle 实例和Oracle数据库(Oracle体系结构)][Oracle _Oracle_Oracle]

[https_blog.csdn.net_jiangjunshow]: https://blog.csdn.net/jiangjunshow/article/details/77338485
[crs_setperm_RAC_]: http://blog.csdn.net/robinson_0612/article/details/8219242
[crs_profile_RAC_]: http://blog.csdn.net/robinson_0612/article/details/8192571
[RAC _]: http://blog.csdn.net/robinson_0612/article/details/8129506
[Oracle RAC services]: http://blog.csdn.net/robinson_0612/article/details/8124232
[Services in Oracle Database 10g]: http://blog.csdn.net/robinson_0612/article/details/8089812
[Migrate datbase from single instance to Oracle RAC]: http://blog.csdn.net/robinson_0612/article/details/8090095
[Oracle RAC _]: http://blog.csdn.net/robinson_0612/article/details/8073620
[Oracle RAC _ 1]: http://blog.csdn.net/robinson_0612/article/details/8072367
[Oracle RAC _Load Balance_]: http://blog.csdn.net/robinson_0612/article/details/8064599
[Oracle RAC _Load Balance_ 1]: http://blog.csdn.net/robinson_0612/article/details/8060634
[ORACLE RAC _listener.ora tnsnames.ora]: http://blog.csdn.net/robinson_0612/article/details/8053007
[ORACLE RAC _ _listener.ora tnsnames.ora_]: http://blog.csdn.net/robinson_0612/article/details/8020800
[RAC _ 1]: http://blog.csdn.net/robinson_0612/article/details/6791667
[CRS-1006 _ CRS-0215]: http://blog.csdn.net/robinson_0612/article/details/7926241
[Linux _RHEL 5.5_ _Oracle 10g RAC]: http://blog.csdn.net/robinson_0612/article/details/7906282
[runcluvfy _Oracle RAC]: http://blog.csdn.net/robinson_0612/article/details/6533094
[Link 1]: http://blog.csdn.net/robinson_0612/article/details/5925526
[sqlnet.ora_IP_Oracle]: http://blog.csdn.net/robinson_0612/article/details/6629141
[Oracle]: http://blog.csdn.net/robinson_0612/article/details/6629043
[Oracle _LISTENER_]: http://blog.csdn.net/robinson_0612/article/details/6629249
[ORACLE]: http://blog.csdn.net/robinson_0612/article/details/5917103
[Oracle _]: http://blog.csdn.net/robinson_0612/article/details/5791597
[Oracle _ 1]: http://blog.csdn.net/robinson_0612/article/details/5816012
[Oracle _ 2]: http://blog.csdn.net/robinson_0612/article/details/5791585
[Oracle _ 3]: http://blog.csdn.net/robinson_0612/article/details/5768233
[Oracle _ 4]: http://blog.csdn.net/robinson_0612/article/details/6041217
[SYSTEM _]: http://blog.csdn.net/robinson_0612/article/details/6041207
[SYSAUX_]: http://blog.csdn.net/robinson_0612/article/details/5810732
[Oracle _unsing backup controlfile]: http://blog.csdn.net/robinson_0612/article/details/7962187
[RMAN _]: http://blog.csdn.net/robinson_0612/article/details/6032525
[RMAN _ 1]: http://blog.csdn.net/robinson_0612/article/details/6032597
[RMAN _ 2]: http://blog.csdn.net/robinson_0612/article/details/6032739
[RMAN _ 3]: http://blog.csdn.net/robinson_0612/article/details/6041247
[RMAN catalog _]: http://blog.csdn.net/robinson_0612/article/details/6043649
[catalog _RMAN_]: http://blog.csdn.net/robinson_0612/article/details/6073020
[catalog _RMAN _]: http://blog.csdn.net/robinson_0612/article/details/6073069
[RMAN _ 4]: http://blog.csdn.net/robinson_0612/article/details/6414338
[RMAN_WIN_]: http://blog.csdn.net/robinson_0612/article/details/6639064
[RMAN_ASM]: http://blog.csdn.net/robinson_0612/article/details/6453954
[linux _RMAN_shell_]: http://blog.csdn.net/robinson_0612/article/details/8029245
[RMAN]: http://blog.csdn.net/robinson_0612/article/details/8076841
[Oracle _ 5]: http://blog.csdn.net/robinson_0612/article/details/5611738
[Oracle _ 6]: http://blog.csdn.net/robinson_0612/article/details/5611672
[Oracle _ 7]: http://blog.csdn.net/robinson_0612/article/details/5559174
[Oracle _ONLINE LOG FILE_]: http://blog.csdn.net/robinson_0612/article/details/5749556
[Oracle _CONTROLFILE_]: http://blog.csdn.net/robinson_0612/article/details/5737527
[Oracle _ 8]: http://blog.csdn.net/robinson_0612/article/details/5784713
[Oracle _ROLLBACK_UNDO_]: http://blog.csdn.net/robinson_0612/article/details/5731158
[Oracle _ 9]: http://blog.csdn.net/robinson_0612/article/details/5542983
[Oracle 10g SGA _]: http://blog.csdn.net/robinson_0612/article/details/5534832
[Oracle _Oracle_Oracle]: http://blog.csdn.net/robinson_0612/article/details/5529239