Oracle 11G RAC 修改归档模式

Oracle 11G R2 RAC修改归档模式库建好以后默认是非归档模式，需要修改一下推荐阅读：Oracle 11G RAC OCR 与 db_unique_name 配置关系说明 http://www.linuxidc.com/Linux/2013-07/87595.htm重新配置与卸载Oracle 11GR2 Grid Infrastructure http://www.linuxidc.com/Linux/2013-07/87533.htm
测试第一种方法：SQL> archive log list;Database log mode No Archive ModeAutomatic archival DisabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 19Current log sequence 20SQL>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 2583268SQL>SQL> conn / as sysdbaConnected.SQL> archive log list;Database log mode No Archive ModeAutomatic archival DisabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 20Current log sequence 21SQL> show parameter USE_DB_RECOVERY_FILE_DESTSQL> show parameter DB_RECOVERY_FILE_DESTNAME TYPE VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest string +FRAdb_recovery_file_dest_size big integer 5GSQL>SQL> show parameter LOG_ARCHIVE_STARTNAME TYPE VALUE------------------------------------ ----------- ------------------------------log_archive_start boolean FALSESQL>SQL> host srvctl stop database -d momoracSQL> host srvctl status database -d momoracInstance momo1 is not running on node node1Instance momo2 is not running on node node2Instance momo3 is not running on node node3SQL> show user;USER is "SYS"SQL> startup mount exclusiveORA-03135: connection lost contactSQL> conn / as sysdbaConnected to an idle instance.SQL>SQL> startup mount exclusiveORACLE instance started.Total System Global Area 297119744 bytesFixed Size 1344540 bytesVariable Size 184552420 bytesDatabase Buffers 104857600 bytesRedo Buffers 6365184 bytesDatabase mounted.SQL> host srvctl status database -d momoracInstance momo1 is running on node node1Instance momo2 is not running on node node2Instance momo3 is not running on node node3SQL>SQL> select OPEN_MODE from v$database;OPEN_MODE--------------------MOUNTEDSQL>SQL> conn / as sysdbaConnected to an idle instance.SQL>SQL> startup mount exclusive restrict;ORACLE instance started.Total System Global Area 297119744 bytesFixed Size 1344540 bytesVariable Size 184552420 bytesDatabase Buffers 104857600 bytesRedo Buffers 6365184 bytesDatabase 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 2013NOTE: Loaded library: SystemFri Jun 07 14:58:27 2013SUCCESS: diskgroup ASM1 was mountedFri Jun 07 14:58:28 2013NOTE: dependency between database momorac and diskgroup resource ora.ASM1.dg is establishedFri Jun 07 14:58:34 2013Successful mount of redo thread 1, with mount id 1497705681Database mounted in Shared Mode （CLUSTER_DATABASE=TRUE）Lost write protection disabledFri Jun 07 14:58:35 2013Completed: ALTER DATABASE MOUNTSQL>SQL> alter database archivelog;Database altered.Completed: ALTER DATABASE MOUNTFri Jun 07 15:00:17 2013alter database archivelogCompleted: alter database archivelogSQL> shutdown immediateORA-01109: database not openDatabase dismounted.ORACLE instance shut down.SQL>SQL> host srvctl start database -d momoracSQL> host srvctl status database -d momoracInstance momo1 is running on node node1Instance momo2 is running on node node2Instance momo3 is running on node node3SQL>SQL> conn / as sysdbaConnected.SQL> archivg log list;SP2-0734: unknown command beginning "archivg lo..." - rest of line ignored.SQL> archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 20Next log sequence to archive 21Current log sequence 21SQL>node2 node3上查看一下[oracle@node2 ~]$ db_envmomo2ORACLE_SID= momo2[oracle@node2 ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 7 15:05:33 2013Copyright （c） 1982, 2011, Oracle. All rights reserved.SQL> conn / as sysdbaConnected.SQL> archiveg log list;SP2-0734: unknown command beginning "archiveg l..." - rest of line ignored.SQL> archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 14Next log sequence to archive 15Current log sequence 15SQL>[oracle@node3 ~]$ db_envmomo3ORACLE_SID= momo3[oracle@node3 ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 7 15:05:25 2013Copyright （c） 1982, 2011, Oracle. All rights reserved.SQL> conn / as sysdbaConnected.SQL> archiveg log list;SP2-0734: unknown command beginning "archiveg l..." - rest of line ignored.SQL> archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 7Next log sequence to archive 8Current log sequence 8SQL>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#--------- ---------- -------------------- --------- ------------ ------------------ ---------------MOMORAC 3 READ WRITE 04-JUN-13 ARCHIVELOG 2869044 2583268MOMORAC 1 READ WRITE 04-JUN-13 ARCHIVELOG 2869044 2583268MOMORAC 2 READ WRITE 04-JUN-13 ARCHIVELOG 2869044 2583268SQL>这样竟然也可以？SQL> alter system switch logfile;System altered.SQL>

ORA-38760错误解决MySQL Cluster安装配置相关资讯 Oracle 11g RAC

Oracle 11g RAC 启动时无法识别ASM （今 15:36）
Oracle 11g RAC跨实例控制并行（04月22日）
Oracle 11g RAC 二节点root.sh执行（12/27/2015 18:47:25）

Oracle 11g RAC 应用补丁简明版（09月23日）
Oracle 11g RAC安装注意事项杂记（12/27/2015 18:49:31）
Oracle 11g RAC自动打GI PSU补丁（（12/27/2015 18:43:50）

本文评论查看全部评论（0）