I have set up a physical standby database in mount mode, and the archive files are getting generated under ORACLE_HOME/dbs. I figured out the issue as it was a typo while specifying 'log_archive_dest_1' parameter. Now the log_archive_dest_1 parameter is as below. But still the archive files are getting generated under ORACLE_HOME/dbs. Do we need to restart the standby database to fix it?
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
log_archive_config string
log_archive_dest string
log_archive_dest_1 string LOCATION=USE_DB_RECOVERY_FILE_
DEST valid_for=(ONLINE_LOGFIL
E,ALL_ROLES)
log_archive_dest_10 string
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 29560
Next log sequence to archive 0
Current log sequence 29561
Database version:10.2.0.3
Os:linux