oracle 11g rac 切换归档模式
由归档模式切换到非归档模式1. 查看当前的状态sys@RACDB>archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 13Next log sequence to archive 14Current log sequence 142. 停止所有的节点的实例并启动到mount[grid@rac1 ~]$ srvctl stop database -dracdb[grid@rac1 ~]$ srvctl start database -dracdb -o mount此时用两个节点查询实例状态分别是节点一idle>select instance_name,status fromv$instance; INSTANCE_NAME STATUS---------------- ------------racdb1 MOUNTED节点二idle>select instance_name,status fromv$instance; INSTANCE_NAME STATUS---------------- ------------racdb2 MOUNTED3. 修改数据库到非归档模式idle>alter database noarchivelog; Database altered.4. 重新启动数据库到open[grid@rac1 ~]$ srvctl stop database -dracdb[grid@rac1 ~]$ srvctl start database -dracdb5. 查看修改后数据库的归档模式sys@RACDB>archive log list;Database log mode No Archive ModeAutomatic archival DisabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 14Current log sequence 15