Oracle 10G的log_archive_format参数

今天，设置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
修改完成。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/81227/viewspace-697784/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/81227/viewspace-697784/