archive logs not get copied on standby database in a dataguard configuration.
Hi All,
I am trying for first time, to create physical standby database using data guard feature of oracle on windows box.
As I am fresher in dba field, to keep it simple I am doing it on same box.
Issue:
1) Archive logs are getting created on primary database in archive folder specified “LOG_ARCHIVE_DEST_1" parameter in pfile of primary database.
But on standby database I am not able to see archive logs and they are not getting copied there.
2) What things need to be done so that archive logs will get copied on standby database?
3) Do I initializing the both database using wrong "redo transport, redo apply and role management parameters"?
How should I initialize following parameters in data guard configuration?
LOG_ARCHIVE_DEST_1
LOG_ARCHIVE_DEST_2
FAL_SERVER=
FAL_CLIENT=
db_file_name_convert=
log_file_name_convert
LOG_ARCHIVE_FORMAT
regards,
knp_11
archive logs not get copied on standby database in a dataguard configuration. Reply
Hi Paul
Thanks for such detailed information.Actually I was trying on one system since last 15 days but coulden't get through so moved to two box configuration on linux
1)I have installed "PRIM" database on primary and on standby installed without starter database.
2)I configured pfile for primary ie. added parameters needed for dataguard configuration also created net service for it and created listner for it
3)I started the database using modified pfile(which contain parameters for dataguard)
4)created spfile and mounted database using spfile
5)I enabled log archive mode and force logging on primary and logs are getting generated at the location specifed in LOG_ARCHIVE_DEST_1 in primary pfile.
6)On standby :I created pfile for standby and then transfered it to standby then modified it for datagurd configuration and standby database was mounted using that pfile then created spfile and mounted database using that spfile.
7)I also cretated listner and net service on standby and my standby server is running fine
8)But when I "alter database recover managed standby database disconnect from session;" on standby i found no logs getting generated on standby
9)I think somehow log transport service is not able to transport the archived logs to standby server
These are some link I refered
http://www.orafaq.com/node/2030
http://www.singlequery.com/2008/06/s...rd-enviroment/
I have few questions for you.
1)Do we need to create listners for primary and standby on primary server and on standby server also
or
On primary server, listner for primary only
On standby server, listner for standby only
2)I have taken cold backup and also tried with RAMAN backup from primary to secondary does it make difference?
3)Can you send me any link which can help me
4)How can I troubleshoot this issue as when I was doing it on single box same thing was happening and now on two box configurastion also it is there
I think I am not initilizing datagurad parameters in the pfiles properly
regards,
NandyK