Oracle學習系列—歸檔模式的切換

說來很慚愧，Oracle也算學習了很久，可是我連歸檔日誌都沒用起來過，所以說都不好意思說自己的Oracle水平如何如何。。。

參閱了網上許多資料，親自動手做了一下測試，可以說既不簡單也不復雜。。。

一句話動手最重要。。。

來吧。。。

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Mar 14 00:31:13 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

REM以系統管理員使用者登陸Oracle，並啟動到mount狀態
SQL> connect as sysdba;
Enter user-name: sys
Enter password:
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 152115804 bytes
Fixed Size 453212 bytes
Variable Size 117440512 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.

REM操作設定資料庫為歸檔模式
SQL> alter database archivelog;

Database altered.

REM檢視歸檔狀態
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Disabled
Archive destination C:/UserDefine/oracle/ora92/RDBMS
Oldest online log sequence 7
Next log sequence to archive 9
Current log sequence 9

REM開啟資料庫
SQL> alter database open;

Database altered.

REM修改log_archive_dest歸檔路徑引數
SQL> alter system set log_archive_dest='C:/UserDefine/oracle/ora92/database/arch
ive';

System altered.

REM修改log_archive_start歸檔啟動引數
SQL> alter system set log_archive_start=true scope=spfile;

System altered.

REM修改後關閉重啟，檢視相應的狀態
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 152115804 bytes
Fixed Size 453212 bytes
Variable Size 117440512 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.

REM顯示歸檔各個引數的值
SQL> show parameter archive;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_dest string C:/UserDefine/oracle/ora92/dat
abase/archive
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string ARC%S.%T
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean TRUE
log_archive_trace integer 0
remote_archive_enable string true
standby_archive_dest string %ORACLE_HOME%RDBMS

REM從例項資料字典表檢視歸檔狀態
SQL>select archiver from v$instance

ARCHIVE
-------
STARTED

REM從資料庫資料字典表檢視歸檔狀態
SQL>select log_mode from v$database

LOG_MODE
-----------
ARCHIVELOG