oracle 归档 reset,oracle开启归档排错

SQL> startup mount force;-----//没有正常关闭导致后面报错

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  2095704 bytes

Variable Size             134219176 bytes

Database Buffers          142606336 bytes

Redo Buffers                6291456 bytes

Database mounted.

SQL>

SQL> alter database archivelog;

alter database archivelog

*

ERROR at line 1:

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

SQL>    ---非正常关闭导致需要重新打开数据库，使数据文件，控制文件，日志文件同步，再修改归档模式。

SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORACLE instance started.  ---报错不知啥意思 查看错误日志

Total System Global Area  285212672 bytes

Fixed Size                  2095704 bytes

Variable Size             134219176 bytes

Database Buffers          142606336 bytes

Redo Buffers                6291456 bytes

Database mounted.

SQL>

SQL> alter database open;

Database altered.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  2095704 bytes

Variable Size             134219176 bytes

Database Buffers          142606336 bytes

Redo Buffers                6291456 bytes

Database mounted.

SQL> archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            /oradata/arch

Oldest online log sequence     22

Current log sequence           24

SQL> alter database open;

Database altered.

SQL> archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            /oradata/arch

Oldest online log sequence     22

Current log sequence           24

SQL>

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  2095704 bytes

Variable Size             134219176 bytes

Database Buffers          142606336 bytes

Redo Buffers                6291456 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            /oradata/arch

Oldest online log sequence     22

Next log sequence to archive   24

Current log sequence           24

SQL> !oerr ora 32004         ---查看报错的详细信息

32004, 00000, "obsolete and/or deprecated parameter(s) specified"

// *Cause:  One or more obsolete and/or parameters were specified in

//          the SPFILE or the PFILE on the server side.

// *Action: See alert log for a list of parameters that are obsolete.

//          or deprecated. Remove them from the SPFILE or the server

//          side PFILE.

--log_archive_start这个参数不需要我们设置导致报错 取消这个参数的设置

自动开始归档，不需要设置log_archive_start参数

SQL> alter system reset log_archive_start scope=spfile sid='*';

System altered.

SQL> shutdown immediate  ---正常关闭在启动测试看还没有错误

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup              ----一切正常

ORACLE instance started.

Total System Global Area  285212672 bytes

Fixed Size                  2095704 bytes

Variable Size             134219176 bytes

Database Buffers          142606336 bytes

Redo Buffers                6291456 bytes

Database mounted.

Database opened.

SQL>