今天,设置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
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
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;
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.
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;
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
修改完成。
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/