archive logs not get copied on standby database in a dataguard configuration.
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.
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?
As a beginner, my suggestion to you would be to skip using dataguard
for now until you get comfortable with the concept of the primary and
standbny database. I say this because, I am first start to expirment with
a standby db and understand it.
Here are my instructions for creating a primary and standby DB on the same
machine if you want to follow them:
1) create a DB anyway you like (manually, clone, ...) and call it pri
2) Add the following to your tnsnames.ora and listener.ora file
note: ip_address must be replaceed with a valid ip address
archive logs not get copied on standby database in a dataguard configuration. Reply
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
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
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