In a datagaurd environment(setup on oracle 10gR2 in win2k3 server) where primary and standby is already sync. when i create new tablespace ,datafile, adding new user ( changes happens in oracle password file) on primary site, how to again sync my standby database.
It's a long time since I worked on 10g Data Guard, but as I remember it, all DDL is transferred, so all te changes, including the password in the password file are run on the standby automatically.
If the passwordfile is not getting updated, you can always copy the one from the primary database.
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://oracle-base.com
My blog: http://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 11 guests