將資料庫調整為archive模式

（0）檢視當前資料庫是否為歸檔模式

[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 17 02:08:05 2014

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SYS@PROD1> archive log list

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 21

Current log sequence 22

（1）將該例項的cluster_database設定為false:

[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 17 01:52:47 2014

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SYS@PROD1> alter system set cluster_database=false scope=spfile sid=‘prod1';

System altered.

(2)關閉所有訪問該資料庫的例項：

[oracle@node1 ~]$ su - grid

[grid@node1 ~]$ srvctl stop database -d prod

(3)使用本地例項掛載資料庫：

[grid@node1 ~]$ su - oracle

[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 17 02:04:50 2014

Connected to an idle instance.

SYS@PROD1> startup mount

ORACLE instance started.

Total System Global Area 1269366784 bytes

Fixed Size 2227984 bytes

Variable Size 838861040 bytes

Database Buffers 419430400 bytes

Redo Buffers 8847360 bytes

Database mounted.

(4)啟動archive

SYS@PROD1> alter database archivelog;

Database altered.

(5)將例項prod1的引數cluster_database設為為true：

SYS@PROD1> alter system set cluster_database=true scope=spfile sid='prod1';

System altered.

(6) 關閉本地例項：

SYS@PROD1> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

(7) 啟動所有例項

[grid@node1 ~]$ srvctl start database -d prod

(8) 檢視啟動歸檔日誌後的結果

[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 17 02:08:05 2014

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SYS@PROD1> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 21
Next log sequence to archive 22
Current log sequence 22

RAC下啟動日誌歸檔模式

相關文章