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

原文地址:https://www.cnblogs.com/zougang/p/6626461.html