Oracleæ°æ®åºå¯ä»¥è¿è¡å¨2ç§æ¨¡å¼ï¼å½æ¡£æ¨¡å¼ï¼archivelogï¼åéå½æ¡£æ¨¡å¼ï¼noarchivelogï¼å½æ¡£æ¨¡å¼å¯ä»¥æé«Oracleæ°æ®åºçå¯æ¢å¤æ§ï¼ç产æ°æ®åºé½åºè¯¥è¿è¡å¨æ¤æ¨¡å¼ä¸ï¼å½æ¡£æ¨¡å¼åºè¯¥åç¸åºçå¤ä»½çç¥ç¸ç»åï¼åªæå½æ¡£æ¨¡å¼æ²¡æç¸åºçå¤ä»½çç¥åªä¼å¸¦æ¥éº»ç¦ã Oracleæ°æ®åºå¯ä»¥è¿è¡å¨2ç§æ¨¡å¼ï¼å½æ¡£æ¨¡å¼ï¼archivelogï¼åéå½æ¡£æ¨¡å¼ï¼noarchivelogï¼å½æ¡£æ¨¡å¼å¯ä»¥æé«Oracleæ°æ®åºçå¯æ¢å¤æ§ï¼ç产æ°æ®åºé½åºè¯¥è¿è¡å¨æ¤æ¨¡å¼ä¸ï¼å½æ¡£æ¨¡å¼åºè¯¥åç¸åºçå¤ä»½çç¥ç¸ç»åï¼åªæå½æ¡£æ¨¡å¼æ²¡æç¸åºçå¤ä»½çç¥åªä¼å¸¦æ¥éº»ç¦ã
ä¸é¢ä¸ºå¤§å®¶ç®åä»ç»å¦ä½å¯ç¨åå
³éæ°æ®åºçå½æ¡£æ¨¡å¼ã
1.shutdown normalæshutdown immediateå
³éæ°æ®åº
[oracle@jumper oracle]$ sqlplus "/ as sysdba"
SQL*Plusï¼Release 9.2.0.4.0 - Production on Sat Oct 15 15ï¼48ï¼36 2005
Copyrightï¼cï¼1982ï¼2002ï¼Oracle Corporation. All rights reserved.
Connected toï¼
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
SQL> shutdown immediateï¼
Database closed.
Database dismounted.
ORACLE instance shut down.
2.å¯å¨æ°æ®åºå°mountç¶æ
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.
3.å¯ç¨æåæ¢å½æ¡£æ¨¡å¼
å¦æè¦å¯ç¨å½æ¡£æ¨¡å¼ï¼æ¤å¤ä½¿ç¨
alter database archivelog å½ä»¤ã
SQL> alter database archivelogï¼
Database altered.
SQL> alter database openï¼
Database altered.
SQL> archive log listï¼
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /opt/oracle/oradata/conner/archive
Oldest online log sequence 148
Next log sequence to archive 151
Current log sequence 151å¦æéè¦åæ¢å½æ¡£æ¨¡å¼ï¼æ¤å¤ä½¿ç¨ï¼
alter database noarchivelog å½ä»¤ã
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ï¼
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
4.ä¿®æ¹ç¸åºçåå§ååæ°
Oracle10gä¹åï¼ä½ è¿éè¦ä¿®æ¹åå§ååæ°ä½¿æ°æ®åºå¤äºèªå¨å½æ¡£æ¨¡å¼ã
å¨pfile/spfileä¸è®¾ç½®å¦ä¸åæ°ï¼
log_archive_start = true
éå¯æ°æ®åºæ¤åæ°çæï¼æ¤æ¶æ°æ®åºå¤äºèªå¨å½æ¡£æ¨¡å¼ã
ä¹å¯ä»¥å¨æ°æ®åºå¯å¨è¿ç¨ä¸ï¼æå·¥æ§è¡ï¼
archive log start
使æ°æ®åºå¯ç¨èªå¨å½æ¡£ï¼ä½æ¯éå¯åæ°æ®åºä»ç¶å¤äºæå·¥å½æ¡£æ¨¡å¼ã
温馨提示:答案为网友推荐,仅供参考