• oracle11g rac 个性归档模式


    关闭数据库并将一节点启动到mount状态

    [root@QSZAAS-XYORC02 ~]# su - grid
    [grid@QSZAAS-XYORC02 ~]$ srvctl stop database -d xydb
    [grid@QSZAAS-XYORC02 ~]$ srvctl start instance -d xydb -i xydb1 -o mount

    在节点一上进行归档模式修改并打开数据库

    [oracle@QSZAAS-XYORC01 ggs]$ sqlplus /nolog

    SQL*Plus: Release 11.2.0.4.0 Production on 星期一 3月 27 14:08:51 2017

    Copyright (c) 1982, 2013, Oracle. All rights reserved.

    SQL> conn /as sysdba
    Connected.
    SQL> alter database noarchivelog;

    Database altered.

    SQL> alter database open;

    Database altered.

    SQL> archive log list;
    Database log mode No Archive Mode
    Automatic archival Disabled
    Archive destination +FRA
    Oldest online log sequence 1493
    Current log sequence 1496
    SQL>alter system set log_archive_dest_1='location=+FRADG' scope=spfile;

    启动节点二实例:

    [grid@QSZAAS-XYORC02 ~]$ srvctl start instance -d xydb -i xydb2

    查看数据库状态:

    [grid@QSZAAS-XYORC02 ~]$ crsctl status res -t
    --------------------------------------------------------------------------------
    NAME TARGET STATE SERVER STATE_DETAILS
    --------------------------------------------------------------------------------
    Local Resources
    --------------------------------------------------------------------------------
    ora.CRS.dg
    ONLINE ONLINE qszaas-xyorc01
    ONLINE ONLINE qszaas-xyorc02
    ora.DATA.dg
    ONLINE ONLINE qszaas-xyorc01
    ONLINE ONLINE qszaas-xyorc02
    ora.FRA.dg
    ONLINE ONLINE qszaas-xyorc01
    ONLINE ONLINE qszaas-xyorc02
    ora.LISTENER.lsnr
    ONLINE ONLINE qszaas-xyorc01
    ONLINE ONLINE qszaas-xyorc02
    ora.asm
    ONLINE ONLINE qszaas-xyorc01 Started
    ONLINE ONLINE qszaas-xyorc02 Started
    ora.gsd
    OFFLINE OFFLINE qszaas-xyorc01
    OFFLINE OFFLINE qszaas-xyorc02
    ora.net1.network
    ONLINE ONLINE qszaas-xyorc01
    ONLINE ONLINE qszaas-xyorc02
    ora.ons
    ONLINE ONLINE qszaas-xyorc01
    ONLINE ONLINE qszaas-xyorc02
    ora.registry.acfs
    ONLINE ONLINE qszaas-xyorc01
    ONLINE ONLINE qszaas-xyorc02
    --------------------------------------------------------------------------------
    Cluster Resources
    --------------------------------------------------------------------------------
    ora.LISTENER_SCAN1.lsnr
    1 ONLINE ONLINE qszaas-xyorc02
    ora.cvu
    1 ONLINE ONLINE qszaas-xyorc02
    ora.oc4j
    1 ONLINE ONLINE qszaas-xyorc02
    ora.qszaas-xyorc01.vip
    1 ONLINE ONLINE qszaas-xyorc01
    ora.qszaas-xyorc02.vip
    1 ONLINE ONLINE qszaas-xyorc02
    ora.scan1.vip
    1 ONLINE ONLINE qszaas-xyorc02
    ora.xydb.db
    1 ONLINE ONLINE qszaas-xyorc02 Open
    2 ONLINE ONLINE qszaas-xyorc01 Open

  • 相关阅读:
    读《大道至简》有感
    软件工程概论第一次课堂作业
    课后小程序
    继承与多态课后作业
    课后作业2-字符串
    课后作业1:字串加密
    3-类与对象-动手动脑
    使用类的静态字段和构造函数,跟踪某个类所创建对象的个数。
    课程作业02-1-课后作业1-(3、4)汉诺塔、回文数
    课程作业02-2-动手动脑
  • 原文地址:https://www.cnblogs.com/zougang/p/6626461.html
Copyright © 2020-2023  润新知