Oracle10g自動歸檔的設置
2024-08-29 13:38:02
供稿：網友
在Oracle10i中原有的log_archive_start參數已經廢棄，對于archive log mode來說我們只需要設置log_archive_format和log_archive_dest_N參數，然后在數據庫mount狀態下執行alter database archivelog;即可將數據庫設置成archive log mode，Oracle將會自動歸檔， 相反使用alter database noarchivelog;即可。
以上操作數據庫重起后依然有效。下面是演示過程。
SQL> startup mount
ORACLE instance started.
Total System Global Area 399927208 bytes
Fixed Size 1284008 bytes
Variable Size 318767104 bytes
Database Buffers 33554432 bytes
Redo Buffers 46321664 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> show parameter archive_start
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_start boolean FALSE
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /data4/oracle10/app/PRodUCt/10.0.0/dbs/arch
Oldest online log sequence 92
Next log sequence to archive 94
Current log sequence 94
SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 399927208 bytes
Fixed Size 1284008 bytes
Variable Size 318767104 bytes
Database Buffers 33554432 bytes
Redo Buffers 46321664 bytes
Database mounted.
Database opened.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /data4/oracle10/app/product/10.0.0/dbs/arch
Oldest online log sequence 92
Next log sequence to archive 94
Current log sequence 94
SQL> !ls arch
1_92_496877985.dbf arch_1_93_496877985.arc
SQL> alter system archive log current;
System altered.
SQL> !ls arch
1_92_496877985.dbf arch_1_93_496877985.arc arch_1_94_496877985.arc
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> !ls arch
1_92_496877985.dbf arch_1_94_496877985.arc arch_1_96_496877985.arc arch_1_98_496877985.arc
arch_1_93_496877985.arc arch_1_95_496877985.arc arch_1_97_496877985.arc arch_1_99_496877985.arc
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 399927208 bytes
Fixed Size 1284008 bytes
Variable Size 318767104 bytes
Database Buffers 33554432 bytes
Redo Buffers 46321664 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 Disabled
Archive destination /data4/oracle10/app/product/10.0.0/dbs/arch
Oldest online log sequence 93
Current log sequence 95
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 399927208 bytes
Fixed Size 1284008 bytes
Variable Size 318767104 bytes
Database Buffers 33554432 bytes
Redo Buffers 46321664 bytes
Database mounted.
Database opened.
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /data4/oracle10/app/product/10.0.0/dbs/arch
Oldest online log sequence 93
Current log sequence 95
SQL>
