RAC 开启、关闭归档

RAC 切换归档模式：

实验环境：11.2.0.4 rac

rac 开启归档日志

1.查询归档模式

SQL> archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            +FRA

Oldest online log sequence     3

Current log sequence           4

2.关闭数据库实例

[oracle@qlzqrac1 ~]$ srvctl stop database-d lxs

3.启动数据库实例到mount状态

[oracle@qlzqrac1 ~]$  srvctl start database -d lxs -o mount

4.开启归档

[oracle@qlzqrac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production onTue Nov 17 01:09:18 2015

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

Connected to:

Oracle Database 11g Enterprise EditionRelease 11.2.0.4.0 - 64bit Production

With the Partitioning, Real ApplicationClusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testingoptions

SQL> alter database archivelog;

Database altered.

 

SQL> exit

Disconnected from Oracle Database 11gEnterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real ApplicationClusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testingoptions

5.关闭数据库实例

[oracle@qlzqrac1 ~]$ srvctl stop database-d lxs

6.打开数据库实例

[oracle@qlzqrac1 ~]$ srvctl start database-d lxs

7.查询归档模式是否开启

[oracle@qlzqrac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production onTue Nov 17 01:11:13 2015

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

Connected to:

Oracle Database 11g Enterprise EditionRelease 11.2.0.4.0 - 64bit Production

With the Partitioning, Real ApplicationClusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testingoptions

SQL> archive log list

Database log mode             Archive Mode

Automatic archival             Enabled

Archive destination            +FRA

Oldest online log sequence     3

Next log sequence to archive   4

Current log sequence           4

rac 关闭归档

1.查询归档模式

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            +FRA

Oldest online log sequence     3

Next log sequence to archive   4

Current log sequence           4

2.关闭数据库实例

[oracle@qlzqrac1 ~]$ srvctl stop database-d lxs

3.启动数据库实例到mount状态

[oracle@qlzqrac1 ~]$  srvctl start database -d lxs -o mount

4.关闭归档（非归档模式）

[oracle@qlzqrac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production onTue Nov 17 01:09:18 2015

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

Connected to:

Oracle Database 11g Enterprise EditionRelease 11.2.0.4.0 - 64bit Production

With the Partitioning, Real ApplicationClusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testingoptions

SQL> alter database NOARCHIVELOG;

Database altered.

SQL> exit

Disconnected from Oracle Database 11gEnterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real ApplicationClusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testingoptions

5.关闭数据库实例

[oracle@qlzqrac1 ~]$ srvctl stop database-d lxs

6.打开数据库实例

[oracle@qlzqrac1 ~]$ srvctl start database-d lxs

7.查询是否处于非归档模式

[oracle@qlzqrac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production onTue Nov 17 01:11:13 2015

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

Connected to:

Oracle Database 11g Enterprise EditionRelease 11.2.0.4.0 - 64bit Production

With the Partitioning, Real ApplicationClusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testingoptions

SQL> archive log list;

Database log mode              NoArchive Mode

Automatic archival             Disabled

Archive destination            +FRA

Oldest online log sequence     3

Current log sequence           4

SQL>