can an spfile file call an ifile for logging parameters?
I am finding that in 11g if I am using a regular pfile and I calll an ifile as follows:
IFILE=/test/db/testdb/11.2.0/dbs/TEST_orat2000b_ifile.ora
in 11g inside the ifile I have this:
*.log_archive_dest_1='LOCATION=/test/db/testarch/ MANDATORY REOPEN=120'
*.log_archive_dest_2='LOCATION=/hotbackup/db/testarch/ OPTIONAL'
*.log_archive_format='arch_%t_%s_%r.arc'
it all works fine. But if a start with this combo of pfile/ifile, and I do a "create spfile from pfile='initTEST.ora'
and then recreate a pfile from it, it seems to incorporate the 3 lines /values of the ifile into the (dynamic) pfile, and
the line for IFILE= goes away.
I am ok with this if it is how it is supposed to work-- but is this correct? In other words an spfile incporporates the
value of the ifile and throws it away?
The idea of creating a separate ifile was to keep some instances (eg non-prod) from NOT automatically logging.
I can always just create a pfile, throw out any logging params for the non-prod instanace, and restart, but I was
curious if anybody has seen this behavior.