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.