Database Administration (MOSC)

MOSC Banner

Database parameter file issue

Hi

I am using Oracle 12c in Oracle Linux 7.2. using spfile.

SQL> show parameter spfile;

NAME TYPE VALUE

spfile string /u01/app/oracle/product/12.2.0
.1/db_1/dbs/spfilestbydb.ora

I have issue about database parameter file. Up to database in mount mode it shows as under:

log_archive_dest_3 string

When Database in open mode it shows as under :

log_archive_dest_3 string service="stbydb2", ASYNC NOAFF
IRM delay=0 optional compressi
on=disable max_failure=0 max_c
onnections=1 reopen=300 db_uni
que_name="stbydb2" net_timeout
=30, valid_for=(online_logfile
,all_roles)

Why is it happening? I don't want to keep log_archive_dest_3 , so I have omitted it using pfile then convert into spfile and then shut down and restart. up up mount mode log_archive_dest_3 is not available but on open mode it shows.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center