Oracle 11G RAC 修改归档模式
Oracle 11G R2 RAC修改归档模式 库建好以后默认是非归档模式，需要修改一下 推荐阅读： Oracle 11G RAC OCR 与 db_unique_name
Oracle 11G R2 RAC修改归档模式
库建好以后默认是非归档模式，需要修改一下
推荐阅读：
Oracle 11G RAC OCR 与 db_unique_name 配置关系 说明
重新配置与卸载Oracle 11GR2 Grid Infrastructure
测试第一种方法：
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 19
Current log sequence 20
SQL>
SQL> Select NAME, CREATED, LOG_MODE, CHECKPOINT_CHANGE#, ARCHIVE_CHANGE# from V$DATABASE;
NAME CREATED LOG_MODE CHECKPOINT_CHANGE# ARCHIVE_CHANGE#
--------- --------- ------------ ------------------ ---------------
MOMORAC 04-JUN-13 NOARCHIVELOG 2709486 2583268
SQL>
SQL> conn / as sysdba
Connected.
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 20
Current log sequence 21
SQL> show parameter USE_DB_RECOVERY_FILE_DEST
SQL> show parameter DB_RECOVERY_FILE_DEST
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +FRA
db_recovery_file_dest_size big integer 5G
SQL>
SQL> show parameter LOG_ARCHIVE_START
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_start boolean FALSE
SQL>
SQL> host srvctl stop database -d momorac
SQL> host srvctl status database -d momorac
Instance momo1 is not running on node node1
Instance momo2 is not running on node node2
Instance momo3 is not running on node node3
SQL> show user;
USER is "SYS"
SQL> startup mount exclusive
ORA-03135: connection lost contact
SQL> conn / as sysdba
Connected to an idle instance.
SQL>
SQL> startup mount exclusive
ORACLE instance started.
Total System Global Area 297119744 bytes
Fixed Size 1344540 bytes
Variable Size 184552420 bytes
Database Buffers 104857600 bytes
Redo Buffers 6365184 bytes
Database mounted.
SQL> host srvctl status database -d momorac
Instance momo1 is running on node node1
Instance momo2 is not running on node node2
Instance momo3 is not running on node node3
SQL>
SQL> select OPEN_MODE from v$database;
OPEN_MODE
--------------------
MOUNTED
SQL>
SQL> conn / as sysdba
Connected to an idle instance.
SQL>
SQL> startup mount exclusive restrict;
ORACLE instance started.
Total System Global Area 297119744 bytes
Fixed Size 1344540 bytes
Variable Size 184552420 bytes
Database Buffers 104857600 bytes
Redo Buffers 6365184 bytes
Database mounted.
SQL>
同时看日志 ：
ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.101.5.73)(PORT=1521))))' SCOPE=MEMORY SID='momo1';
Fri Jun 07 14:58:27 2013
NOTE: Loaded library: System
Fri Jun 07 14:58:27 2013
SUCCESS: diskgroup ASM1 was mounted
Fri Jun 07 14:58:28 2013
NOTE: dependency between database momorac and diskgroup resource ora.ASM1.dg is established
Fri Jun 07 14:58:34 2013
Successful mount of redo thread 1, with mount id 1497705681
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Lost write protection disabled
Fri Jun 07 14:58:35 2013
Completed: ALTER DATABASE MOUNT
SQL>
SQL> alter database archivelog;
Database altered.
Completed: ALTER DATABASE MOUNT
Fri Jun 07 15:00:17 2013
alter database archivelog
Completed: alter database archivelog
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> host srvctl start database -d momorac
SQL> host srvctl status database -d momorac
Instance momo1 is running on node node1
Instance momo2 is running on node node2
Instance momo3 is running on node node3
SQL>
SQL> conn / as sysdba
Connected.
SQL> archivg log list;
SP2-0734: unknown command beginning "archivg lo..." - rest of line ignored.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 20
Next log sequence to archive 21
Current log sequence 21
SQL>
node2 node3上查看一下
[oracle@node2 ~]$ db_env
momo2
ORACLE_SID= momo2
[oracle@node2 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 7 15:05:33 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> archiveg log list;
SP2-0734: unknown command beginning "archiveg l..." - rest of line ignored.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 14
Next log sequence to archive 15
Current log sequence 15
SQL>
[oracle@node3 ~]$ db_env
momo3
ORACLE_SID= momo3
[oracle@node3 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 7 15:05:25 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> archiveg log list;
SP2-0734: unknown command beginning "archiveg l..." - rest of line ignored.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 7
Next log sequence to archive 8
Current log sequence 8
SQL>
SQL> Select NAME, INST_ID, OPEN_MODE, CREATED, LOG_MODE, CHECKPOINT_CHANGE#, ARCHIVE_CHANGE# from GV$DATABASE;
NAME INST_ID OPEN_MODE CREATED LOG_MODE CHECKPOINT_CHANGE# ARCHIVE_CHANGE#
--------- ---------- -------------------- --------- ------------ ------------------ ---------------