Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

archive log mode in oracle 10g on windows environment

Nagarjuna ReddyFeb 15 2011 — edited Feb 15 2011

Hi All,

I have a production database (Oracle 10g 10.2.0.1.0) on windows 2003 server. yesterday i put the database into archivelog mode. when i query for spfile location it is shown in ORACLE_HOME\dbs location.
but when i created pfile using the spfile it is created at ORACLE_HOME\database location. and there is another spfile also. i set the log_archive_dest at a location other than flash_recovery_area in pfile, but it is showing the DB_RECOVER_AREA.

today i seen archives are creating in both locations.

can a database have two spfiles. and working on them ?

can i remove a spfile in /dbs location.

pls. give me suggestion to rectify this

thanks and regards.

This post has been answered by Aman.... on Feb 15 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 15 2011

Added on Feb 15 2011

#general-database-discussions

7 comments

2,111 views