Temporary Datafile created in Primary is missing in the Standby Database 
Temporary Datafile created in Primary is missing in the Standby Database

SYMPTOMS

You created a temporary datafile in the Primary database, but it did not get created in the Standby database.


Solutions

SQL> alter database open read only.

SQL> alter tablespace temp add tempfile '<name>' size ..


Comments

Post a Comment

Popular posts from this blog

ORA-16000 Dropping or Creating Temporary Tablespace In Physical Standby Database Symptomps ORA-16000 Dropping or Creating Temporary Tablespace In Physical Standby Database Cause The follwing example demostrates the issue standby database is open read only mode: sqlplus / as sysdba Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select open_mode from v$database; OPEN_MODE -------------------- READ ONLY WITH APPLY Drop temporary tablespace SQL> drop tablespace Temp; ERROR at line 1: ORA-16000: database or pluggable database open for read-only access Create temporary tablespace: SQL> create temporary tablespace temp  tempfile '/u01/app/oracle/oradata/gpprod/tmp.dbf' size 200m reuse extent management local uniform size 1048576; ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-16000: datab...
Read more