Friday, September 11, 2009

Remove the obsolete parameter in SPFILE!

Message:
Code:
ORA-32004: obsolete and/or deprecated parameter(s) specified
Khi chúng ta set lại một số các parameter của DB trong SPFILE, giả sử switch Database sang trạng thái Archive..
Code:
SQL>Shutdown immediate
....
Instance shutdown.
SQL> Startup mount
....
Oracle Instance mounted.
SQL> Alter database archivelog;
Database archived.
SQL> Alter system set log_archive_dest='D:\Archive' scope=spfile;
System altered.
SQL> Alter system set log_archive_start=TRUE scope=spfile;
System altered.
SQL> Alter database open;
Database altered.
....

SQL>Shutdown immediate
....
Instance shutdown.
SQL> Startup mount
....
[b]ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.[/b]
Total System Global Area 524288000 bytes
Fixed Size 1249920 bytes
Variable Size 146804096 bytes
Database Buffers 369098752 bytes
Redo Buffers 7135232 bytes
Database mounted.
Hãy giải quyết dòng message đó. Rất đơn giản.

Code:

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 524288000 bytes
Fixed Size 1249920 bytes
Variable Size 155192704 bytes
Database Buffers 360710144 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.
SQL>

No comments: