關於Oracle 10g歸檔參數的研究

本文討論涉及的參數有：

log_archive_dest

log_archive_dest_n

log_archive_start

db_recovery_file_dest

Oracle版本：

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod

PL/SQL Release 10.2.0.2.0 - Production

CORE    10.2.0.2.0      Production

TNS for Solaris: Version 10.2.0.2.0 - Production

NLSRTL Version 10.2.0.2.0 – Production

Oracle為10g的企業版

SQL> show parameter spfile

NAME   TYPE                   VALUE

----------------------------------- ---------------------- ------------------------------

spfile  string     /export/home/oracledb/oracle/p roduct/10.2.0/dbs/spfileorcl.ora

使用的是spfile參數。

SQL> alter system set log_archive_dest_1='location=/export/home/arch';

System altered.

SQL> alter system set log_archive_dest_1=''; #置為空白的時候, 沒有location字樣.

System altered.

SQL> alter system set log_archive_dest='/export/home/arch';

alter system set log_archive_dest='/export/home/arch'

*

ERROR at line 1: