当前位置:  数据库>oracle

Oracle 10g RAC 切换到归档模式

    来源: 互联网  发布时间：2017-05-09

    本文导语: [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 - Production With the...

[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 - Production

With 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" ??????

 

确实LOCATION

SQL> 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: ????????????

 

只能SPFILE

SQL> 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 a30

SQL> 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=+archlog

log_archive_dest_10                  string

 

SQL> shutdown immediate

ORA-01507: ??????

 

 

ORACLE ???????

SQL> startup mount

 

SQL> show parameter log

ORA-01034: ORACLE not available

 

 

SQL> shutdown immediate;

ORA-01012: not logged on

SQL> exit

? Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With 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 nomount

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORA-19905: log_archive_format must contain %s, %t and %r

SQL> show parameter log_archive

ORA-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=75497472

MYRAC1.__db_cache_size=62914560

MYRAC1.__java_pool_size=4194304

MYRAC2.__java_pool_size=4194304

MYRAC1.__large_pool_size=4194304

MYRAC2.__large_pool_size=4194304

MYRAC2.__shared_pool_size=79691776

MYRAC1.__shared_pool_size=92274688

MYRAC1.__streams_pool_size=0

MYRAC2.__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=1

MYRAC2.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=167772160

MYRAC2.thread=2

MYRAC1.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]$ exit

exit

 

SQL> startup nomount pfile='/opt/oracle/database/admin/MYRAC/pfile/myrac1_pfile.ora';

ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated

ORACLE instance started.

 

Total System Global Area  167772160 bytes

Fixed Size                  1218316 bytes

Variable Size             100665588 bytes

Database Buffers           62914560 bytes

Redo Buffers                2973696 bytes

 

这个参数被废弃了无关紧要!

SQL> show parameter log_archive

 

NAME                                 TYPE   VALUE

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

log_archive_config                   string

log_archive_dest                     string

log_archive_dest_1                   string  location=+archlog

log_archive_dest_10                  string

log_archive_dest_2                   string

log_archive_dest_3                   string

log_archive_dest_4                   string

log_archive_dest_5                   string

log_archive_dest_6                   string

log_archive_dest_7                   string

log_archive_dest_8                   string

 

NAME                                 TYPE   VALUE

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

log_archive_dest_9                   string

log_archive_dest_state_1             string  enable

log_archive_dest_state_10            string  enable

log_archive_dest_state_2             string  enable

log_archive_dest_state_3             string  enable

log_archive_dest_state_4             string  enable

log_archive_dest_state_5             string  enable

log_archive_dest_state_6             string  enable

log_archive_dest_state_7             string  enable

log_archive_dest_state_8             string  enable

log_archive_dest_state_9             string  enable

 

NAME                                 TYPE   VALUE

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

log_archive_duplex_dest              string

log_archive_format                   string  arch_%s_%t_%r.arc

log_archive_local_first              boolean     TRUE

log_archive_max_processes            integer     2

log_archive_min_succeed_dest         integer     1

log_archive_start                    boolean     TRUE

log_archive_trace                    integer  

 

SQL> alter database archivelog;

 

???????

 

SQL> archive log list;

???????            ????

????             ??

????            +ARCHLOG

?????????     86

?????????   88

??????           88

SQL> alter database open;

 

???????

 

SQL> col instance_name a30

SP2-0158: ??? COLUMN ?? "a30"

SQL> col inst_name for a30

SQL> select * from v$active_instances;

 

INST_NUMBER INST_NAME

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

          1 node1:MYRAC1

SQL> alter session set nls_language=american;

 

Session altered.

先把原来的AMSCMD里的删除

 

SQL> create spfile='+DATA/MyRAC/spfileMYRAC.ora' from pfile;

 

File created.

 

SQL> startup

ORA-01565: error in identifying file '+DATA/MYRAC/spfileMYRAC.ora'

ORA-17503: ksfdopn:2 Failed to open file +DATA/MYRAC/spfileMYRAC.ora

ORA-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 nomount

ORACLE instance started.

 

Total System Global Area  167772160 bytes

Fixed Size                  1218316 bytes

Variable Size             100665588 bytes

Database Buffers           62914560 bytes

Redo Buffers                2973696 bytes

SQL> 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 nomount

ORACLE instance started.

 

Total System Global Area  167772160 bytes

Fixed Size                  1218316 bytes

Variable Size             100665588 bytes

Database Buffers           62914560 bytes

Redo 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 list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            +ARCHLOG

Oldest online log sequence     87

Next log sequence to archive   89

Current log sequence           89

节点1 交换日志

SQL> alter system switch logfile;

 

System altered

 

自动生成多级目录

ASMCMD> pwd

+archlog/myrac/archivelog/2012_09_27

ASMCMD> ls

thread_1_seq_88.256.795093263

thread_1_seq_89.257.795108837.

节点直接启动开启数据库模式

并且查看归档

节点2 交换下日志

SQL> alter system switch logfile;

 

ASMCMD> ls

thread_1_seq_88.256.795093263

thread_1_seq_89.257.795108837

thread_2_seq_47.258.795108927

 

注意事项

1 创建pfile和spfile 最好指定目录两边都要

2 创建和更新spfile时先删除或者备份共享目录上的spfile. 最好先不删除,如果删除它会把连接所在的目录删除掉,重建的时候会搞个DB_UNKONW 怪怪地.

3 注意共享磁盘上的spfile 结尾是不带数字的

4 归档文件路径只要指定一级目录就够了,它会自动创建多级目录的.


    
 
 

您可能感兴趣的文章:

  • 切换Oracle的归档模式以及非归档模式
  • oracle的归档模式 ORACLE数据库归档日志常用命令
  • 更改Oracle数据库的归档模式
  • 查看修改Oracle10G归档日志空间的限制
  • 关于Oracle将目标数据库设为归档模式应该注意的问题
  • Oracle 删除归档日志实例
  • oracle 如何关闭打开归档日志
  • Oracle数据库归档模式的切换
  • Linux下Oracle归档日志自动清理脚本代码(sh)
  • Oracle中归档模式的定义简述
  • Oracle10g自动归档设置
  • 更改Oracle数据库到归档模式
  • oracle日志操作模式(归档模式和非归档模式的利与弊)
  • Oracle 11G闪回数据归档新功能详述
  • win平台oracle rman备份和删除dg备库归档日志脚本
  • Oracle相关：Rman Crosscheck删除失效归档
  • Oracle切换为归档模式的步骤及问题解决
    •  
    本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术，将尽最大努力为读者提供更好的信息聚合和浏览方式。
    本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。












  • 相关文章推荐
  • [Oracle] Data Guard 之 三种保护模式介绍
  • Oracle的RBO和CBO详细介绍和优化模式设置方法
  • 每日Oracle：配置日志模式的相关参数log_archive_des
  • Oracle 子程序参数模式,IN,OUT,NOCOPY
  • 将Oracle表空间升级为本地托管模式
  • Oracle 10G streams模式级复制
  • Oracle CBO优化模式中的5种索引访问方法浅析
  • Oracle 12c发布简单介绍及官方下载地址
  • 在linux下安装oracle,如何设置让oracle自动启动！也就是让oracle那个服务自动启动，不是手动的
  • oracle 11g最新版官方下载地址
  • 请问su oracle 和su - oracle有什么不同？
  • Oracle 数据库(oracle Database)Select 多表关联查询方式
  • 虚拟机装Oracle R12与Oracle10g
  • Oracle的RBO和CBO详细介绍和优化模式设置方法 iis7站长之家
  • Oracle 数据库开发工具 Oracle SQL Developer
  • 如何设置让Oracle SQL Developer显示的时间包含时分秒
  • Oracle EBS R12 支持 Oracle Database 11g
  • Oracle 10g和Oracle 11g网格技术介绍
  • SCO unix下安装oracle，但没有光盘，请大家推荐一个oracle下载站点（unix版本的）。谢谢！！！！
  • oracle中如何把表中具有相同值列的多行数据合并成一行
  • 请问大家用oracle数据库, 用import oracle.*;下的东西么? 还是用标准库?
  • Oracle 数据库(oracle Database)性能调优技术详解
  • Linux /$ORACLE_HOME $ORACLE_HOME
  • ORACLE日期相关操作
  • Linux系统下Oracle的启动与Oracle监听的启动
  • ORACLE数据库常用字段数据类型介绍
  • 请问在solaris下安装ORACLE，用root用户和用oracle用户安装有什么区别么？
  • Oracle 12c的九大最新技术特性介绍
  • 网间Oracle的连接，远程连接Oracle服务器？？


    • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除！

    ©2012-2021,