Oracle 10g RAC 切换到归档模式

[Oracle@node1 pfile]$ export ORACLE_SID=MRAC1[oracle@node1 pfile]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 27 10:27:35 2012 Copyright （c） 1982, 2005, Oracle. All rights reserved.Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, Real Application Clusters, OLAP and Data Mining options SQL> alter system set log_archive_dest_1="+archlog" scope=both;alter system set log_archive_dest_1="+archlog" scope=both*？ 1 ？？？？？:ORA-32017: ？？ SPFILE ？？？ORA-16179: ？？？？？ SPFILE ？ "log_archive_dest_1" ？？？？？？确实LOCATIONSQL> alter system set log_archive_dest_1="location=+archlog" scope=both; ？？？？？？ SQL> alter system set log_archive_format="arch_%s_%t.arc" scope=both;alter system set log_archive_format="arch_%s_%t.arc" scope=both *？ 1 ？？？？？:ORA-02095: ？？？？？？？？？？？？只能SPFILESQL> alter system set log_archive_format="arch_%s_%t.arc" scope=spfile; ？？？？？？ SQL> alter system set log_archive_start=true;alter system set log_archive_start=true *？ 1 ？？？？？:ORA-02095: ？？？？？？？？？？？？ SQL> alter system set log_archive_start=true scope=spfile; ？？？？？？查看活动实例SQL> col inst_name for a30SQL> select * from v$active_instances; INST_NUMBER INST_NAME----------- ------------------------------ 1 node1:MYRAC1 2 node2:MYRAC2使用SPFILE文件启动的SQL> show parameter spfile NAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string +DATA/myrac/spfilemyrac.ora 节点2也使用同一个文件启动的SQL> show parameter pfile NAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string +DATA/myrac/spfilemyrac.ora 节点2参数文件得到立即更新SQL> show parameter log_archive_dest_1 NAME TYPE VALUE------------------------------------ ----------- ------------------------------log_archive_dest_1 string location=+archloglog_archive_dest_10 string SQL> shutdown immediateORA-01507: ？？？？？？ ORACLE ？？？？？？？SQL> startup mount SQL> show parameter logORA-01034: ORACLE not available SQL> shutdown immediate;ORA-01012: not logged onSQL> exit？ Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, Real Application Clusters, OLAP and Data Mining options ？？[oracle@node1 pfile]$ export ORACLE_SID=MYRAC1[oracle@node1 pfile]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 27 10:51:08 2012 Copyright （c） 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomountORA-32004: obsolete and/or deprecated parameter（s） specifiedORA-19905: log_archive_format must contain %s, %t and %rSQL> show parameter log_archiveORA-01034: ORACLE not available SQL> host[oracle@node1 pfile]$ pwd/opt/oracle/database/admin/MYRAC/pfile[oracle@node1 pfile]$ vi myrac1_pfile.ora MYRAC2.__db_cache_size=75497472MYRAC1.__db_cache_size=62914560MYRAC1.__java_pool_size=4194304MYRAC2.__java_pool_size=4194304MYRAC1.__large_pool_size=4194304MYRAC2.__large_pool_size=4194304MYRAC2.__shared_pool_size=79691776MYRAC1.__shared_pool_size=92274688MYRAC1.__streams_pool_size=0MYRAC2.__streams_pool_size=0*.audit_file_dest="/opt/oracle/database/admin/MYRAC/adump"*.background_dump_dest="/opt/oracle/database/admin/MYRAC/bdump"*.cluster_database_instances=2*.cluster_database=true*.compatible="10.2.0.1.0"*.control_files="+DATA/myrac/controlfile/current.256.772910373"*.core_dump_dest="/opt/oracle/database/admin/MYRAC/cdump"*.db_block_size=8192*.db_create_file_dest="+DATA"*.db_domain=""*.db_file_multiblock_read_count=16*.db_name="MYRAC"*.dispatchers="（PROTOCOL=TCP）（SERVICE=MYRACXDB）"MYRAC1.instance_number=1MYRAC2.instance_number=2*.job_queue_processes=10*.nls_language="SIMPLIFIED CHINESE"*.nls_territory="CHINA"*.open_cursors=300*.pga_aggregate_target=16777216*.processes=150*.remote_listener="LISTENERS_MYRAC_OLTP"*.remote_login_passwordfile="exclusive"*.sga_target=167772160MYRAC2.thread=2MYRAC1.thread=1*.undo_management="AUTO"MYRAC1.undo_tablespace="UNDOTBS1"MYRAC2.undo_tablespace="UNDOTBS2"*.user_dump_dest="/opt/oracle/database/admin/MYRAC/udump" *.log_archive_start=true*.log_archive_dest_1="location=+archlog"*.log_archive_format="arch_%s_%t_%r.arc"[oracle@node1 pfile]$ exitexit SQL> startup nomount pfile="/opt/oracle/database/admin/MYRAC/pfile/myrac1_pfile.ora";ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecatedORACLE instance started. Total System Global Area 167772160 bytesFixed Size 1218316 bytesVariable Size 100665588 bytesDatabase Buffers 62914560 bytesRedo Buffers 2973696 bytes 这个参数被废弃了无关紧要！SQL> show parameter log_archive NAME TYPE VALUE------------------------------------ ----------- ------------------------------log_archive_config stringlog_archive_dest stringlog_archive_dest_1 string location=+archloglog_archive_dest_10 stringlog_archive_dest_2 stringlog_archive_dest_3 stringlog_archive_dest_4 stringlog_archive_dest_5 stringlog_archive_dest_6 stringlog_archive_dest_7 stringlog_archive_dest_8 string NAME TYPE VALUE------------------------------------ ----------- ------------------------------log_archive_dest_9 stringlog_archive_dest_state_1 string enablelog_archive_dest_state_10 string enablelog_archive_dest_state_2 string enablelog_archive_dest_state_3 string enablelog_archive_dest_state_4 string enablelog_archive_dest_state_5 string enablelog_archive_dest_state_6 string enablelog_archive_dest_state_7 string enablelog_archive_dest_state_8 string enablelog_archive_dest_state_9 string enable NAME TYPE VALUE------------------------------------ ----------- ------------------------------log_archive_duplex_dest stringlog_archive_format string arch_%s_%t_%r.arclog_archive_local_first boolean TRUElog_archive_max_processes integer 2log_archive_min_succeed_dest integer 1log_archive_start boolean TRUElog_archive_trace integer SQL> alter database archivelog; ？？？？？？？ SQL> archive log list;？？？？？？？？？？？？？？？？？？？？？ +ARCHLOG？？？？？？？？？ 86？？？？？？？？？ 88？？？？？？ 88SQL> alter database open; ？？？？？？？ SQL> col instance_name a30SP2-0158: ？？？ COLUMN ？？ "a30"SQL> col inst_name for a30SQL> select * from v$active_instances; INST_NUMBER INST_NAME----------- ------------------------------ 1 node1:MYRAC1SQL> alter session set nls_language=american; Session altered.先把原来的AMSCMD里的删除 SQL> create spfile="+DATA/MyRAC/spfileMYRAC.ora" from pfile; File created. SQL> startupORA-01565: error in identifying file "+DATA/MYRAC/spfileMYRAC.ora"ORA-17503: ksfdopn:2 Failed to open file +DATA/MYRAC/spfileMYRAC.oraORA-01000: maximum open cursors exceeded [oracle@node1 oracle]$ cat pfile_01.ora*.SPFILE="+DATA/MYRAC/spfileMYRAC.ora" 删除SPFILE 重新创建并且修改语言到英文环境 SSH客户端没地方设置SQL> create spfile="+data/myrac/spfileMYRAC.ora" from pfile="/opt/oracle/database/admin/MYRAC/pfile/myrac1_pfile.ora"; File created.指定SPFILE目录和指定PFILE结果节点2成功启动了SPFILE, 反而节点1的SPFILE 定位在本地目录上SQL> startup nomountORACLE instance started. Total System Global Area 167772160 bytesFixed Size 1218316 bytesVariable Size 100665588 bytesDatabase Buffers 62914560 bytesRedo Buffers 2973696 bytesSQL> show parameter pfile NAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string /opt/oracle/database/product/1 0.2.0/db_1/dbs/spfileMYRAC1.or a经过几番折腾把本地SPFILE移走到其他目录下终于启动了共享磁盘上的SPFILE文件[oracle@node1 dbs]$ mv spfileMYRAC1.ora /opt/oracle/database[oracle@node1 dbs]$ exit关闭先前的实例SQL> shutdown immediate;ORA-01507: database not mounted ORACLE instance shut down.启动内存模式SQL> startup nomountORACLE instance started. Total System Global Area 167772160 bytesFixed Size 1218316 bytesVariable Size 100665588 bytesDatabase Buffers 62914560 bytesRedo Buffers 2973696 bytes查看spfile路径发现正确用到了共享磁盘上的SQL> show parameter pfile NAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string +DATA/myrac/spfilemyrac.ora加载控制文件SQL> alter database mount 2 ; Database altered.打开数据库SQL> alter database open; Database altered.查看是否归档SQL> archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination +ARCHLOGOldest online log sequence 87Next log sequence to archive 89Current log sequence 89节点1 交换日志SQL> alter system switch logfile; System altered 自动生成多级目录ASMCMD> pwd+archlog/myrac/archivelog/2012_09_27ASMCMD> lsthread_1_seq_88.256.795093263thread_1_seq_89.257.795108837.节点直接启动开启数据库模式并且查看归档节点2 交换下日志SQL> alter system switch logfile; ASMCMD> lsthread_1_seq_88.256.795093263thread_1_seq_89.257.795108837thread_2_seq_47.258.795108927 注意事项1 创建pfile和spfile 最好指定目录两边都要2 创建和更新spfile时先删除或者备份共享目录上的spfile. 最好先不删除,如果删除它会把连接所在的目录删除掉,重建的时候会搞个DB_UNKONW 怪怪地.3 注意共享磁盘上的spfile 结尾是不带数字的4 归档文件路径只要指定一级目录就够了,它会自动创建多级目录的.Oracle 10g RAC 备份 RMANOracle 10g RAC 添加日志组和成员以及删除日志成员相关资讯 ORACLE 10G

Oracle 10g（10.2.0.4）升级到10.2.0 （04月10日）
Oracle 10g 一主多备的搭建技巧（07/31/2015 15:31:51）
多平台下的32位和64位Oracle 10g下（02/18/2015 10:38:21）

Oracle 10g实现只读表的N种方法（08/05/2015 10:54:35）
Oracle 10g中约束与列属性NULLABLE （03/07/2015 19:22:46）
Oracle 10g Clusterware Votedisk （01/16/2015 14:09:54）

本文评论查看全部评论（0）