RAM >SHOW PARAMETER log_archive_format

NAME                                 TYPE        VALUE

------------------------------------ ----------- -------------

log_archive_format                   string      ARC%S_%R.%T

 

RAM >SELECT name, value, issys_modifiable

  2  FROM v$parameter

  3  WHERE name = 'log_archive_format' ;

 

NAME                 VALUE        ISSYS_MOD
------------------- -----------   -------------------- log_archive_format   ARC%S_%R.%T   FALSE 

ALTER SYSTEM SET log_archive_format = 'RAM' SCOPE = SPFILE ;

System altered.

RAM >SELECT name, value

  2  FROM v$spparameter

  3  WHERE name = 'log_archive_format' ;

 

NAME                 VALUE

-------------------- -------------

log_archive_format   RAM 

RAM >CONN / AS SYSDBA

Connected.

SYS >SHUTDOWN IMMEDIATE

Database closed.

Database dismounted.

ORACLE instance shut down.

 

SYS >STARTUP

ORA-19905: log_archive_format must contain %s, %t and %r

SYS >SELECT status FROM v$instance ;

SELECT status FROM v$instance

*

ERROR at line 1:

ORA-01034: ORACLE not available

Process ID: 0

Session ID: 50 Serial number: 1740

SYS >CREATE PFILE FROM SPFILE ;

File created.

SYS >CREATE SPFILE FROM PFILE ;

File created.

 

SYS >STARTUP

ORACLE instance started.

 

Total System Global Area  535662592 bytes

Fixed Size                  1375792 bytes

Variable Size             306184656 bytes

Database Buffers          222298112 bytes

Redo Buffers                5804032 bytes

Database mounted.

Database opened.

SYS >SELECT status FROM v$instance ;

 

STATUS

------------

OPEN