undo tablespace on standby db

All posts relating to Oracle database administration.

Moderator: Tim...

undo tablespace on standby db

Postby Raaj A » Mon Apr 01, 2013 3:06 pm

Hi Tim,

My production database is on oracle11g on windows 2008 R2 and i have setup datagaurd.My undo tablespace got full and i created another undo tablespace named undotbs1 and make it default on primary database. i have kept standby_file_management to auto. when i checked on standby database it is still showing old undo table space. i changed in pfile and created spfile from pfile and restarted the standby database still it is showing me old undo tablespace on standby database. Please suggest what can be done so that standby database should point to new undo tablespace.


please help.


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

Re: undo tablespace on standby db

Postby Tim... » Mon Apr 01, 2013 3:28 pm

Hi.

Changes to tempfile are not copied to the standby.

You can had different tempfile configuration on the primary and standby databases. It's a feature.

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: 17955
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 2 guests