{"id":13313,"date":"2020-01-17T17:57:51","date_gmt":"2020-01-17T16:57:51","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/"},"modified":"2023-06-15T16:40:21","modified_gmt":"2023-06-15T14:40:21","slug":"dbvisit-9-adding-datafiles-and-or-tempfiles","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/","title":{"rendered":"Dbvisit 9: Adding datafiles and or tempfiles"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

One question I was asking is if the standby_file_management parameter is relevant in a Dbvisit environment with Oracle Standard Edition. I did some tests and I show here what I did.
\nWe suppose that the Dbvisit is already set and that the replication is fine<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n<\/td>\n
\n
\n
[oracle@dbvisit1 trace]$ <\/code>\/u01\/app\/dbvisit\/standby\/dbvctl<\/code> -d dbstd -i<\/code><\/div>\n
=============================================================<\/code><\/div>\n
Dbvisit Standby Database Technology (9.0.08_0_g99a272b) (pid 19567)<\/code><\/div>\n
dbvctl started on dbvisit1: Fri Jan 17 16:48:16 2020<\/code><\/div>\n
=============================================================<\/code><\/div>\n
<\/div>\n
Dbvisit Standby log gap report <\/code>for<\/code> dbstd at 202001171648:<\/code><\/div>\n
-------------------------------------------------------------<\/code><\/div>\n
Description\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | SCN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Timestamp<\/code><\/div>\n
-------------------------------------------------------------<\/code><\/div>\n
Source\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2041731\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2020-01-17:16:48:18 +01:00<\/code><\/div>\n
Destination\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2041718\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2020-01-17:16:48:01 +01:00<\/code><\/div>\n
<\/div>\n
Standby database <\/code>time<\/code> lag (DAYS-HH:MI:SS): +00:00:17<\/code><\/div>\n
<\/div>\n
Report <\/code>for<\/code> Thread 1<\/code><\/div>\n
-------------------<\/code><\/div>\n
SOURCE<\/code><\/div>\n
Current Sequence 8<\/code><\/div>\n
Last Archived Sequence 7<\/code><\/div>\n
Last Transferred Sequence 7<\/code><\/div>\n
Last Transferred Timestamp 2020-01-17 16:48:07<\/code><\/div>\n
<\/div>\n
DESTINATION<\/code><\/div>\n
Recovery Sequence 8<\/code><\/div>\n
<\/div>\n
Transfer Log Gap 0<\/code><\/div>\n
Apply Log Gap 0<\/code><\/div>\n
<\/div>\n
=============================================================<\/code><\/div>\n
dbvctl ended on dbvisit1: Fri Jan 17 16:48:23 2020<\/code><\/div>\n
=============================================================<\/code><\/div>\n
<\/div>\n
[oracle@dbvisit1 trace]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

While the standby_file_management is set to MANUAL on both servers<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n
48<\/div>\n
49<\/div>\n
50<\/div>\n<\/td>\n
\n
\n
[oracle@dbvisit1 trace]$ sqlplus \/ as sysdba<\/code><\/div>\n
<\/div>\n
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 17 16:50:50 2020<\/code><\/div>\n
Version 19.3.0.0.0<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2019, Oracle.\u00a0 All rights reserved.<\/code><\/div>\n
<\/div>\n
<\/div>\n
Connected to:<\/code><\/div>\n
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production<\/code><\/div>\n
Version 19.3.0.0.0<\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> open_mode from <\/code>v<\/code>$database;<\/code><\/div>\n
<\/div>\n
OPEN_MODE<\/code><\/div>\n
--------------------<\/code><\/div>\n
READ WRITE<\/code><\/div>\n
<\/div>\n
SQL> show parameter standby_file_management;<\/code><\/div>\n
<\/div>\n
NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE<\/code><\/div>\n
------------------------------------ ----------- ------------------------------<\/code><\/div>\n
standby_file_management\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 MANUAL<\/code><\/div>\n
SQL><\/code><\/div>\n
<\/div>\n
<\/div>\n
[oracle@dbvisit2 back_dbvisit]$ sqlplus \/ as sysdba<\/code><\/div>\n
<\/div>\n
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 17 16:51:15 2020<\/code><\/div>\n
Version 19.3.0.0.0<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2019, Oracle.\u00a0 All rights reserved.<\/code><\/div>\n
<\/div>\n
<\/div>\n
Connected to:<\/code><\/div>\n
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production<\/code><\/div>\n
Version 19.3.0.0.0<\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> open_mode from <\/code>v<\/code>$database;<\/code><\/div>\n
<\/div>\n
OPEN_MODE<\/code><\/div>\n
--------------------<\/code><\/div>\n
MOUNTED<\/code><\/div>\n
<\/div>\n
SQL>\u00a0 show parameter standby_file_management;<\/code><\/div>\n
<\/div>\n
NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE<\/code><\/div>\n
------------------------------------ ----------- ------------------------------<\/code><\/div>\n
standby_file_management\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 MANUAL<\/code><\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Let\u2019s create a tablespace MYTAB on the primary database<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n<\/td>\n
\n
\n
SQL> create tablespace mytab datafile <\/code>'\/u01\/app\/oracle\/oradata\/DBSTD\/mytab01.dbf'<\/code> size 10M;<\/code><\/div>\n
<\/div>\n
Tablespace created.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n
<\/div>\n
SQL> alter system switch logfile;<\/code><\/div>\n
<\/div>\n
System altered.<\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> name from <\/code>v<\/code>$tablespace;<\/code><\/div>\n
<\/div>\n
NAME<\/code><\/div>\n
------------------------------<\/code><\/div>\n
SYSAUX<\/code><\/div>\n
SYSTEM<\/code><\/div>\n
UNDOTBS1<\/code><\/div>\n
USERS<\/code><\/div>\n
TEMP<\/code><\/div>\n
MYTAB<\/code><\/div>\n
<\/div>\n
6 rows selected.<\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> name from <\/code>v<\/code>$datafile;<\/code><\/div>\n
<\/div>\n
NAME<\/code><\/div>\n
--------------------------------------------------------------------------------<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/system01<\/code>.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/sysaux01<\/code>.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/undotbs01<\/code>.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/mytab01<\/code>.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/users01<\/code>.dbf<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

A few moment we can see that the new datafile is replicated on the standby<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>select<\/code> name from <\/code>v<\/code>$tablespace;<\/code><\/div>\n
<\/div>\n
NAME<\/code><\/div>\n
------------------------------<\/code><\/div>\n
SYSAUX<\/code><\/div>\n
SYSTEM<\/code><\/div>\n
UNDOTBS1<\/code><\/div>\n
USERS<\/code><\/div>\n
TEMP<\/code><\/div>\n
MYTAB<\/code><\/div>\n
<\/div>\n
6 rows selected.<\/code><\/div>\n
<\/div>\n
SQL>\u00a0 <\/code>select<\/code> name from <\/code>v<\/code>$datafile<\/code><\/div>\n
\u00a0\u00a0<\/code>2\u00a0 ;<\/code><\/div>\n
<\/div>\n
NAME<\/code><\/div>\n
--------------------------------------------------------------------------------<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/system01<\/code>.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/sysaux01<\/code>.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/undotbs01<\/code>.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/mytab01<\/code>.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/users01<\/code>.dbf<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now let\u2019s repeat the tablespace creation while the parameter is set to AUTO on both side<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n<\/td>\n
\n
\n
SQL> show parameter standby_file_management;<\/code><\/div>\n
<\/div>\n
NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE<\/code><\/div>\n
------------------------------------ ----------- ------------------------------<\/code><\/div>\n
standby_file_management\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 AUTO<\/code><\/div>\n
SQL>\u00a0 create tablespace mytab2 datafile <\/code>'\/u01\/app\/oracle\/oradata\/DBSTD\/mytab201.dbf'<\/code> size 10M;<\/code><\/div>\n
<\/div>\n
Tablespace created.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n
<\/div>\n
SQL> alter system switch logfile;<\/code><\/div>\n
<\/div>\n
System altered.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

A few moment later the tablespace mytab2 was also replicated on the standby<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>select<\/code> name from <\/code>v<\/code>$tablespace;<\/code><\/div>\n
<\/div>\n
NAME<\/code><\/div>\n
------------------------------<\/code><\/div>\n
SYSAUX<\/code><\/div>\n
SYSTEM<\/code><\/div>\n
UNDOTBS1<\/code><\/div>\n
USERS<\/code><\/div>\n
TEMP<\/code><\/div>\n
MYTAB<\/code><\/div>\n
MYTAB2<\/code><\/div>\n
<\/div>\n
7 rows selected.<\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> name from <\/code>v<\/code>$datafile;<\/code><\/div>\n
<\/div>\n
NAME<\/code><\/div>\n
--------------------------------------------------------------------------------<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/system01<\/code>.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/mytab201<\/code>.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/sysaux01<\/code>.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/undotbs01<\/code>.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/mytab01<\/code>.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/users01<\/code>.dbf<\/code><\/div>\n
<\/div>\n
6 rows selected.<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

In Dbvisit documentation <\/a> we can find this
\nNote 2:<\/strong> This feature is independent of the Oracle parameter STANDBY_FILE_MANAGEMENT. Dbvisit Standby will detect if STANDBY_FILE_MANAGEMENT has added the datafile to the standby database, and if so, Dbvisit Standby will not add the datafile.
\nNote 3:<\/strong> STANDBY_FILE_MANAGEMENT can only be used in Enterprise Edition and should not be set in Standard Edition.<\/em><\/p>\n

Dbvisit does not use STANDBY_FILE_MANAGEMENT for datafile replication. So I decide to set this value to its default value which is MANUAL.<\/p>\n

What about adding tempfile in a dbvisit environment. In the primary I create a new temporary tablespace<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n<\/td>\n
\n
\n
SQL> show parameter standby_file_management;<\/code><\/div>\n
<\/div>\n
NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TYPE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VALUE<\/code><\/div>\n
------------------------------------ ----------- ------------------------------<\/code><\/div>\n
standby_file_management\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0\u00a0\u00a0\u00a0\u00a0 MANUAL<\/code><\/div>\n
SQL> create temporary tablespace temp2 tempfile <\/code>'\/u01\/app\/oracle\/oradata\/DBSTD\/temp2_01.dbf'<\/code> size 10M;<\/code><\/div>\n
<\/div>\n
Tablespace created.<\/code><\/div>\n
<\/div>\n
SQL> alter system switch logfile;<\/code><\/div>\n
<\/div>\n
System altered.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can see on the primary that we now have two tempfiles.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>select<\/code> name from <\/code>v<\/code>$tablespace;<\/code><\/div>\n
<\/div>\n
NAME<\/code><\/div>\n
------------------------------<\/code><\/div>\n
SYSAUX<\/code><\/div>\n
SYSTEM<\/code><\/div>\n
UNDOTBS1<\/code><\/div>\n
USERS<\/code><\/div>\n
TEMP<\/code><\/div>\n
MYTAB<\/code><\/div>\n
MYTAB2<\/code><\/div>\n
TEMP2<\/code><\/div>\n
<\/div>\n
8 rows selected.<\/code><\/div>\n
<\/div>\n
SQL>\u00a0 <\/code>select<\/code> name from <\/code>v<\/code>$tempfile;<\/code><\/div>\n
<\/div>\n
NAME<\/code><\/div>\n
--------------------------------------------------------------------------------<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/temp01<\/code>.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/temp2_01<\/code>.dbf<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

On standby side, the new temporary tablespace was replicated.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>select<\/code> name from <\/code>v<\/code>$tablespace;<\/code><\/div>\n
<\/div>\n
NAME<\/code><\/div>\n
------------------------------<\/code><\/div>\n
SYSAUX<\/code><\/div>\n
SYSTEM<\/code><\/div>\n
UNDOTBS1<\/code><\/div>\n
USERS<\/code><\/div>\n
TEMP<\/code><\/div>\n
MYTAB<\/code><\/div>\n
MYTAB2<\/code><\/div>\n
TEMP2<\/code><\/div>\n
<\/div>\n
8 rows selected.<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

But the new tempfile is not listed on the standby<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
SQL>\u00a0 <\/code>select<\/code> name from <\/code>v<\/code>$tempfile;<\/code><\/div>\n
<\/div>\n
NAME<\/code><\/div>\n
--------------------------------------------------------------------------------<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/temp01<\/code>.dbf<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

In fact it\u2019s the expected behavior. In the documentation we can find following
\nIf your preference is to have exactly the same number of temp files referenced in the standby control file as your current primary database, then once a new temp file has been added on the primary, you need to recreate a standby control file by running the following command from the primary server:
\ndbvctl -f create_standby_ctl -d DDC <\/em><\/p>\n

So let\u2019s recreate the standby control file<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
[oracle@dbvisit1 ~]$ <\/code>\/u01\/app\/dbvisit\/standby\/dbvctl<\/code> -f create_standby_ctl -d dbstd<\/code><\/div>\n
=>Replace current standby controfiles on dbvisit2 with new standby control<\/code><\/div>\n
file<\/code>?\u00a0 [No]: <\/code>yes<\/code><\/div>\n
<\/div>\n
>>> Create standby control <\/code>file<\/code>... <\/code>done<\/code><\/div>\n
<\/div>\n
>>> Copy standby control <\/code>file<\/code> to dbvisit2... <\/code>done<\/code><\/div>\n
<\/div>\n
>>> Recreate standby control <\/code>file<\/code>... <\/code>done<\/code><\/div>\n
<\/div>\n
>>> Standby controfile(s) on dbvisit2 recreated. To complete please run dbvctl on the<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>primary, <\/code>then<\/code> on the standby.<\/code><\/div>\n
[oracle@dbvisit1 ~]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And then after we can verify that the new tempfile is now visible at standby side<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>select<\/code> name from <\/code>v<\/code>$tempfile;<\/code><\/div>\n
<\/div>\n
NAME<\/code><\/div>\n
--------------------------------------------------------------------------------<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/temp01<\/code>.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/DBSTD\/temp2_01<\/code>.dbf<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw One question I was asking is if the standby_file_management parameter is relevant in a Dbvisit environment with Oracle Standard Edition. I did some tests and I show here what I did. We suppose that the Dbvisit is already set and that the replication is fine 1 2 3 4 5 6 7 […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,59],"tags":[1798,1650,459,1799,1800],"type_dbi":[],"class_list":["post-13313","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-oracle","tag-datfiles","tag-dbvisit-9","tag-oracle-standard-edition","tag-standby_file_management","tag-tempfiles"],"acf":[],"yoast_head":"\nDbvisit 9: Adding datafiles and or tempfiles - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dbvisit 9: Adding datafiles and or tempfiles\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw One question I was asking is if the standby_file_management parameter is relevant in a Dbvisit environment with Oracle Standard Edition. I did some tests and I show here what I did. We suppose that the Dbvisit is already set and that the replication is fine 1 2 3 4 5 6 7 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-17T16:57:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-15T14:40:21+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Dbvisit 9: Adding datafiles and or tempfiles\",\"datePublished\":\"2020-01-17T16:57:51+00:00\",\"dateModified\":\"2023-06-15T14:40:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/\"},\"wordCount\":357,\"commentCount\":0,\"keywords\":[\"datfiles\",\"dbvisit 9\",\"Oracle Standard Edition\",\"standby_file_management\",\"tempfiles\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/\",\"name\":\"Dbvisit 9: Adding datafiles and or tempfiles - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2020-01-17T16:57:51+00:00\",\"dateModified\":\"2023-06-15T14:40:21+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dbvisit 9: Adding datafiles and or tempfiles\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Dbvisit 9: Adding datafiles and or tempfiles - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/","og_locale":"en_US","og_type":"article","og_title":"Dbvisit 9: Adding datafiles and or tempfiles","og_description":"By Mouhamadou Diaw One question I was asking is if the standby_file_management parameter is relevant in a Dbvisit environment with Oracle Standard Edition. I did some tests and I show here what I did. We suppose that the Dbvisit is already set and that the replication is fine 1 2 3 4 5 6 7 […]","og_url":"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/","og_site_name":"dbi Blog","article_published_time":"2020-01-17T16:57:51+00:00","article_modified_time":"2023-06-15T14:40:21+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Dbvisit 9: Adding datafiles and or tempfiles","datePublished":"2020-01-17T16:57:51+00:00","dateModified":"2023-06-15T14:40:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/"},"wordCount":357,"commentCount":0,"keywords":["datfiles","dbvisit 9","Oracle Standard Edition","standby_file_management","tempfiles"],"articleSection":["Database Administration & Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/","url":"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/","name":"Dbvisit 9: Adding datafiles and or tempfiles - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2020-01-17T16:57:51+00:00","dateModified":"2023-06-15T14:40:21+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-9-adding-datafiles-and-or-tempfiles\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Dbvisit 9: Adding datafiles and or tempfiles"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=13313"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13313\/revisions"}],"predecessor-version":[{"id":25957,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13313\/revisions\/25957"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=13313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=13313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=13313"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=13313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}