今天，設定Oracle10G資料庫到Archive Log模式：

SQL> alter system set LOG_ARCHIVE_DEST_1='LOCATION= /path/arch' scope=both;
alter system set LOG_ARCHIVE_DEST_1='LOCATION= /path/arch' scope=both
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE

SQL> alter system set LOG_ARCHIVE_DEST_1='LOCATION=/path/arch' scope=both;

System altered.

SQL> Alter system set log_archive_start=true scope=spfile;

System altered.

SQL> alter system set log_archive_format='arch_%t_%s.dbf' scope= spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-19905: log_archive_format must contain %s, %t and %r

SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-19905: log_archive_format must contain %s, %t and %r

原來，log_archive_format='arch_%t_%s.dbf' 是按照Oracle 9i的文件設的，Oracle 10G對此引數設定要求發生了變化。

SQL> conn / as sysdba
Connected to an idle instance.
SQL> create pfile='/tmp/init.ora' from spfile;

File created.

修改/tmp/init.ora檔案，將log_archive_format引數設定成“arch_%t_%s.%r.dbf ”

SQL> create spfile from pfile='/tmp/init.ora';

File created.

SQL> startup mount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 1241513984 bytes
Fixed Size                  1267212 bytes
Variable Size             318769652 bytes
Database Buffers          905969664 bytes
Redo Buffers               15507456 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /path/arch
Oldest online log sequence     166
Next log sequence to archive   168
Current log sequence           168
修改完成。

Oracle 10G的log_archive_format引數

相關文章