February 5, 2014 archive

TEMPFILE Offline Physical Standby

I received an alert from Enterprise Manager Cloud Control that a tempfile was offline in my physical standby database. Message=The temporary file /u01/app/oracle/oradata/ncpp/temp/temp01.dbf is OFFLINE. We recently did a restore of the standby, i.e. recreated it from a backup. Surprisingly only 7 of the 8 tempfiles were available. One tempfile was missing. I found this …

Continue reading