Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating Temp Tablespace in Physical Standby DB

540301Oct 2 2009 — edited Oct 2 2009

Hi DBAs,

I have setup the datagurad (physical standby) for single instance to single instance. After I setup the dataguard, I noticed that the temp table space was not created at physical standby as I was not provided the tempfiles for temp table space and I just created the standby control files, mount the database and put it in RECOVER MANAGED STANDBY . I verified it is missing the temp table space.

Please advise - How can I create the temp tablespace at standby. I am using 10.2.0.4 on RHEL 5.1.

Thanks
-Samar-

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 30 2009

Added on Oct 2 2009

#general-database-discussions

9 comments

8,646 views