This forum is currently locked. You can't register or post questions at this time. (read more)

Temp tablespace on standby database

All posts relating to Oracle database administration.

Moderator: Tim...

royalyogi
Senior Member
Posts: 181
Joined: Tue Apr 23, 2013 3:59 pm

Temp tablespace on standby database

Postby royalyogi » Wed May 01, 2013 6:12 am

Hi Tim,
we are using the dataguard 11.2.0.2 in window server 2008. My questions is here

1.)
Whenever we are making any changes in any tablespaces on primary database, same will reflect on standby database except temp tablespace. Why is not reflecting for temp tablespace on standby database when are we making any changes on temp tablespace on primary database?

2.)I am not able to unlock the account on standby database and shall we do this in primary database.

3.) Query(for Report generation) is running very slow on standby and we need to rebuild the Index to resolve this performance issue. Shall we rebuild the index on primary database?

Please help me here.
RGDS,
Yogi

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Temp tablespace on standby database

Postby Tim... » Wed May 01, 2013 9:21 am

Hi.

1) Changes to temp files are not transmitted to the standby, so you have to do the alterations manually for that.

2) Yes. Actions on the primary are transmitted to the standby. That should be the source of any changes.

3) Yes. As with (2).

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

royalyogi
Senior Member
Posts: 181
Joined: Tue Apr 23, 2013 3:59 pm

Re: Temp tablespace on standby database

Postby royalyogi » Thu May 02, 2013 4:22 am

you are 007 on oracle

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Temp tablespace on standby database

Postby Tim... » Thu May 02, 2013 6:48 am

LOL :)
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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 0 guests

cron