11gRAC关闭归档日志

关闭归档日志

1. 在节点1上用grid用户，关闭数据库集群

[root@rac1 ~]$ su - grid
[grid@rac1 ~]$ srvctl stop database -d orcl

2. 将一个节点启动到mount状态，在该节点进行以下操作

[grid@rac1 ~]$ srvctl start instance -d orcl -i orcl1 -o mount

3. 连接到数据库

[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jan 29 14:35:41 2020
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

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            +ARCH
Oldest online log sequence     1
Current log sequence           1

3.在节点1上用grid用户，启动其他节点数据库

[grid@rac1 ~]$ srvctl start instance -d orcl -i orcl2