Overview Adding the Temp File on the primary database of a data guard environment only adds the tablespace entry to the standby, it doesn’t create a temp file associated with the temporary tablespace. So, we need to create temp file manually to the standby Database. Let’s start to learn how to add the temp file In Data Guard Environment. I recommended, applying this process for Oracle Database 12c Release 1 and Release 2 and also for Oracle Database 19c and 21c link . Lab Environment Primary Server Standby Server OS Release Red Hat Enterprise Linux release 8.3 (Ootpa) Red Hat Enterprise Linux release 8.3 (Ootpa) Kernel 4.18.0-240.8.1.el8_3.x86_64 4.18.0-240.8.1.el8_3.x86_64 Release Oracle Database 12.1.0.2.0 Oracle Database 12.1.0.2.0 IP Address 192.168.201.241 10.100.20.242 Host Name dg1 dg2 User Name Admin Admin Data Guard Environment Primary Database Standby Database Oracle Release Oracle Database 12.1.0.2.0 Oracle Database 12.1.0.2.0 SQL*Plus Release 12.1.0.2.0 Release 12.1.0.2.0 D
Every Alphabet is Informative.