Re-creating the temporary file on the standby server

If this is the first time that the standby database is opened after a switchover or failover, you must re-create the temporary file on the standby server.

To re-create the temporary file on the standby server on Windows

To log into sqlplus, from the command line, type
sqlplus sys/stayout as sysdba
To add a new temp file to F:\DATA\DBASE\SYSTEM, type
alter tablespace TEMP add tempfile 'F:\DATA\DBASE\SYSTEM\TEMP02.DBF' SIZE 500M REUSE;
To bring the original temp file offline and bring the new one online, type
alter database TEMPFILE 'F:\DATA\DBASE\SYSTEM\TEMP01.DBF' OFFLINE;
alter database TEMPFILE 'F:\DATA\DBASE\SYSTEM\TEMP02.DBF' ONLINE;
alter database TEMPFILE 'F:\DATA\DBASE\SYSTEM\TEMP01.DBF' DROP;
To recreate TEMP01.DBF, type
alter tablespace TEMP add tempfile 'F:\DATA\DBASE\SYSTEM\TEMP01.DBF' SIZE 500M REUSE;
To bring TEMP01.DBF online and to drop TEMP02.DBF, type
alter database TEMPFILE 'F:\DATA\DBASE\SYSTEM\TEMP02.DBF' OFFLINE;
alter database TEMPFILE 'F:\DATA\DBASE\SYSTEM\TEMP01.DBF' ONLINE;
alter database TEMPFILE 'F:\DATA\DBASE\SYSTEM\TEMP02.DBF' DROP;

To re-create the temporary file on the standby server on Solaris

To log into sqlplus, from the command line, type
sqlplus sys/stayout as sysdba
To add a new temp file to F:\DATA\DBASE\SYSTEM, type
alter tablespace TEMP add tempfile '/usr/mvf/data/dbase/system/temp02.dbf' SIZE 500M REUSE;
To bring the original temp file offline and bring the new one online, type
alter database TEMPFILE '/usr/mvf/data/dbase/system/temp01.dbf' OFFLINE;
alter database TEMPFILE '/usr/mvf/data/dbase/system/temp02.dbf' ONLINE;
alter database TEMPFILE '/usr/mvf/data/dbase/system/temp01.dbf' DROP;
To recreate TEMP01.DBF, type
alter tablespace TEMP add tempfile '/usr/mvf/data/dbase/system/temp01.dbf' SIZE 500M REUSE;
To bring TEMP01.DBF online and to drop TEMP02.DBF, type
alter database TEMPFILE '/usr/mvf/data/dbase/system/temp02.dbf' OFFLINE;
alter database TEMPFILE '/usr/mvf/data/dbase/system/temp01.dbf' ONLINE;
alter database TEMPFILE '/usr/mvf/data/dbase/system/temp02.dbf' DROP;