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>
