Research on Oracle 10g archive parameters

The parameters discussed in this article are:

Log_archive_dest

Log_archive_dest_n

Log_archive_start

Db_recovery_file_dest

Oracle version:

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 Enterprise Edition

Sql> Show Parameter SPFile

NAME TYPE VALUE

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

SPFile string/export/home/oracledb/oracle/p Roduct/10.2.0/dbs/spfileorcl.ora

The SPFile parameter is used.

Sql> alter system set log_archive_dest_1= ' Location=/export/home/arch ';

System altered.

Sql> alter system set log_archive_dest_1= '; #置为空的时候, no location words.

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: