Standby log archival issue on physical standby database
edited May 28, 2013 3:55PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered
Hi
We have a physical standby database, it is 11.2.0.2, when we issued the command
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;
it created a STANDBY redolog group with one logfile at the archivelog destinations but when it tried to archive this log, it errored out "No available destinations"
any idea will be highly appreciated
we have 3 archive destinations, one is FRA and the other one is normal and the 3rd one is for service
like
*.log_archive_config='dg_config=(PRD_HKERPR01,PRD_HKERPP00)'
*.log_archive_dest_1='LOCATION=/oracle/PRD/saparch/PRD_HKERPR01 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRD_HKERPR01'
We have a physical standby database, it is 11.2.0.2, when we issued the command
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH FORCE;
it created a STANDBY redolog group with one logfile at the archivelog destinations but when it tried to archive this log, it errored out "No available destinations"
any idea will be highly appreciated
we have 3 archive destinations, one is FRA and the other one is normal and the 3rd one is for service
like
*.log_archive_config='dg_config=(PRD_HKERPR01,PRD_HKERPP00)'
*.log_archive_dest_1='LOCATION=/oracle/PRD/saparch/PRD_HKERPR01 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRD_HKERPR01'
0