Parameter standby_archive_dest change won't take effect.
edited Apr 24, 2013 10:59AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 6 commentsAnswered
Hi,
I have two standby databases, one on remote site for disaster recovery purpose, another for local report purpose.
This local one I converted into snapshot standby. Everything looks fine except one problem that the all archived log saved to '?/dbs/arch', not the recovery_area.
The parameter change successful and the database had been shutdwon and restarted. But the change won't take effect and archive log still go to '?/dbs/arch'
The snapshot standby is 'p1108s2'.
Parameters related to archive log:
*.log_archive_config='dg_config=(p1108s2,prd1108,p1108sb1)'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,STANDBY_ROLES) DB_UNIQUE_NAME=p1108s2'
0