【问题】: (FAQ)如何启用/关闭Oracle归档模式
版本: 6.0
模块: 系统部署
【答复】:
解决方案： SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 101782828 bytes Fixed Size 451884 bytes Variable Size 37748736 bytes Database Buffers 62914560 bytes Redo Buffers 667648 bytes Database mounted. SQL> alter database noarchivelog; //此处为关闭归档模式。如果是启用归档模式，此处为alter database archivelog;，其他步骤相同。 Database altered. SQL> alter database open; Database altered. SQL> archive log list; Database log mode No Archive Mode Automatic archival Enabled Archive destination /opt/oracle/oradata/conner/archive Oldest online log sequence 149 Current log sequence 152

解决方案： SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 101782828 bytes Fixed Size 451884 bytes Variable Size 37748736 bytes Database Buffers 62914560 bytes Redo Buffers 667648 bytes Database mounted. SQL> alter database noarchivelog; //此处为关闭归档模式。如果是启用归档模式，此处为alter database archivelog;，其他步骤相同。 Database altered. SQL> alter database open; Database altered. SQL> archive log list; Database log mode No Archive Mode Automatic archival Enabled Archive destination /opt/oracle/oradata/conner/archive Oldest online log sequence 149 Current log sequence 152