Database Software

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!

Temp space not getting created in Standby database

user10402186Oct 26 2009 — edited Oct 27 2009

Hi Experts

I had created the standby database using Rman duplicate command.Every thing is fine and all parameters are correct.
The issue is only with the temp space.The temp tablespace got created logically on the standby Databse.But the tempfile related to that temp tablespace is not getting created at O/S level.How to get that os file.My team member suggested that using DD unix command we can create the temp.dbf file.

Can any body let me know the command how to create the temp.dbf at o/s level

the logical temp file name showing on database is "/u01/app/oracle/admin/Map/data/temp.dbf' on mount point I am not able to see physically.

Note:I can not see the temp.dbf file at oslevel on standby database.

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 24 2009

Added on Oct 26 2009

#performance-availability, #recovery-manager-rman

6 comments

1,717 views