本文讨论涉及的参数有:
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: