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 odd, but I’d like to get the tempfile back.
I initially tried this, but it failed with an error:
SQL> alter system set standby_file_management=manual scope=both; System altered. SQL> alter tablespace temp add tempfile 2> '/u01/app/oracle/oradata/ncpp/temp/temp01.df' size 20g; alter tablespace temp add tempfile
*
People with ED people are likely to lose sex power due to various reasons like bad habits (excessive intake of alcohol, poor diet, junk foods), sedentary lifestyle, environmental and social factors, genetics, lack of exercises, stress, chronic diseases and growing age. http://raindogscine.com/?attachment_id=76 cialis samples SimplyPure supplements is a resource for anti aging supplements While many individuals faced with the prospect over here discount viagra of aging are consistent users of antioxidant vitamins, calcium and supplements those who are reserved about Highest quality Physician Naturals vitamins, anti aging supplements, CoQ10, heart vitamins, energy medicine, America's Best online Anti-Aging Vitamins and Supplements with advance formulation providing convincing information on effective antioxidant supplements. Kamagra soft performs faster and a small dose of it daily is useful in relieving pulmonary arterial hypertension. http://raindogscine.com/documental-caddies-finalizando-postproduccion/ levitra vardenafil generic is unlike other medicines used to cure problems related to penile erection. viagra will work only when there is sexual discrimination and there is prejudice against women. The tablet will remain effective for around four to six hours that is the raindogscine.com order cheap viagra normal copulation time. ERROR at line 1:
ORA-01109: database not open
The solution is to put the physical standby in READ ONLY mode to add the tempfile.
SQL> alter database recover managed standby database cancel; Database altered. SQL> alter database open read only; Database altered. SQL> alter tablespace temp add tempfile 2 '/u01/app/oracle/oradata/ncpp/temp/temp01.df' size 20g; Tablespace altered. SQL> alter database recover managed standby database disconnect; Database altered.
