Standby db sync after changing in primary db

All posts relating to Oracle database administration.

Moderator: Tim...

Standby db sync after changing in primary db

Postby Raaj A » Fri Jan 04, 2013 6:18 am

Hi Tim,

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.

Please suggest..


Thanks
Raaj
Raaj A
Member
 
Posts: 49
Joined: Wed Mar 07, 2012 7:08 am

Re: Standby db sync after changing in primary db

Postby Tim... » Fri Jan 04, 2013 8:52 am

Hi.

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.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17970
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 9 guests