-- pfile로 startup후 create sp from p
-- ORA-32004 error 발생 시
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-19905: log_archive_format must contain %s, %t and %r
SQL> startup pfile='C:\Oracle\product\11.1.0\db_1\database\initorcl.ora';
SQL> create spfile='spfileorcl.ora'
2 from pfile;
File created.
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1334380 bytes
Variable Size 167773076 bytes
Database Buffers 360710144 bytes
Redo Buffers 5844992 bytes
Database mounted.