|
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|